It is a string, it is misleading though. It is the <cfqueryparam> .... again still waiting, but I am sure that is the issue.
Thanks Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Dave Wilson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:52 AM Subject: RE: CFMX/mySQL Query Problem > Yes sorry my bad, however the error message is pointing out a problem with > datatypes. How about id field? is that a string or a value? because you're > trying to insert it as a string although it looks like it should be a value > to me. > > Dave > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: 11 February 2003 15:21 > To: CF-Talk > Subject: Re: CFMX/mySQL Query Problem > > > 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
