Need help urgent! SELECT NEWID() Expires?

[invitro]

Ok... I have this statement here.

strSQL = "";
strSQL += "SELECT NEWID() AS 'uidSubjectID' ";

objRS = Server.CreateObject("ADODB.Recordset");
objRS.ActiveConnection = objConn;
objRS.Open(strSQL);


strSubjectID = objRS("uidSubjectID")

Now, when I try to use strSubjectID after the
objRS.close();

it sais

ADODB.Field error '80020009'

Object is no longer valid.


***? How can I reuse it? I need to redirect the person to another page using a query string.

Response.Redirect(Messages?ID=strSubjectID);