Paul Giesenhagen wrote:
>
> <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>
Loose the quotes around the cfqueryparam.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
