still having a problem with insert

2004-02-25 Thread Steven Sharko
Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values

RE: still having a problem with insert

2004-02-25 Thread Dave Watts
Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert

RE: still having a problem with insert

2004-02-25 Thread Marlon Moyer
are right, I am being selfish, but the last time I checked, we don't have a whole lot of songs that feature the cowbell! -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:38 AM To: CF-Talk Subject: still having a problem with insert

Re: still having a problem with insert

2004-02-25 Thread stas
Steven, you may need to surrround some of your insert values with single quotes as it seems judging from variable names that they are strings. - Original Message - From: Steven Sharko To: CF-Talk Sent: Wednesday, February 25, 2004 9:37 AM Subject: still having a problem with insert

Re: still having a problem with insert

2004-02-25 Thread cf
like ppl keep saying the word type is a reserved word and WONT work u will have 2 rename that field in your database, no ands, ifs or buts about it. read this, straight from the mothership http://www.macromedia.com/support/ultradev/ts/documents/insert_into.htm Error Executing Database Query.

RE: still having a problem with insert

2004-02-25 Thread Mark A. Kruger - CFG
- like the promise of mass rail transit. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:38 AM To: CF-Talk Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket

RE: still having a problem with insert

2004-02-25 Thread Steven Sharko
:00apos;}apos;,apos;Service Ticket 3173 - apos;,apos;brSubmitted by apos;,apos;tapos;,) At 09:49 AM 2/25/2004, you wrote: Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver

RE: still having a problem with insert

2004-02-25 Thread Mark A. Kruger - CFG
AM To: CF-Talk Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert

Re: still having a problem with insert

2004-02-25 Thread Jamie Jackson
Yup, that's a mess alright. Looks like your form might be screwy as well, or had some html in a field, or something. Check your form, fix your text field values in the sql (wrap them with single quotes). And once you've done that, don't use that SQL :P Instead, use the cfqueryparam version that I

RE: still having a problem with insert

2004-02-25 Thread Mark A. Kruger - CFG
-02-25 09:49:00apos;}apos;,apos;Service Ticket 3173 - apos;,apos;brSubmitted by apos;,apos;tapos;,) At 09:49 AM 2/25/2004, you wrote: Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access

RE: still having a problem with insert

2004-02-25 Thread Ian Skinner
A trick I used in the my youth to help me learn: Since you are using Access, use the query builder in Access to build the query, then change the view to SQL view and copy the SQL code from there and paste into your Cold Fusion cfquery... tag.A few simple modifications to incorporate the form

RE: still having a problem with insert

2004-02-25 Thread Philip Arnold
From: [EMAIL PROTECTED] like ppl keep saying the word type is a reserved word and WONT work u will have 2 rename that field in your database, no ands, ifs or buts about it. read this, straight from the mothership http://www.macromedia.com/support/ultradev/ts/documents/insert _into.htm