帮忙看一下这段代码正确的应该怎么写?
<%
gsid=session( "id ")
set rs=server.createobject( "adodb.recordset ")
sql= "select * from work where gsid= ' "&gsid& " ' "
rs.open sql,conn,1,3
if rs.eof then
%>
<tr>
<td align= "center " valign= "top " bgcolor= "#D39147 ">
<% response.write "暂时没有店铺公告! "
else
=rs( "showname ") %> </td>
</tr>
<%
end if
rs.close
%>
要在td中显示=rs( "showname ")正确的应该怎么写?
[解决办法]
<%
gsid=session( "id ")
set rs=server.createobject( "adodb.recordset ")
sql= "select * from work where gsid= ' "&gsid& " ' "
rs.open sql,conn,1,3
if rs.eof then
response.write " <tr> <td> 暂时没有店铺公告! " </td> </tr> "
else
%>
<tr>
<td align= "center " valign= "top " bgcolor= "#D39147 "> <%=rs( "showname ")%> </td>
</tr>
<%
end if
rs.close
%>
