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
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
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
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
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.
- 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
: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
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
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
-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
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
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
12 matches
Mail list logo