you have a trailing "]" behind the VALUES clause. That would be my guess.
On 4/14/06, David Elliott <[EMAIL PROTECTED]> wrote:
> 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:237810
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
