p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: General SQL Question


Message #1 by "Nadia Hamza" <hamzan@h...> on Wed, 6 Dec 2000 17:48:01 -0000
Hi,



Is it possible to do one sql statement and get those records and then do

another sql statement on the records you received from the previous query.

Thanks for your help.



Nadia

Message #2 by Robert Chartier <rchartierh@a...> on Wed, 06 Dec 2000 13:15:15 -0500
Look at the .FILTER property of the recordset object

http://www.aspfree.com/devlinks/search.asp?file404=ado;sdk#ADO



Example

http://www.aspfree.com/devlinks/search.asp?file404=filter-array-isapi#ADO









At 12:48 PM 12/6/00, you wrote:

>Hi,

>

>Is it possible to do one sql statement and get those records and then do

>another sql statement on the records you received from the previous query.

>Thanks for your help.

>

>Nadia

>



Robert Chartier

Author, AspFree.com

xxx-xxx-xxxx

rchartierh@a...

http://www.aspfree.com/devlinks

http://www.aspfree.com/authors/robert

http://www.aspalliance.com/nothingmn



Message #3 by "Harsh Nandu" <harsh_stgil@h...> on Thu, 07 Dec 2000 06:23:04 -0000
I don't think so.

It's better to create a single query to take care of both the conditions for 

performance reasons too.





>From: "Nadia Hamza" <hamzan@h...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] General SQL Question

>Date: Wed, 6 Dec 2000 17:48:01 -0000

>

>Hi,

>

>Is it possible to do one sql statement and get those records and then do

>another sql statement on the records you received from the previous query.

>Thanks for your help.

>

>Nadia

>


  Return to Index