[求助]自动生成编号
各位好：我想在查询结果的表的左侧加上“编号”一列（自动生成，从1到n），如我是获取ID：<%=rs("id")%>这样不行，怎么做呀！谢谢！！
不能直接获取ID。
各位说对呀！字段我删除过了，其连续性还会有吗？
大家看看下面这个表（红色部分）：我想加的编号是蓝色的部分
[CODE]<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file = "checkinfoadmin.asp"-->
<!-- #include file="conn.asp" -->
<html>
<style type="text/css">
<!--
.style28 {
font-size: 12px;
color: #0000FF;
}
.style33 {color: }
-->
</style>
<style type="text/css">
<!--
.style34 {color: #FFFFFF}
-->
</style>
<style type="text/css">
<!--
.style35 {color: #99FFFF}
-->
</style>
<style type="text/css">
<!--
.style36 {color: #FF0000}
.style37 {color: #00FF00}
-->
</style>
<style type="text/css">
<!--
.style42 {color: #006600}
-->
</style>
<style type="text/css">
<!--
.style43 {color: #990000}
-->
</style>
<style type="text/css">
<!--
.style44 {color: #CC0000}
-->
</style>
<style type="text/css">
<!--
.style46 {font-weight: bold}
.style47 {
font-weight: bold;
color: #009900;
}
.style48 {font-weight: bold}
.style53 {font-size: 12px}
-->
</style>
<style type="text/css">
<!--
.style54 {color: #000000}
-->
</style>
<style type="text/css">
<!--
.style55 {color: #009900}
.style56 {font-size: 12pt}
-->
</style>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>:::名片信息存档窗口:::</title>
<link href="../css/fontsize.css" rel="stylesheet" type="text/css">
<link href="../css/input_form.css" rel="stylesheet" type="text/css">
<link href="../css/inputform1.css" rel="stylesheet" type="text/css">
<link href="../css/selectform.css" rel="stylesheet" type="text/css">
<link href="../css/inputform2.css" rel="stylesheet" type="text/css">
<link href="../css/inputform3.css" rel="stylesheet" type="text/css">
<link href="../css/inputform3.css" rel="stylesheet" type="text/css">
<link href="../css/link.css" rel="stylesheet" type="text/css">
<link href="../css/buttoncss.css" rel="stylesheet" type="text/css">
<link href="../css/inputchaxun.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
background-image: url(../pictures/0343.jpg);
}
.style6 {color: #66CCFF}
.style7 {
color: #330000;
font-style: italic;
}
.style11 {color: #0000FF}
.style29 {color: #330000}
-->
</style>
<SCRIPT src="cityForecastQuery.files/date.js" type=text/javascript></SCRIPT>
</head>
<style type="text/css" media="print">
#div0 {display:none;}
</style>
<script>
function print(d){
for(i=0;i<2;i++){
if(i==d) eval("div"+i).style.visibility="visible";
else eval("div"+i).style.visibility="hidden";
}
document.all.wb.ExecWB(7,1);
for(i=0;i<2;i++){
eval("div"+i).style.visibility="visible";
}
}
</script>
<div id=div0>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height=0 id=wb name=wb width=0>
<embed width="0" height="0"></embed></OBJECT>
<IFRAME
id=CalFrame
style="DISPLAY: none; Z-INDEX: 100; LEFT: 66px; WIDTH: 181px; POSITION: absolute; TOP: 406px; HEIGHT: 176px"
name=calendarframe marginWidth=0 marginHeight=0
src="cityForecastQuery.files/commondate.htm" frameBorder=0 noResize
scrolling=no> </IFRAME>
<td width="100%" height="71" background="../pictures/0343.jpg"><p align="center"><span class="style54"><img src="../pictures/fox.gif" width="35" height="31"> 名片信息查询窗口 2005.11.30 版</span></p>
<p class="style54"><font size="2"> :::欢迎您使用本查询模块:::请输入查询条件...
查询人员：<span class="style13"><span class="style36"><span class="style19"><%=session("name")%></span></font> </p></td>
<tr> </td></tr>
<tr>
<td background="../pictures/0343.jpg" class="style54"><div align="right">
<table width="600" height="64" border="1" align="left" cellpadding="0" cellspacing="0" bordercolor="#009900" class="fontsize" style="border-collapse: collapse">
<form name=frm action="fine_mpxxlr.asp" method="post" >
<tr align="center" valign="middle">
<td width="16%" height="23" nowrap >
<div align="center" class="style11"> 公司名称 </div></td>
<td width="16%" nowrap >
<div align="center"><font size="2">
<input name="gsmc" type="text" id="gsmc" onMouseOver="this.focus();" size="15">
</font></div></td>
<td width="16%" nowrap >
<div align="center" class="style11"><font size="2"> 姓 名 </font>
</div></td>
<td width="16%" nowrap >
<div align="center"><font size="2">
<input name="xm" type="text" id="num_of_classes_chaxun2"onMouseOver="this.focus();" size="10">
</font> </div></td>
<td width="10%" rowspan="2" nowrap ><div align="center" class="style11"><font size="2"> 经营范围 </font> </div></td>
<td width="10%" rowspan="2" nowrap ><font size="2">
<input name="jyfw" type="text" id="num_of_classes_chaxun2"onMouseOver="this.focus();" size="30">
</font></td>
<td width="10%" rowspan="2" nowrap >
<div align="center">
<input name="chaxun" type="submit" id="chaxun5" value="我要查询">
</div></td>
</tr>
<tr align="center" valign="middle">
<td width="16%" height="23" nowrap >
<div align="center" class="style11"><font size="2"> 本人住址
</font></div></td>
<td width="16%" nowrap >
<div align="center">
<input name="dz" type="text" id="num_of_grade_chaxun2"onMouseOver="this.focus();" size="15">
</div></td>
<td nowrap ><div align="center" class="style11"><font size="2"> 职 务 </font></div></td>
<td nowrap ><div align="center"><font size="2">
<input name="zw" type="text" id="num_of_classes_chaxun2"onMouseOver="this.focus();" size="10">
</font></div></td>
</tr>
</form>
</table>
</div>
</td>
</tr><tr><td background="../pictures/0343.jpg" class="style54"><div align="right">
<p align="center">
<input type=button value=打印设置 onclick="wb.execwb(7,1)">
<input type=button onClick=document.all.wb.ExecWB(6,1) value="打印名片">
</p>
</div></td>
</tr>
<tr>
<td background="../pictures/0343.jpg" class="style54"><div align="left">
<p> </p>
<p><span class="style11"> <font size="2">下表是查询结果（理论统计数据和实际数据可能有所误差），</font></span><span class="style34 style11"><font size="2">数据较多，<span class="style43">请稍做等待.........</span></font></span></p>
</div></td>
</tr>
</div>
<div id=div1>
<tr>
<td height="141" background="../pictures/0343.jpg">
<table width="800" border="2" align="center" cellpadding="0" cellspacing="0" bordercolor="#009900" style="border-collapse: collapse">
<tr align="center" valign="middle" class="fontsize">
<td width="136" height="25" nowrap><div align="center" class="style42 style46 style54 style42 style55">
<div align="center">编 号</div>
<td width="136" height="25" nowrap><div align="center" class="style42 style46 style54 style42 style55">
<div align="center">公 司 名 称</div>
</div></td>
<td width="58" height="25" nowrap> <div align="center" class="style42 style47 style54 style42">
<div align="center" class="style55">姓 名</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="center">职 务</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="center">E-MAIL</div>
</div></td>
<td width="87" height="25" nowrap> <div align="center" class="style47 style42">
<div align="center">本 人 地 址</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="right">电 话</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="center">手 机</div>
</div></td>
<td width="72" height="25" nowrap><div align="center" class="style48 style55">
<div align="center">传 真</div>
</div></td>
<td width="104" height="25" nowrap> <div align="center" class="style55"><strong><span class="style11 fontsize style56"><span class="style54 style55">经 营 范 围</span></span></strong></div></td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
sql= "select * from mpxxlr where gsmc like '%"&trim(request("gsmc"))&"%'and xm like '%"&trim(request("xm"))&"%' and zw like'%"&trim(request("zw"))&"%'and dz like'%"&trim(request("dz"))&"%' and jyfw like'%"&trim(request("jyfw"))&"%' order by id desc"
rs.open sql,conn,1,1
if rs.recordcount <> 0 then
rs.movefirst
do while not rs.eof
%>
<tr align="center" valign="middle" class="fontsize">
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("ID")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("gsmc")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("xm")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("zw")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("email")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("dz")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("bgdh")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("sj")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("cz")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("jyfw")%></div></td>
</tr>
<%
rs.movenext
loop
else
%>
<tr class="fontsize">
<td height="24" ><div align="center" class="style37 style36 style36 style36 style33 style34 style36 style36 style36 style36 style44"><font size="2">没查询到符合条件的信息!</font></div></td>
</tr>
<%
end if
%>
</table>
<p class="style11 style53">符合查询条件的信息共有：<span class="style36"><%=rs.recordcount%> </span>条</p>
<p align="right" class="style11 style53 style54 style54">：：： IT部：：：</p>
</div>
</body>
</html>[/CODE]
