hey everyone....

i have always used the following SQL statement to show a particular database
entry.

<CFQUERY Name="aoyama" Datasource="super">
SELECT Storename, ID, City
FROM review
Where ID = #ID#
</CFQUERY>


where i passed the ID from the url or form or whatever.

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?)

this is killing me!

i am going to buy Forta's SQL book today..

thanks

chad



------------------------------------------------------------------------------
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.

Reply via email to