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
> <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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294273
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
