You forgot the pound signs, and you misread me (or did I mistype?)
use:
values(#preserveSingleQuotes(vals)#)
========================================================================
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
Email : [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Ray Regno [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 11, 2003 1:35 PM
> To: CF-Talk
> Subject: trouble with single quotes
>
>
> if i do this:
>
> insert into tab_#tabName# #cols# values
> (preserveSingleQuotes(#vals#))
>
> i get this:
>
>
> ODBC Error Code = S1000 (General error)
>
>
> [MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-00907: missing
> right parenthesis
>
>
> SQL = "insert into tab_pat (pid, mcn, foundry, package,
> dieconfig, productid, project_alias, technology, sirev,
> user_comment, username, flag) values
> (preserveSingleQuotes(sq_pat.nextval, 9, 2, 2, 2, 1, 1, 2, 1,
> ''I AM EDITED COPYlkjk'',1,0))"
>
> Data Source = "DAD"
>
> **************************************************
>
> if i do this:
>
> insert into tab_#tabName# #cols# values
> (#preserveSingleQuotes(#vals#)#)
>
> i get this:
>
> Just in time compilation error
>
> Invalid parser construct found on line 2 at position 67.
> ColdFusion was looking at the following text:
>
> #
> Invalid expression format. The usual cause is an error in the
> expression structure. The last successfully parsed CFML
> construct was static text occupying document position (2:36)
> to (2:44).
>
>
>
>
>
>
>
> >By default, CF "helps" you by escaping single quotes. You
> want to tell
> >CF to _not_ do that, so you want to wrap (#vals#) with
> >(#preserveSingleQuotes(vals)#)
> >
> >=============================================================
> ==========
> >=
> >===
> >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> >(www.mindseye.com)
> >Member of Team Macromedia
> (http://www.macromedia.com/go/teammacromedia)
> >
> >Email :
> [EMAIL PROTECTED]
> >Blog : www.camdenfamily.com/morpheus/blog
> >Yahoo IM : morpheus
> >
> >"My ally is the Force, and a powerful ally it is." - Yoda
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
