Hi, All,
One of the fields (property.type)in my query contains a comma-delimited list
of numbers (1,3,4)
I have a lookup table (types) that consists of two fields: ID and Name.
Now, I need to replace numbers in Property.type with names from Type.Name.
How could that be done with ColdFusion?
-----------
The reason I am doing it this way is because I get an empty recordset if I
try to do it in SQL:
SELECT Property.ID, Property.Type, Type.ID, Type.Name
FROM properties
WHERE str(type.id) in ('property.type')
I would definately prefer the SQL solution...
Cyrill
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
