access rs.recordcount£¬Ôõô»áµÃµ½-1£¿

Dim ebfs
Set ebfs = Server.CreateObject("ADODB.Recordset")
ebfs.ActiveConnection = conn
ebfs.Source = "SELECT id from goods where lei=1 ORDER BY ID DESC"
ebfs.CursorType = 0
ebfs.CursorLocation = 2
ebfs.LockType = 1
ebfs.Open()

if not ebfs.eof then
response.write ebfs.recordcount
maxnum=ebfs.RecordCount
end if


Ϊʲô×ÜÊÇÊä³ö £­1£¿£¿

---

thanks