Again, turn on your debugging; it's a great help to see the SQL statement
that CF is submitting to the db.
My first guess is that one or more of your db fields are text, meaning that
the #form...# tags must be surrounded with single quotes.
-----Original Message-----
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 3:45 PM
To: CF-Talk
Subject: Form Error #2
This is a MIME message. If you are reading this text, you may want to
consider changing to a mail reader or gateway that understands how to
properly handle MIME multipart messages.
--=_CB90D9C4.ED8CECDC
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
I am getting the following error from some browsers. ANy help would be =
appreciated. Thank you
Error:
____________________________________
Template: D:\CFTJ\datachunk\dclookup_action.cfm
Error Diagnostics:ODBC Error Code =3D 37000 (Syntax error or access =
violation)=20
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the =
keyword 'AND'.=20
The error occurred while processing an element with a general identifier =
of (CFQUERY), occupying document position (4:2) to (4:46).
Date/Time: 11/29/00 09:38:12 09:38 AM
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Remote Address: 159.233.5.44
Referrer: http://www.tjm.com/datachunk/categories.cfm
QueryString:=20
HTTP_COOKIE: CFID=3D30693; CFTOKEN=3D45012402; count=3D7=20
=09
Select Statement
________________________________________________________
<cfset session.categories=3D#form.categories#>
=20
=20
<cfquery name=3D"DataChunks" datasource=3D"TJdb">
SELECT DISTINCT DATAMAP.DC_ID,DATAMAP.USE_TYPE, DATAMAP.PROJECT_LOCATION, =
DATAMAP.PROJECT_TYPE, DATAMAP.MEMBER_TYPE, DATAMAP.DATA_CHUNK, DATAMAP.DCNA=
ME
FROM DATAMAP=20
WHERE DATAMAP.DATA_CHUNK =3D #session.categories#
AND DATAMAP.MEMBER_TYPE =3D #session.membertype#
AND DATAMAP.PROJECT_TYPE =3D #session.projecttype#
AND DATAMAP.PROJECT_LOCATION =3D #session.location#
AND DATAMAP.USE_TYPE =3D #session.usetype#
</cfquery>
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
--=_CB90D9C4.ED8CECDC
Content-Type: text/plain
Content-Disposition: attachment; filename="David Clay.vcf"
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Clay, David
EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED]
TEL;PREF;FAX:(303) 770-8506
X-GWUSERID:clayd
ADR;DOM;WORK;PARCEL;POSTAL:;Denver
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Clay, David=0A=
Denver
ORG:;Engineering Automation Group
N:Clay;David
TEL;WORK:(303) 967-1558
TITLE:Web Facilitator
END:VCARD
--=_CB90D9C4.ED8CECDC--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
