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 <[EMAIL PROTECTED]> 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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
