主题:asp 帮助啊,大家来看看
<%
where id="&xid&" <!--定义一个变量id >
set rsbig = server.CreateObject ("adodb.recordset")
sql="select * from BigClass where BigClassName="&id&"" <!--变量id的值等于BigClassName>
rsbig.open sql,conn,1,1
if rsbig.eof and rsbig.bof then
Response.Write "À¸Ä¿ÕýÔÚ½¨ÉèÖС­¡­"
else
do while not rsbig.eof
%>
<tr>
<td align="left" valign="middle" background="images/leftbg.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="14%" height="27" align="center"></td>
<td width="86%" align="left"><a href="Products.asp?BigClassName=<%=rsbig("bigclassname")%>" class="a1"><strong><%=rsbig("bigclassname")%></strong></a></td>
</tr>
</table>
</td>
</tr>
<%
set rsSmallClass = server.CreateObject ("adodb.recordset")
sqlSmallClass="select * from SmallClass where BigClassName22=(id)" <!--BigClassName22的值等于变量id>
rsSmallClass.open sqlSmallClass,conn,1,1
if rsSmallClass.eof and rsSmallClass.bof then
else
do while not rsSmallClass.eof
%>
我这样写出错了,,哪位高手帮忙改改啊!!
where id="&xid&" <!--定义一个变量id >
set rsbig = server.CreateObject ("adodb.recordset")
sql="select * from BigClass where BigClassName="&id&"" <!--变量id的值等于BigClassName>
rsbig.open sql,conn,1,1
if rsbig.eof and rsbig.bof then
Response.Write "À¸Ä¿ÕýÔÚ½¨ÉèÖС­¡­"
else
do while not rsbig.eof
%>
<tr>
<td align="left" valign="middle" background="images/leftbg.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="14%" height="27" align="center"></td>
<td width="86%" align="left"><a href="Products.asp?BigClassName=<%=rsbig("bigclassname")%>" class="a1"><strong><%=rsbig("bigclassname")%></strong></a></td>
</tr>
</table>
</td>
</tr>
<%
set rsSmallClass = server.CreateObject ("adodb.recordset")
sqlSmallClass="select * from SmallClass where BigClassName22=(id)" <!--BigClassName22的值等于变量id>
rsSmallClass.open sqlSmallClass,conn,1,1
if rsSmallClass.eof and rsSmallClass.bof then
else
do while not rsSmallClass.eof
%>
我这样写出错了,,哪位高手帮忙改改啊!!