on 2000-09-14 3:27 PM, avex at [EMAIL PROTECTED] wrote:
> However,.....what if i want to show 2 reviews.....ID 7 and ID 9.
>
> how do i show this....
> and how would i construct a dynamic query that would allow for multiple
> ID's....(a cfloop?)
Store the IDs in a comma delimited list and use:
<CFQUERY Name="aoyama" Datasource="super">
SELECT Storename, ID, City
FROM review
Where ID IN (#ID_LIST#)
</CFQUERY>
HTH
Rob Keniger [EMAIL PROTECTED]
____________________________________________________________________________
big bang solutions
<http://www.bigbang.net.au> p +61 7 3311 2733 f +61 7 3311 2744
____________________________________________________________________________
------------------------------------------------------------------------------
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.
