Don't put single quote marks around cfqueryparam. The cfqueryparam tag will handle this aspect of the insert for you. From the looks of the error you're getting this may very well be your problem.
And the ID field is text, right? Cuz it has marks around its value? Just thought I'd ask about that one. Cheers, -------------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -------------------------------------------- -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 7:19 AM To: CF-Talk Subject: Re: CFMX/mySQL Query Problem Lets try that one again! (copy and paste just didn't cut it) I have a query that is giving a generic error and I cannot see what hte problem is ... below you will see the insert statement and the generic error. This is running on mySQL 3.2x and Windows XP, the #variables.urlRoot# is http://localhost/ <cfquery datasource="#form.dsn#" name="step1" username="#form.dbUserName#" password="#form.dbPassword#">insert into settings(id,datatype,smalltext,largetext,numberdata,datedata,edit_date,a dmin _user) values('36','urlRoot','<cfqueryparam value="#variables.urlRoot#" cfsqltype="CF_SQL_VARCHAR">',NULL,NULL,NULL,NULL,'#form.adminUser#')</cf quer y> What the insert looks like: values('36','urlRoot',' (param 1) ',NULL,NULL,NULL,NULL,'admin') are the values being put into the database. It errors out and gives the following error: Error Executing Database Query. Cannot convert class java.lang.String to SQL type requested Any help would be greatly appreciated! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:11 AM Subject: CFMX/mySQL Query Problem > I have a query that is giving a generic error and I cannot see what hte problem is ... below you will see the insert statement and the generic error.This is running on mySQL 3.2x and Windows XP, the #variables.urlRoot# is http://localhost/<cfquery datasource="#form.dsn#" name="step1" username="#form.dbUserName#" password="#form.dbPassword#">insert into settings(id,datatype,smalltext,largetext,numberdata,datedata,edit_date,a dmin _user) values('36','urlRoot','<cfqueryparam value="#variables.urlRoot#" cfsqltype="CF_SQL_VARCHAR">',NULL,NULL,NULL,NULL,'#form.adminUser#')</cf quer y>values('36','urlRoot',' (param 1) ',NULL,NULL,NULL,NULL,'admin') are the values being put into the database.It errors out and gives the following error:Error Executing Database Query. Cannot convert class java.lang.String to SQL type requested Any help would be greatly appreciated!Paul GiesenhagenQuillDesign > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
