ahh..i see. i didn't notice to take the pound sides out around the 'vals' variable. it works now. THANKS!
At 02:35 PM 7/11/2003 -0500, you wrote: >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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
