Eureka! You the man, Kris! -----Original Message----- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 7:40 PM To: CF-Talk Subject: Re: Problem with SQL Insert
I think you need to not have your column names quoted like that. Try this: <cfquery name="Ins_1" datasource-"XXXXX"> INSERT CDN100 (Date_Added,Name,Title,Company,Phone,Email) VALUES( #Now()#, <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#FORM.fullname#">, etc., etc. ) </cfquery> Cheers, Kris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294274 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
