Problem with revExecuteSQL - More

[Dave]

Hi,

I am using SQLIte, I can't seem to find anything that says what the  
escape sequence character is. Does anyone know if this is possible  
with SQLite?

Also, is this the same problem that I am getting with the ":"  
characters in the date field? If so, is the solution the same?

Thanks a lot
All the Best
Dave


On 1 Nov 2007, at 09:03, Jan Schenkel wrote:

> --- Dave <dave at looktowindward.com> wrote:
>> Hi,
>>
>> I am also getting an [unrecognized token: "") "]
>> error, in this case
>> this is the string I pass in:
>>
>> [snip]
>>
>> Thanks a lot
>> All the Best
>> Dave
>>
>
> Hi Dave,
>
> Looking at your query, I'd say the following string is
> the culprit:
>    "Finally (7"Choice Mix)"
> Whether you use an apostrophe or a quote to delineate
> strings, you must escape them if they occur inside the
> string.
>
> How to escape them depends a bit on the database. Some
> will want you to 'double' the character to escape it.
> Others want a backslash or even a tilde in front of
> the offending character.
>
> Hope this helped,
>
> Jan Schenkel.
>
> Quartam Reports & PDF Library for Revolution
> <http://www.quartam.com>
>
> =====
> "As we grow older, we grow both wiser and more foolish at the same  
> time."  (La Rochefoucauld)
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution