nested repeat region

S

shank

I'm trying to use code I found on:
http://www.dmxzone.com/ShowDetail.asp?NewsId=394&offset=5

I've used it before without issue, but this time it's not working. The
nested records are not being filtered. They are all displayed on the very
first request. <%=FilterParam%> shows that the correct KeyNumber is
requested, but still all records are displayed.
Can anyone see what I'm missing?
thanks!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
<%
While ((Repeat1__numRows <> 0) AND (NOT rsItemKey.EOF))
%>
<%=(rsItemKey.Fields.Item("Descrip").Value)%><br>
#<%=(rsItemKey.Fields.Item("KeyNumber").Value)%>&nbsp;&nbsp;&nbsp;&nbsp;Reg
Price&nbsp;<%=
FormatCurrency((rsItemKey.Fields.Item("RegPrice").Value), -1, -2, -2, -2)
%>&nbsp;&nbsp;&nbsp;&nbsp;<%=
FormatCurrency((rsItemKey.Fields.Item("Price").Value), -1, -2, -2, -2)
%><br>

<%
FilterParam = rsItemKey.Fields.Item("KeyNumber").Value
rsItemKeyProducts.Filter = "rsItemKeyProducts.KeyNumber = " & FilterParam
While (NOT rsItemKeyProducts.EOF)
%>
<%=(rsItemKeyProducts.Fields.Item("OrderNo").Value)%><%=FilterParam%><br>
<%
rsItemKeyProducts.MoveNext()
Wend
%>

<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsItemKey.MoveNext()
Wend
%>
 
S

shank

never mind - found it
rsItemKeyProducts.Filter = "KeyNumber = '" & FilterParam & "'"
Code originally designed for numeric key fields
Mine are alpha-numeric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,768
Messages
2,569,574
Members
45,048
Latest member
verona

Latest Threads

Top