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.
Sebastian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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