But that would make NULL a string instead of a NULL value ... Paul Giesenhagen QuillDesign
----- Original Message ----- From: "Dave Wilson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:13 AM Subject: RE: CFMX/mySQL Query Problem > Paul, > > At first glance I think you've omitted single quotes around the largetext > value i.e. the first NULL in your values list below should be 'NULL' > > Dave > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: 11 February 2003 15:12 > To: CF-Talk > 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
