|
<%intRow = 0
if not rsCat.Eof then
Do while not rsCat.eof
if intRow mod 2 = 0 and intRow <> 0 then
response.write " | "
end if
strSQL = "Select * from tblService where CategoryId =" & rsCat("CategoryId") & " order By Name"
set rs = GetRecords(strSQL)
response.write "" & trim(rsCat("Name")) & " "%>
|
<%If not rs.eof then
Do while not rs.eof%>
<%rs.movenext
loop
else%>
<%end if
set rs = Nothing%>
|
<%intRow = intRow+ 1
rsCat.movenext
Loop
else
response.Write "No Categories found. "
end if
set rsCat = Nothing
%>
|