would be to alter the stored proc and do the trimming there. To do it in CF,
you'd do something like:
<cfset cleanlist = "">
<cfloop from="1" to="#listlen(insplans.btntype)#" index="i">
<cfset cleanlist = listappend(cleanlist, trim(i))>
</cfloop>
-d
----- Original Message -----
From: "Bailey, Neal" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 10:28 AM
Subject: RE: ListFind(Problems)
> Ok I think I figured this out kind of...
>
> It does seem to be a Spacing problem but I am still having an issue with
> trying to remove the trailing spaces. I am using Trim() but it does not
seem
> to be doing anything. Could this be because I'm pulling this from a Stored
> Procedure?
>
> Here is how I'm trimming it...
>
> <cfset idlist=#Trim(valueList(InsPlans.BTNTYPE))#>
>
>
> Neal Bailey
> Internet Marketing Manager
> UGA-Association Field Services
> E-mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: Bailey, Neal [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 05, 2003 10:05 AM
> To: CF-Talk
> Subject: RE: ListFind(Problems)
>
> 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]
>
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 05, 2003 9:51 AM
> To: CF-Talk
> Subject: RE: ListFind(Problems)
>
>
> Is your list really X(space),Y(space),Z? If so, the issue is that X is not
> the same as X(space).
> _____
> _____
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
