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:237797
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
