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.
--=_257E372A.91F090A0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
The following is a Select statement that giving me errors. The CF error =
documetation is below.
Any help would be greatly apprciated. Thank you
Select Statement
___________________________
<CFSET CRLF=3D"#Chr(13)##Chr(10)#">
<cfquery name=3D"getPDFInfo" datasource=3D"#DS#">
SELECT PDFs.RecID, PDFs.LitName, PDFs.ReorderNo, PDFs.AppID, PDFs.LastRevi=
sed, PDFs.FileSize,PDFs.LocID,*,*
FROM PDFs, DCLocation,DCApplication
WHERE 0=3D0
AND PDFs.AppID=3DDCApplication.AppID
AND PDFs.LocID=3DDCLocation.LocID
<CFIF #form.ReorderNo# NEQ 'All'>
AND PDFs.ReorderNo LIKE '%#form.ReorderNo#%'
</CFIF>
<CFIF #form.OpGroup# NEQ 'Q' AND #form.OpGroup# NEQ 'All'>
AND PDFs.AppID IN (#form.OpGroup#)
</CFIF>
<CFIF #form.Country# NEQ 'Q' AND #form.Country# NEQ 'All'>
AND PDFs.LocID IN (#form.Country#)
</CFIF>
<CFIF #form.searchtext# NEQ ''>
AND (0=3D1
<CFLOOP index=3D"line" list=3D"#form.searchtext#" delimiters=3D"#CRLF#">
OR (0=3D0
<CFLOOP index=3D"word" list=3D"#line#">
AND (PDFs.Keywords LIKE '%#word#%'
OR PDFs.LitName LIKE '%#word#%')
</cfloop>
)
</cfloop>
)
</CFIF>=20
AND Available=3D'Yes'
<CFIF #form.ReorderNo# NEQ "">
ORDER BY PDFs.ReorderNo
<CFELSE>
ORDER BY PDFs.LitName
</cfif>
</CFQUERY>
Error Statement
________________________________________
Template: D:\CFTJ\literature\PDFSearchAction.cfm
Error Diagnostics:=20
An error occurred while evaluating the expression:=20
#form.ReorderNo# IS NOT 'All'
Error near line 9, column 23.=20
Error resolving parameter FORM.REORDERNO=20
The specified form field cannot be found. This problem is very likely due =
to the fact that you have misspelled the form field name.=20
The error occurred while processing an element with a general identifier =
of (CFIF), occupying document position (9:1) to (9:36).
Date/Time: 11/29/00 11:58:22 11:58 AM
Browser: Mozilla/4.0 (compatible; MSIE 5.0; AOL 5.0; Windows 98; DigExt)
Remote Address: 198.81.23.9
Referrer:=20
QueryString:=20
HTTP_COOKIE: CFID=3D30714; CFTOKEN=3D13969484; count=3D2=20
=09
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
--=_257E372A.91F090A0
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
--=_257E372A.91F090A0--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
