How to query a seperate recordset ??

[NOPOPNOSTYLE]

Hi there

I'm using Dreamweaver MX to write a page to pull back a query from Access 2000. In Access the query I want to pull is back query4, however queries 1 2 and 3 are sub queries of 4.

Normally in the asp page I would write Select * from query 3 where field Y is = "Form Variable". No problems here, the problem is that query 1 takes forever to run without a critera/Filter, that filter is the form variable.

So my question is can I run query1 (RS1) with the equals to from variable bit, lock it and then pull back query 4 (RS4) which would run query1 (RS1) with the Form variable stilll being applied ?????

Many Thanks

Lord Exell

 

[DreXor]

if you're using access, you can use queries in the DB just as recordsets froma table, make the queries the way you want in the DB then call the query like you would a table from ADO/SQL statements

basically in your access DB make query1, 2, & 3 in the DB calling references from each other, then request your recordset from query3 like ...

SQL = "Select * from Query3"

hope the info helps.