<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%> <% option explicit dim conn,db,rs,sql dim aa,uid uid=Request("id") aa=1 db="/newgzl/mdb/login.mdb" Set conn = Server.CreateObject("ADODB.Connection") conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db) sql="select * from gonggao where id='&uid'" Set rs = Server.CreateObject("ADODB.RecordSet") rs.Open sql,conn,1,1 %> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; } --> </style><title><%=rs("zhuti")%></title> <table width="780" border="0" cellpadding="0" cellspacing="0"> <tr> <td><img src="../img/logo2.gif" width="780" height="50"></td> </tr> </table> <table width="780" border="0" cellpadding="0" cellspacing="0"> <tr> <td><form name="form1" method="post" action=""> <table width="100%" border="0" cellpadding="0" cellspacing="0" > <tr> <td width="26%" nowrap>&nbsp;</td> <td width="45%" nowrap><div align="center"> <h2><%=rs("zhuti")%></h2> </div></td> <td width="29%" nowrap>&nbsp;</td> </tr> <tr> <td nowrap>&nbsp;</td> <td nowrap><div align="center"></div></td> <td nowrap>&nbsp;</td> </tr> <tr> <td nowrap>&nbsp;</td> <td nowrap>&nbsp;</td> <td nowrap>&nbsp;</td> </tr> <tr> <td nowrap>&nbsp;</td> <td nowrap>&nbsp;</td> <td nowrap>&nbsp;</td> </tr> </table> </form></td> </tr> </table>

怎么又提示我至少有一个参数未被指定....出错行是红字的行.... 帮我看看好么??谢谢!!!

这句错了：sql="select * from gonggao where id='&amp;uid'"

uid是数字的sql="select * from gonggao where id="&amp;uid
uid是文本的sql="select * from gonggao where id='"&amp;uid&amp;"'"

哦....谢谢.... 还有一个疑问.....如果有and呢? 这么写对不对(uid是数字的,type是文本的) sql="select *from gonggao where type='"&type&"' and id="&uid 还是 sql="select *from gonggao where id="&id& and type='"&type&"'" 怎么写好象都不对的样子.....应该怎么写啊??谢谢islet咯...........