帮忙看一下这段asp代码的超链接传值错在那里

来源:百度知道 编辑:UC知道 时间:2024/04/30 05:37:08
<%
dim startime,conn,connstr,db,rs,rs_s,rs_s1
startime=timer()
db="DataBase/###EC0703.V6017#.asp"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
'connstr = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Password=123456;Persist Security Info=False;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
set rs=server.createobject("adodb.recordset")
rs.open "select * from EC_smallclass where E_BigClassID=15 ",conn,1,1
do while not rs.eof
Response.Write("<table><tr><td><a href=""E_SmallClass.asp?E_typeid="&trim(rs("E_typeid")")&""E_BigClassID="&trim(rs("E_bigclassid"))&""E_SmallClassID="&trim(rs("E_smallclassid"))&""

trim(rs("E_typeid")")多了个双引号,改成trim(rs("E_typeid"))应该就好了

你好,你那可能是对于链接的符号有点问题,你把那个超链接改成这样再试试,
<a href="E_SmallClass.asp?E_typeid='&trim(rs("E_typeid")")&'+E_BigClassID='&trim(rs("E_bigclassid"))&'+E_SmallClassID='&trim(rs("E_smallclassid"))&'"><%=TRIM(rs("smallclasszs"))%></a>

<%
dim startime,conn,connstr,db,rs,rs_s,rs_s1
startime=timer()
db="DataBase/###EC0703.V6017#.asp"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
'connstr = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Password=123456;Persist Security Info=False;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
set rs=server.createobject("adodb.recordset")