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.
--=_752E5B07.214027F8
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Can the query below be written any better? Some browsers (Win 98) are =
getting stuck and producing an error on <CFIF ReorderNo IS NOT "All">.
Thank you for your time.
<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 ReorderNo IS NOT "All">
AND PDFs.ReorderNo LIKE '%#form.ReorderNo#%'
</CFIF>
<CFIF OpGroup NEQ "Q" AND OpGroup NEQ "All">
AND PDFs.AppID IN (#form.OpGroup#)
</CFIF>
<CFIF Country NEQ "Q" AND Country NEQ "All">
AND PDFs.LocID IN (#form.Country#)
</CFIF>
<CFIF 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 ReorderNo NEQ "">
ORDER BY PDFs.ReorderNo
<CFELSE>
ORDER BY PDFs.LitName
</cfif>
</CFQUERY>
<CFIF #form.ReorderNo# EQ "" AND #form.OpGroup# EQ "Q" AND #form.Country#=
EQ "Q" AND #form.searchtext# EQ "">
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
--=_752E5B07.214027F8
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
--=_752E5B07.214027F8--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
