Hi Megan,
You said:
|<CFQUERY DATASOURCE="data" NAME="mq_our">
|SELECT prod_num,bead
|FROM mq_our FOR all malaID in the �sessions� table where the sessionID
|matches this current sessionID
|</CFQUERY>
You could try something like this.
##### mq_our_list.cfm ####
<CFQUERY DATASOURCE="data" NAME="mq_our">
SELECT prod_num,bead
FROM mq_our
WHERE malaID IN (SELECT malaID FROM sessions WHERE SessionID =
'#SessionID#')
</CFQUERY>
|Thanks in advance for any help!
|Megan
No bother.
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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
