charlie, jochem, mike, and joe i upgraded the server to 6.1 patch, and all is well.
musta been something with 6.1 less the patch. thanks for your help! tw On Sat, 18 Dec 2004 20:49:42 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote: > gotcha.... thanks for the help, im going to get into the code again > tomorow, as ive been wholly engulfed in football today :) > > tw > > On Sat, 18 Dec 2004 15:55:34 -0700, Charlie Griefer > <[EMAIL PROTECTED]> wrote: > > granted, i'm grasping...i just recall pre-updated versions having > > issues with single quotes and cfqueryparam... > > > > > > On Sat, 18 Dec 2004 14:17:56 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote: > > > not sure, at the moment, i can dig around later, and find that out, > > > but would a version matter with something simple? > > > > > > tw > > > > > > On Sat, 18 Dec 2004 09:20:36 -0700, Charlie Griefer > > > <[EMAIL PROTECTED]> wrote: > > > > Tony - > > > > > > > > you said this exact code works fine on another machine? Are they both > > > > on MX 6.1? > > > > > > > > > > > > On Sat, 18 Dec 2004 10:39:49 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote: > > > > > joe, charlie, and everyone else.... here is the code... > > > > > > > > > > <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> > > > > > > > > > > and here is the error... > > > > > > > > > > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL > > > > > Server Driver][SQL Server]Line 21: Incorrect syntax near > > > > > ','. > > > > > > > > > > -- perplexed as shit, on a saturday mo'nin > > > > > > > > > > tw > > > > > > > > > > > > > > > On Fri, 17 Dec 2004 23:44:27 -0500, Joe Rinehart <[EMAIL PROTECTED]> > > > > > wrote: > > > > > > As Jochem said....can you paste the exact code, and the SQL shown > > > > > > for > > > > > > the query in the CF debugging info? > > > > > > > > > > > > -joe > > > > > > > > > > > > -- > > > > > > For Tabs, Trees, and more, use the jComponents: > > > > > > http://clearsoftware.net/client/jComponents.cfm > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188872 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
