I think Matt R had the solution I had the quotes around the <cfqueryparam>
... testing it now ... we need the queryparam ... seems that my sql doesn't
like the \ so this cfquery param fixes that issue.
Thanks!
Paul Giesenhagen
QuillDesign
----- Original Message -----
From: "Stephen Moretti" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:35 AM
Subject: Re: CFMX/mySQL Query Problem
> 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
