这样就简单了: Select * From TABLE Where 数字=2 如果2是文本型的则为: Select * From TABLE Where 数字="2"
第2个回答 2008-01-21
set rs=server.createobject(adodb.recordset) sql="select * from 表名 where 数字=2" rs.open sql,conn,1,1 do while not rs.eof response.write rs("数字") response.write " " response.write rs("数目") response.write "<br />" rs.movenext loop rs.close set rs=nothing