Question

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

<%
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("smallclasszs"))&"</a></td></tr></table>")
rs.movenext
loop
%>
在线等，就是超链接那个地方的语法错误

Answer 1

你好，你那可能是对于链接的符号有点问题，你把那个超链接改成这样再试试，
<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>

Answer 2

<%
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("smallclasszs"))&"</a></td></tr></table>")
rs.movenext
loop
%>

覆盖保存。刷新看程序。

Answer 3

<%
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("smallclasszs"))&"</a></td></tr></table>")
rs.movenext
loop
%>

Answer 4

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