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
