A couple of things, the most likely being the extra ] you have at the end of line 18. The other, less likely it the / in the column name of employee / comments, but I think it's the first problem as you've wrapped the column names.
Adrian -----Original Message----- From: David Elliott [mailto:[EMAIL PROTECTED] Sent: 14 April 2006 20:14 To: CF-Talk Subject: sql insert statement I'm not functioning here: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near ']'. The error occurred in C:\Inetpub\wwwroot\DaveActionForm.cfm: line 18 16 : <cfquery name="creditcard" datasource="creditcard"> 17 : insert into card_information([date of entry], [date of charge], [vendor name], [amount of charge], [credit card number], [charge category], [employee / comments]) 18 : values('#form.dateofentry#', '#form.date_of_charge#', '#form.vendor_name#', #form.amount_of_charge#, '#form.credit_card_number#', '#form.charge_category#', '#form.comments_employee#')] 19 : </cfquery> 20 : ---------------------------------------------------------------------------- ---- SQL insert into card_information([date of entry], [date of charge], [vendor name], [amount of charge], [credit card number], [charge category], [employee / comments]) values('4/14/06', '12/31/06', 'whodunit', 0.00, '6167', 'food', '')] DATASOURCE creditcard ---------------------------- any comments or guidance appreciated! Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
