Shawn,
Yes, I know that is true.
With a framework that is properly spread out however, often the
inner query does not even know that the outer one is active.
The situation: list a bunch of hits from the database to be
displayed in a table.
1) the query is constructed and handed to the
Don Huff <[EMAIL PROTECTED]> wrote on 03/01/2005 02:33:34 PM:
> Hi,
>
> I am wanting to write a nesting of queries without having to
> retrieve all the records of the first query (because of the volume).
>
>
>
> res1 = query(db, sql1, USE_DATA);
> while (row1 = fetch_row(res1)
Hi,
I am wanting to write a nesting of queries without having to
retrieve all the records of the first query (because of the volume).
res1 = query(db, sql1, USE_DATA);
while (row1 = fetch_row(res1))
{ res2 = query(db, sql2_function_of(row1);
row2 = fetch_row(res2, USE_DATA);