Is the best way to do a singleton select - asp/Access?

[humour]

QueryStr = "Select UpdDateTime From ctTable
where ID= 1 "

rsQuery.Open QueryStr, DB, adOpenForwardOnly, adLockReadOnly

If Not(rsQuery.eof) Then
DT = rsQuery.fields("UpdDAteTime")
End IF

etc...

 

[DreXor]

if you're just using this for datareturn/variable assignment... removing all the arguments will make life a little easier, and the code less complicated to debug later.
most instances of recordsets are not needed for active update/delete/etc, so creating a "ADODB.RECORDSET" is not typically needed

set connection = server.createobject("adodb.connection")
connection.open connectionString

QueryStr = "Select UpdDateTime From ctTable where ID=1"

set rsobject = connection.execute(querystr)
if not rsobject.eof then
<CLIP>

DreX
aKa - Robert