<%
sCat = Request.QueryString("mcatid")
If sCat = "" Then
sCat = 59
End If
sCatname = Request.QueryString("catnm")
if sCatname = "" Then
sCatname = "Skin Care"
End If
response.Write("" & sCatName & "")
sSql = "Select * from PRODUCT_MASTER where CAT_ID = " & sCat
Set rs = myconn.Execute(sSql)
While not rs.EOF
%>
<%
rs.movenext
Wend
rs.Close
myconn.Close
%>
|