[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
InstantDB: single quotes in imported data
- To: instantdb@enhydra.org
- Subject: InstantDB: single quotes in imported data
- From: "David H. Young" <david.young@lutris.com>
- Date: Tue, 28 Nov 2000 09:21:20 -0800
- Reply-To: instantDB@enhydra.org
- Sender: owner-instantDB@enhydra.org
ScriptTool is choking on single quotes when I do an import from a tab delimited file. I reduced the import1.txt file to a single line containing 2 single quotes. I tried escaping the single quotes with "\" to no avail. How do I pre-process single quotes? Thanks, David Connected to jdbc:idb:jack.prp Driver InstantDB JDBC Driver Version Version 3.21 sql1.txt DROP TABLE Subscriber sql1.txt IMPORT Subscriber FROM "import1.txt" USING "import_format.txt" Error importing line 1 david@lutris.com David Young Joe's Garage no It's been a great day. java.sql.SQLException: java.sql.SQLException: Column Contact cannot accept value s been a great day. at org.enhydra.instantdb.db.Table.addRowAtRow(Table.java, Compiled Code) -- David H. Young Chief Evangelist Lutris Technologies, Inc. 1200 Pacific Avenue, Suite 300 Santa Cruz, CA 95060 USA 831.460.7310; 831.471.9754 (fax) http://www.lutris.com http://www.enhydra.org ----------------------------------------------------------------------------- To unsubscribe from this mailing list, send email to majordomo@enhydra.org with the text "unsubscribe instantdb" in the body of the email. If you have other questions regarding this mailing list, send email to the list admin at owner-instantdb@enhydra.org. |
- Prev by Date: InstantDB: Re: InstantDB's Licensing and Open Source Status
- Next by Date: InstantDB: RE: InstantDB's Licensing and Open Source Status
- Prev by thread: InstantDB: RE: InstantDB's Licensing and Open Source Status
- Next by thread: Re: InstantDB: single quotes in imported data
- Index(es):
