Hi Jon,
Jon Wrote:
|Hey, I need to figure out how to loop though a list and
|perform a query for
|each value returned in the list. Any ideas?
You can get a query to select all the records with an entry contained in a
comma delimited list so:
<cfquery name="select_text">
SELECT stuff FROM stuff_list
WHERE stuff_id IN (#stuff_id_list#)
</cfquery>
Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]
NOTICE:
This communication is confidential. The copyright in this communication
belongs to Ireland Film & Television Net (IFTN) or a third party.
If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.
Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.
Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.