Question

asp查询到的值怎样存到一个变量里。

<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_my_data_STRING
Recordset1_cmd.CommandText = "SELECT lev FROM userinfo WHERE userID = 'yxz5803'"
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
这段asp代码查询出一个值，如何把这个值存到一个变量里。

Answer 1

if not Recordset1.eof then
abc=你要的数据库内容
end if