Forums

ASP

This topic is locked

nested repeat regions

Posted 18 Jul 2002 18:04:14
1
has voted
18 Jul 2002 18:04:14 shank mcmullen posted:
I'm having problems following the advice for nested repeat regions.
Hopefully someone has run into the same thing.
www.udzone.com/showDetail.asp?TypeId=2&NewsId=394
I'm querying all records from the db for the sake of ease and testing.
The common field between 2 recordsets would be OrderNo.

This is the code I'm using...
<%
While ((Repeat1__numRows <> 0) AND (NOT rsRecordset1.EOF))
%>
<table>
<tr>
<td><%=(rsRecordset1.Fields.Item("Label".Value)%></td>
</tr>
<tr>
<td>
<%
FilterParam = rsRecordset1.Fields.Item("OrderNo".Value
rsRecordset2.Filter = "OrderNo = " & FilterParam
While (NOT rsRecordset2.EOF)
%>
<%=(rsRecordset2.Fields.Item("OrderNo".Value)%>
<%
rsRecordset2.MoveNext()
Wend
%>
</td>
</tr>
</table>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsRecordset1.MoveNext()
Wend
%>

This is the error I'm getting...
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/search/zzmytest.asp, line 56

Any suggestions?
Thanks!

Reply to this topic