Set dsIDClist = Server.CreateObject("ADODB.Recordset")
Sql="Select * from FreeHost.FreeHost_IDCProductlist where istg=0 and canbyenduser='y' and (onlyusebyagn is null or onlyusebyagn='"&agentname&"') order by orderbyid desc"
if agentname<>"n" then Sql="Select * from FreeHost.FreeHost_IDCProductlist where istg=0 and canbyagnenduser='y' and (onlyusebyagn is null or onlyusebyagn='"&agentname&"') order by orderbyid desc"
if Request.QueryString ("typeid")<>"" and IsNumeric(Request.QueryString("typeid")) then Sql="Select * from FreeHost.FreeHost_IDCProductlist where istg=0 and canbyenduser='y' and typeid='"&Request.QueryString("typeid")&"' and (onlyusebyagn is null or onlyusebyagn='"&agentname&"') order by orderbyid desc"
if Request.QueryString ("typeid")<>"" and IsNumeric(Request.QueryString("typeid")) and agentname<>"n" then Sql="Select * from FreeHost.FreeHost_IDCProductlist where istg=0 and canbyagnenduser='y' and typeid='"&Request.QueryString("typeid")&"' and (onlyusebyagn is null or onlyusebyagn='"&agentname&"') order by orderbyid desc"
根据typeid=x直接输出内容,不需要url get传值,怎么改呢,现在是要?typeid=x 传值才显示对应的