2009/12/16 Kurt D. Knudsen <kknud...@zystemsgo.com>:
> Hi guys,
>
> I've been searching high and low for a solution to this, but haven't
> found anything that I fully understand. Right now, I'm inserting text
> into a database that contains single quotes and backslashes. Is there a
> function that will properly escape these characters so they will be
> inserted properly?
>
> For example:
>
> sprintf(query, "INSERT INTO db (file) VALUES ('John's Document.txt');");
>
> Obviously, I can escape it manually, but when I'm reading files from a
> directory listing, I'd need a function to escape it properly. I see that
> there's some SQLite3 QUOTE or ESCAPE clause/function, but I can't find
> any information on it.http://www.sqlite.org/lang_corefunc.html#quote > > Thanks, > > Kurt Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
