Re: sql insert statement

David, It looks like you have an extraneous ] at the end of your query. Steve Bryant 918-449-9440 Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ I'm not functioning here: Error Executing Database Query. [Macromedia][SQLServer JDBC

Re: sql insert statement

You have an extra ] at the end of your sql statement. '#form.charge_category#', '#form.comments_employee#')] 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

Re: sql insert statement

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

Re: sql insert statement

you have an extra closing bracket ( ] ) at the very end of the statement , '#form.comments_employee#')] /cfquery 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

Re: sql insert statement

Hi Dave You appear to have a closing bracket at the end of your values insert: '#form.comments_employee#')] -- note the closing bracket. Try this: cfquery name=creditcard datasource=creditcard insert into card_information ( [date of entry], [date of charge], [vendor name], [amount of

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

RE: sql insert statement

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

SQL insert statement and transaction logs

Is there any difference in using 'INSERT' instead of 'INSERT INTO'? I was told 'INSERT INTO' statements don't get logged in the transaction log and can't be rolled back. I always thought that the 'INTO' keyword was optional and really didn't affect anything. Regards, Dave Bosky Sr. Multimedia