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 <[EMAIL PROTECTED]> 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
[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
