> -----Original Message-----
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 3:31 PM
> To: CF-Talk
> Subject: ValueList() in CF 4.5
>
>
>
> The ValueList function in CF 4.5.1 inserts a space between values
> using the
> default delimiter.
>
> The table column has the following values: '3.1' and '3.2'
>
> When I do a query and use the ValueList function
>
> RoleID = ValueList(Query.Column)
>
> it outputs as
>
> 3.1 ,3.2
>
> with an extra space.
>
> As a result using ListFind(RoleID, '3.1') gives a 0
>
> Is this the way it is supposed to work? I would think that the extra space
> is not needed. I can't remember now if CF 4.0 did this too.
>
My guess is that the data type you are using in your database is the problem; it is
probably adding extra spaces to the value in the field.
- Andy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
