Problem with revExecuteSQL - More

[Dave]

Hi Jan,

Thanks a lot, yes, a great help, Where exactly did you see the  
description of how to do this in the SQLite docs? I had a quick look  
again but still couldn't find it!

Thanks again
All the Best
Dave

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

> --- Dave <dave at looktowindward.com> wrote:
>> 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
>>
>
> Hi Dave,
>
> I took a quick glance at the sqlite.org website:
> <http://www.sqlite.org/lang_expr.html>
> where they advise you to use apostrophe instead of
> quote, and that you should double the apostrophe when
> it occurs within the string.
>
> As for the colon, try using apostrophe first instead
> of quotes. SQLite doesn't have real date-time fields
> so they're stored as strings anyway.
>
> 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