Problem with revExecuteSQL - More

Jan Schenkel janschenkel at yahoo.com
Thu Nov 1 05:03:54 EDT 2007


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



More information about the use-livecode mailing list