[thelist] CF Problem - banging my head against the wall!!!!
Katie Howell
khowell at digital.net
Tue, 30 Nov 1999 03:11:59 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_0038_01BF3AE0.AA8213C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a simple CF form where on submission the contents are inserted =
into a database.
Easy enough right??? I've done these a million times without a problem, =
but suddenly with this form I'm consistantly getting the dreaded:
Error Diagnostic Information
ODBC Error Code =3D 37000 (Syntax error or access violation)=20
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO =
statement.=20
The error occurred while processing an element with a general identifier =
of (CFQUERY), occupying document position (14:1) to (14:27).=20
Date/Time: 11/30/99 02:59:53
Browser: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)
Remote Address: 127.0.0.1
HTTP Referer: http://localhost/irsb/forms/paf.cfm
Template: C:\Inetpub\wwwroot\irsb\forms\paf_insert.cfm
I have carefully checked my code and database for mispellings, extra # ' =
characters etc., but can't see the problem. If there are a few brave =
souls out there that are willing to take a look at the templates for me, =
I'll be glad to email them off-list. =20
Thanks in advance,
Katie
------=_NextPart_000_0038_01BF3AE0.AA8213C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>I have a simple CF form where on =
submission the=20
contents are inserted into a database.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Easy enough right??? I've done =
these a=20
million times without a problem, but suddenly with this form I'm =
consistantly=20
getting the dreaded:</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>
<H4>Error Diagnostic Information</H4>
<P>ODBC Error Code =3D 37000 (Syntax error or access violation)=20
<P>
<P>[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT =
INTO=20
statement.=20
<P>
<P>
<P>The error occurred while processing an element with a general =
identifier of=20
(CFQUERY), occupying document position (14:1) to (14:27). </P>
<P>
<P>Date/Time: 11/30/99 02:59:53<BR>Browser: Mozilla/4.0 (compatible; =
MSIE 4.01;=20
Windows 98)<BR>Remote Address: 127.0.0.1<BR>HTTP Referer:=20
http://localhost/irsb/forms/paf.cfm<BR>Template:=20
C:\Inetpub\wwwroot\irsb\forms\paf_insert.cfm</P>
<P>I have carefully checked my code and database for mispellings, extra =
# '=20
characters etc., but can't see the problem. If there are a few =
brave souls=20
out there that are willing to take a look at the templates for me, I'll =
be glad=20
to email them off-list. </P>
<P>Thanks in advance,</P>
<P>Katie</P>
<P> </P>
<P> </P>
<P> </P></FONT></DIV></BODY></HTML>
------=_NextPart_000_0038_01BF3AE0.AA8213C0--