Recordset Filter question - Nested repeat region

[doc]

Hi,

I am using Tom Steepers Tutorial to nest a recordset found here....
[url]http://www.dmxzone.com/ShowDetail.asp?NewsId=394[/url]


Does anyone know how I can use a seond variable on a recordset.filter
????? I know their is one more than one recordset involved here but
the different variable all display fine. It is a syntax problem on the
line marked with the >>>>>> below.

Thanks.

Code Sample

<%
FilterParam3 = Recordset1.Fields.Item("MenuID").Value
FilterParam4 = MenuSections.Fields.Item("MenuSectionID").Value

>>>>>>Dishes.Filter = "MenuID = " & FilterParam3 & " & MenuSectionID =

"& FilterParam4
While (NOT Dishes.EOF)
%>
<tr>
<td
class="txtBrown">&nbsp;<%=(Dishes.Fields.Item("Dis hName").Value)%></td>
<td>&nbsp;<%=filterparam5%></td>
<td>&nbsp;</td>
</tr>
<%
Dishes.MoveNext()
Wend
%>

[doc]

SORRY......

I was missing the AND in the sql statement......







doc wrote:

> Hi,
>
> I am using Tom Steepers Tutorial to nest a recordset found here....
> [url]http://www.dmxzone.com/ShowDetail.asp?NewsId=394[/url]
>
>
> Does anyone know how I can use a seond variable on a recordset.filter
> ????? I know their is one more than one recordset involved here but
> the different variable all display fine. It is a syntax problem on the
> line marked with the >>>>>> below.
>
> Thanks.
>
> Code Sample
>
> <%
> FilterParam3 = Recordset1.Fields.Item("MenuID").Value
> FilterParam4 = MenuSections.Fields.Item("MenuSectionID").Value

> >>>>>>Dishes.Filter = "MenuID = " & FilterParam3 & " & MenuSectionID =

> "& FilterParam4
> While (NOT Dishes.EOF)
> %>
> <tr>
> <td
> class="txtBrown">&nbsp;<%=(Dishes.Fields.Item("Dis hName").Value)%></td>
> <td>&nbsp;<%=filterparam5%></td>
> <td>&nbsp;</td>
> </tr>
> <%
> Dishes.MoveNext()
> Wend
> %>