asp语句不能显示记录,但可以循环 - ASP技术论坛

guaishi

等　级：新手上路
帖　子：156
专家分：0
注　册：2007-6-15
结帖率：100%

楼主

问题点数：0 回复次数：3

asp语句不能显示记录,但可以循环

<body>
<% set rs=server.CreateObject("adodb.recordset")
sql="select * from corpuser_info order by username desc"
rs.open sql,conn,2,3
%>
<form id="form1" name="form1" method="post" action="">
<table width="762" border="1">
<tr>
<td width="289"><span class="STYLE3">用户名</span><span class="STYLE1">(username)</span></td>
<td width="263"><span class="STYLE7">logo信息</span></td>
<td width="188"><span class="STYLE4">管理</span></td>
</tr>
<%do while not rs.eof and rs.bof%>
<tr>
<td><%=rs("username")%></td>
<td><%=rs("logo")%></td>
<td><a href="zhenzhi_log.asp?username=<%=rs("username")%>&act="显示" target="_self" class="STYLE4">显示</a><span class="STYLE4">/</span><a href="zhenzhi_log.asp?username=<%rs("username")%>&act=“不显示" target="_self" class="STYLE4">不显示</a></td>
</tr>
<%rs.movenext%>
<%loop%>
</table>
</form>

<% act=request.querystring("act")
username=request.querystring("username")
set rb=server.createobject("adodb.recordset")
sql="select * from corpuser_info where username='"&username&"' "
rb.open sql,conn,2,3
if act="显示" then
rb("logo")=1
else
rb("logo")=0
rb.update
rb.close
set rb=nothing
conn.close
set conn=nothing
end if
%>
</body>
</html>

[此贴子已经被作者于2007-9-24 11:49:09编辑过]

搜索更多相关主题的帖子: span　语句　 asp　include　

2007-09-24 11:42

guaishi

等　级：新手上路
帖　子：156
专家分：0
注　册：2007-6-15

第 3 楼

得分:0

回复：（guaishi）asp语句不能显示记录,但可以循环

<% set rs=server.CreateObject("adodb.recordset")
sql = "select * from corpuser_info "
rs1.open sql,conn,1,1
%>
<table width="469" border="1">
<tr>
<td width="138"><span class="STYLE5">用户名（username</span><span class="STYLE5">）</span></td>
<td width="189"><span class="STYLE5">是否显示logo</span></td>
<td width="120"><span class="STYLE1 STYLE5"><strong>管理</strong></span></td>
</tr>
<% do while not rs.eof%>
<tr>
<td><%=rs(2)%></td>
<td><%=rs(115)%></td>
<td><a href="zhenzhilogo.asp?username=<%=rs(2)%>">修改</a></td>
</tr>
<%rs.movenext%>
<%loop%>
</table>

<body>
<form action="zhenzhiadd.asp" method="get">
<table width="584" border="1">
<tr>
<td width="185"><label><span class="STYLE3 STYLE2">用户名</span><span class="STYLE2 STYLE1">（username）</span></label></td>
<td width="168"><span class="STYLE5 STYLE1">加框是否</span></td>
<td width="209" rowspan="2"><label>
<input name="Submit" type="submit" class="STYLE2" value="更新" />
</label></td>
</tr>
<tr>
<td><label>
<input name="username" type="text" value="<%=rs(2)%>" />
</label></td>
<td><label>
<input name="payment" type="text" value="<%=rs(114)%>" />
</label></td>
</tr>
</table>

</form>
<% username=request.QueryString("username")
%>
<% set rs=server.CreateObject("adodb.recordset")
sql="select * from corpuser_info where username='"&username&"'"
rs.open sql,conn,2,3%>
<%rs.addnew
rs(2)=request.form("username")
rs(114)=request.Form("payment")
rs.update
rs.close
set rs=nothing
%>

网络改变了我,编程改变了我的生活

2007-09-25 11:41