vbscipt rs.recordcount的值总是等于-1救命啊

tuojing

Dim Cmd, res,money
Set Cmd = CreateObject("ADODB.COMMAND")
   Cmd.ActiveC
  Set res = createobject("ADODB.RECORDSET")
     Cmd.CommandType = 1
      Cmd.CommandText ="select rtrim(t.fpadamount,'.') as a  from fpadetail t ,baseuser b where b.usrid= t.usrid and b.usrname='truck' "
   Set  res = Cmd.Execute()
     
   If res.Recordcount<>-1 Then
     money=res(0)
   else
       money = 0
   End If
    MsgBox res.Recordcount
Set res = nothing
Set Cmd.ActiveConnection = nothing
Set Cmd= nothing


其他都没问题，就是res.Recordcount总是=-1上面判断无效

tuojing

没有高手么，我是新手啊，来个高高手解决下啊

blueeagle9999

游标的问题
Rs.open sqlstatement,Cnn,1,1