Your list:
"1 ,2 ,3 ,4 "
you trim the list
"1 ,2 ,3 ,4"
You look for 1 in the list. Its not found. The first value is 1(space).
You look for 4 in the list, Its found.
Try:
<!--- Create List from Database --->
<cfset idlist = #Trim(valueList(InsPlans.BTNTYPE))#>
<cfset idlist = replace(idlist," ,",",","ALL")>
(replace all the (space)(comma)s with just commas)
See if that helps
Jerry Johnson
>>> [EMAIL PROTECTED] 12/05/03 11:05AM >>>
Yeah it has a space after it but I tried to Trim it off or replace it with a
"," and still I can't get it to work same result. Also it will find the last
item in the list but it's not recognizing the other elements. I'm missing
something simple. It's the simple things that really mess me up sometimes.
Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
