Remove the %'s
> -----Original Message-----
> From: Double Down, Inc. [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 11 December 2002 10:05 a.m.
> To: CF-Talk
> Subject: Query Question
>
>
> I have this statement in a query:
>
> (<cfloop index="ii" list="#form.seeking#"
> delimiters=",">seeking LIKE '%#ii#%'<cfif NOT
> listlast(form.seeking, ",") is ii> and </cfif></cfloop>
>
> It will select the record if the field (a comma delimitated
> list) has the value (the values are number). The problem I am
> having is that if I want to pull the records that contain the
> number 2, it is giving me the records that contain 2, 22, 23,
> etc. etc. How do I set this up so it will pull ONLY the
> records that have the number 2 in it?
>
> TIA
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
