Recordset does not return expected results

Here it is....
http://www.fwzone.net/showDetail.asp?NewsId=394&ZoneId=1


Thanks to you guys for trying.



Ted

Tryusing Tom Muck's nested recordset extension.

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET

Really cannot tell from the info below. A sample of the data and the
actual queries, especially the second one, would be helpful.


Ted Dawson wrote:

> DW 8.02 - ASP/VBScript/Access -
> I have a page with two recordsets. The first recordset correctly
> returns 2 rows from the database. The second recordset relies on a
> variable set from a value returned in the first recordset, but will
> only return the rows associated with the first value from the first
> recordset; it does not return the row associated with the second row
> in the first recordset. I have the repeat regions... could I get a
> clue from someone?
>
>
> 1st recordset -
> Select column1 from table1 where blah blah
> Correctly returns two rows
>
> 2nd recordset
> Select columnA from table2 where ColumnB = Table1.Column1
> Returns only the first result from first recordset
>
> Also tried this -
> 2nd recordset
> Select columnA from table2 where ColumnB in (Select Column1 from
> Table1) Returns only the first result from first recordset



--