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
