Should be: insert into tab_#tabName# #cols# values (#preserveSingleQuotes(vals)#)
Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com Ray Regno wrote: > > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
