问题描述

asp根据typeid直接输出对应内容，无需url get传值

 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 传值才显示对应的

解决方案

 查找替换
Request.QueryString("typeid")
->
"x"

解决方案二：

自己解决了，定义了下typeid，没想到这么简单，谢谢大家关注！

解决方案三：

直接写死

sql="Select * from FreeHost.FreeHost_IDCProductlist where  istg=0 and canbyenduser='y' and typeid='1'  and (onlyusebyagn is null or onlyusebyagn='"&agentname&"')  order by orderbyid desc"