Tony, I think your problem may be a stray comma, not an apostrophe:
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL > Server Driver][SQL Server]Line 21: Incorrect syntax near > ','. would read "Incorrect syntax near ','"....I'd make sure you didn't include an extra comma after your second cfQueryParam, like this: <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.company#">, <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.contact#">, ...I do it all the time when copying/pasting the things. -Joe On Fri, 17 Dec 2004 17:15:20 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote: > hi there. > > im perplexed and too tired to mess with this anymore... > > ive got a cfmx box, that for some reason when i try to insert a > value that happens to have a ' in it... like "Tony's" which has a single > quote... well, ive never had this problem before, and i know i have another > server that its works fine on??? > > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL > Server Driver][SQL Server]Line 21: Incorrect syntax near > ','. > > is what im getting, and yes, im using cfqueryparam. > > ------------------- > > <cfquery name="insertClient" username="#application.username#" > password="#application.password#" datasource="webCollect"> > insert into clients > (company, contact) > values > (<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.company#">, > <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.contact#"> > ) > </cfquery> > > ------------------- > > -- > tony > > Tony Weeg > > macromedia certified coldfusion mx developer > email: tonyweeg [at] gmail [dot] com > blog: http://www.revolutionwebdesign.com/blog/ > cool tool: http://www.antiwrap.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188115 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
