<% Id = request("Id") Set objrs = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblLogin where LoginId = " & Id 'Set the recordset object equal to the SQL query string objRS.Open SQL, objADO, 1, 3 %> <% Set oUpload = New clsUpload Set oFile = oUpload("ID") ID = oFile.Value %> <% Response.Redirect "registrationsuccess.asp?Id=" & ID %>