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. how

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 like() is used

RE: [sqlite] escaping and % in sql statements

2004-01-27 Thread Drew, Stephen
So how does SQLite distinguish between the built-in: { like, 2, SQLITE_NUMERIC, likeFunc }, and a user-defined function such as { like, 2, SQLITE_NUMERIC, my_like_function }, then? -Original Message- From: Mrs. Brisby [mailto:[EMAIL PROTECTED] Sent: Tuesday,

RE: [sqlite] escaping and % in sql statements

2004-01-27 Thread Mrs. Brisby
Calling sqlite_create_function() overrides builtin functions. On Tue, 2004-01-27 at 07:36, Drew, Stephen wrote: So how does SQLite distinguish between the built-in: { like, 2, SQLITE_NUMERIC, likeFunc }, and a user-defined function such as { like, 2,