Recordset Question...

daimous · #1 (**permalink**) 05-28-06, 20:51

hi! can anybody pls help me...Supposed i have a recordset that im certainly know that there would be only one value..example(select max(id) from employees)..my question is how can i directly get the value from that recordset? with using the recordset.[blah..blah..blah]? thanks in advanace!!!

r937 · #2 (**permalink**) 05-29-06, 09:30

SQL (the language) doesn't have recordsets

moving this thread to, um, let me guess, asp forum

wayneph · #3 (**permalink**) 05-31-06, 17:43

This should get you close.

Code:

if not rs.eof then
  MaxID = rs.Fields(0)
end if

Internet Services

Web Development

Digital Marketing

Consumer Tech