RE: [sqlite] escaping " and % in sql statements

2004-01-27 Thread Mrs. Brisby
gt; > { "like", 2, SQLITE_NUMERIC, my_like_function }, > > then? > > -Original Message- > From: Mrs. Brisby [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 27, 2004 12:27 PM > To: [EMAIL PROTECTED] > Cc: D. Richard Hipp; [EMAIL PROT

RE: [sqlite] escaping " and % in sql statements

2004-01-27 Thread Drew, Stephen
MAIL PROTECTED] Sent: Tuesday, January 27, 2004 12:27 PM To: [EMAIL PROTECTED] Cc: D. Richard Hipp; [EMAIL PROTECTED] Subject: Re: [sqlite] escaping " and % in sql statements On Mon, 2004-01-26 at 09:08, [EMAIL PROTECTED] wrote: > "D. Richard Hipp" <[EMAIL PROTECTED]> writes

Re: [sqlite] escaping " and % in sql statements

2004-01-27 Thread Mrs. Brisby
On Mon, 2004-01-26 at 09:08, [EMAIL PROTECTED] wrote: > "D. Richard Hipp" <[EMAIL PROTECTED]> writes: > > > As an interim workaround, you could defined your own > > "like()" function using the sqlite_create_function() API > > that implemented built-in escapes. Any user-defined > > function named

Re: [sqlite] escaping " and % in sql statements

2004-01-27 Thread Dunnigan Pierce
thanks, that worked like a charm. tim --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: Dunnigan Pierce wrote: > hi, sorry if this has been asked before or is hidden somewhere in the > documentation. couldn't find an archive of this list to search through and > couldn't find it in the docs.

RE: [sqlite] escaping " and % in sql statements

2004-01-26 Thread Hrissimir Neikov
> how do you escape " and % in sqlite? in other dbs you can do > something like: > > select * from mytable where myfield like "%100[%]%"; > or > select * from mytable where myfield like "%100\%%"; > but neither seem to work with sqlite Try this: select * from mytable where myfield like "%100%%"

Re: [sqlite] escaping " and % in sql statements

2004-01-26 Thread Derrell . Lipman
"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > As an interim workaround, you could defined your own > "like()" function using the sqlite_create_function() API > that implemented built-in escapes. Any user-defined > function named "like()" is used to implement the LIKE > keyword of SQL. That see

Re: [sqlite] escaping " and % in sql statements

2004-01-26 Thread D. Richard Hipp
Dunnigan Pierce wrote: > hi, sorry if this has been asked before or is hidden somewhere in the > documentation. couldn't find an archive of this list to search through and > couldn't find it in the docs. > > how do you escape " and % in sqlite? in other dbs you can do something like: > > > select

[sqlite] escaping " and % in sql statements

2004-01-25 Thread Dunnigan Pierce
hi, sorry if this has been asked before or is hidden somewhere in the documentation. couldn't find an archive of this list to search through and couldn't find it in the docs. how do you escape " and % in sqlite? in other dbs you can do something like: select * from mytable where myfield like