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.
--=_401828E9.34553DF5
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
I have a textarea and would like to search on more than 1 column. The =
code does not seem to work with more than 1 word. What I am missing?
<CFIF form.searchtext NEQ "">
AND (0=3D1
<CFLOOP index=3D"line" list=3D"#searchtext#" delimiters=3D"#CRLF#">
OR (0=3D0
<cfloop index=3D"word" list=3D"#line#" delimiters=3D" ">
AND reps.County LIKE '%#word#%'=20
OR reps.State LIKE '%#word#%'=20
OR reps.Country LIKE '%#word#%'
OR reps.SoftwareContact LIKE '%#word#%'=20
OR reps.TechRep LIKE '%#word#%'=20
OR reps.OpGroup LIKE '%#word#%'=20
</cfloop>
)
</cfloop>
)
</CFIF>
Thanks for oyur help.
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
--=_401828E9.34553DF5
Content-Type: text/plain
Content-Disposition: attachment; filename="David Clay.vcf"
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Clay, David
TEL;WORK:(303) 967-1558
ORG:;Engineering Automation Group
TEL;PREF;FAX:(303) 770-8506
EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED]
N:Clay;David
TITLE:Web Facilitator
X-GWUSERID:clayd
END:VCARD
--=_401828E9.34553DF5--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
