Re: Nesting Query Calls

2005-03-01 Thread Don Huff
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

Re: Nesting Query Calls

2005-03-01 Thread SGreen
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)

Nesting Query Calls

2005-03-01 Thread Don Huff
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);