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,admin _user) values('36','urlRoot','<cfqueryparam value="#variables.urlRoot#" cfsqltype="CF_SQL_VARCHAR">',NULL,NULL,NULL,NULL,'#form.adminUser#')</cfquer 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,admin _user) values('36','urlRoot','<cfqueryparam value="#variables.urlRoot#" cfsqltype="CF_SQL_VARCHAR">',NULL,NULL,NULL,NULL,'#form.adminUser#')</cfquer 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
