This error usually occurs when a variable resolves empty. e.g. "AND
DATAMAP.MEMBER_TYPE =3D #session.membertype#" where session.membertype is empty
"".
Check for the length of all your variables before you pass it to the query.
I hope that was clear enough.
-- Bruce
> -----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
