----- Original Message -----
From: "Dick Applebaum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 3:58 PM
Subject: Re: sql query
>
> 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>
CFQUERY Name="aoyama" Datasource="super">
SELECT Storename, ID, City
FROM review
Where ID in (7,9)
</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/cf-talk@houseoffusion.com/
> 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.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
