You have to write a piece of code that plucks out each number indivually and
builds a query on the fly to collect these records:
<cfquery name="get_pages" (better leave out datasources etc:-))>
SELECT * FROM file
WHERE id = '0' (dummy)
<cfloop index="i" list="url.catid" delimiter=",">
AND id = '#i#'
</cfloop>
</cfquery>
Something like this should work...
Regards,
Anthony Geoghegan
Lead Developer,
IFTN
www.wow.ie
-----Original Message-----
From: Joel Firestone [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2000 14:04
To: [EMAIL PROTECTED]
Subject: Selecting one number from a list
Everyone:
I'm having a complete brain fart, so hopefully you guys can help.
I have a table with a varchar field named catid. When a url variable named
catid is passed, the page grabs all the data for that specific catid. Simple
stuff.
My problem lies in now I need for the catid to be a list (2,5,56,89). Thus
the
varchar field, and not a numeric. How can I select those items that contain
the correct url.catid? I tried the IN keyword, with no success.
Any help would be greatly appreciated.
Joel
------------------------------------------------------------------------------
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.
