asp 里如何用一条语句 取出SQL里的一条记录 ！急急急急急！！！！！！！1

[wqhkl]

如何用一 条最简单的语句取出数据库里一条记录！
类似于
conn.execute("update kku set postc = 1 where id = "&rs("id")&" ")
这样的语句。
请教各位！！！！

[sonymusic]

set rs=server.createobject("adodb.recordset")
rs.open "select * from sample where id=" & id,conn,1,1

[haver.G]

直接
Set Rs=conn.execute("Select top 1 * kku where id = "&rs("id"))
也行

if not rs.eof
读取Rs里面的数据

[mhxz5680]

set rs(=server.createobject("adodb.recordset")).open "select * from sample where id=" & id,conn,1,1


有没人试过这样,会不会报错呢

[subasan]

一条语句。。不可能~`

[jobs002]

rs.source="Select top 1 * kku where id = "&rs("id")

[bino]

conn.execute("select * from kku where id = "&rs("id")&" ")
rs.open "select top 1 * from kku where id = "&rs("id")&" ",conn,1,1

两种方法都是取出一条记录``

[yuanxiaolei]

<!--#include file="sql.inc"-->

<%
set rsn=server.createobject("adodb.recordset")
sql="select * from topgg2 where splb='sh1zp' "
rsn.open sql,conn,3,3
rsn.move 5
%>
<% for i=6 to 10 and not rsn.eof%>
<a href="jieshao.asp?id=<%=rsn("id")%>" target="_blank"><%=rsn("zz")%></a> 
<%
rsn.movenext
if rsn.eof then
exit for
end if
next
rsn.close
%>