Where ID IN (#ID_1#,#ID_2#)
At 3:27 PM +1000 9/14/00, avex wrote:
>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.
