Joe Lanier <[email protected]> wrote: > I am in the process of moving data from flat files to a sqlite > database. I first search through a row and replace ' with '' for > such occurrence as o'riley/joe's. My assumption was that for each > column I could bookend each column with a ' like '123' and that will > allow the data to pass to the proper column in the database(this > particular table all the columns are of a type text/varchar). But I > have columns/fields that contain /, or - somewhere in the column and > they are being rejected.
What precisely does "rejected" mean? What error do you get? This is a perfectly valid string literal that SQLite doesn't have any problems with: 'a''b/c-d' Having said that, it's better to use parameterized queries instead, then you won't need to worry about quotes. See http://www.sqlite.org/c3ref/bind_blob.html Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
