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#')</cfquery>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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
