Its daft and people will shout at me, but try this instead :
<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', '#variables.urlRoot#', NULL, NULL, NULL, NULL,
'#form.adminUser#')
</cfquery>
ie. without the cfqueryparam.
Regards
Stephen
----- Original Message -----
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 3:18 PM
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,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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
