a=100
sql_100="select * from productclass where pid in ("
showcata(pp)
sql_100=sql_100&a&")"
function showcata(id)
sql1="select * from productClass where pid=" & id
set rs1=conn.execute(sql1)
while not rs1.eof
id=rs1("id")
sql_100=sql_100&id&","
showcata(id)
rs1.movenext
wend
end function