This would have worked but I decided to have the IT Folks change the Stored
Procedure to trim when it inserts the data. This fixed it. Yippeee!...
Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the named addressee you should not disseminate, distribute or
copy this e-mail. Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are hereby notified that
disclosing, copying, distributing or taking any action in reliance on the
contents of this information is strictly prohibited. Thank you.
-----Original Message-----
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:35 AM
To: CF-Talk
Subject: RE: ListFind(Problems)
I can see why the last one works, but not the others.
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]
