sorry I forgot to write the code.<BR>&#060;% set OBJConnection=server.createobject("adodb.connectio n")<BR>OBJConnection.open "DSN=Ameur"&#037;&#062;<BR>&#060;%ssn = Request.QueryString("EESSN")&#037;&#062; <BR>&#060;% SQLtemp = " select * from MyTable_OLD " & _ <BR>"WHERE EESSN = &#039" & ssn & "&#039"<BR> <BR> set rspeople=OBJConnection.execute(SQLtemp)&#037;&#062 ;<BR><BR> <BR> <BR>&#060;%<BR>if rspeople.eof then<BR>response.write "No Records Matched<BR>"<BR>OBJConnection.close<BR>set OBJConnection=nothing<BR>response.end<BR><BR>&#037 ;&#062;<BR>&#060;%else&#037;&#062;<BR><BR>&#060;ta ble border="1"><BR>&#060;tr><BR>&#060;th>EESSN&#060;/th><BR>&#060;th>FIRSTNAME&#060;/th><BR>&#060;th>LASTNAME&#060;/th><BR>&#060;/tr><BR><BR>&#060;tr>&#060;td><BR>&#060;%response.w rite rspeople("EESSN")&#037;&#062;<BR>&#060;/td>&#060;td><BR>&#060;%response.write rspeople("FIRSTNAME")&#037;&#062;<BR>&#060;TD><BR> &#060;%response.write rspeople("LASTNAME") &#037;&#062;&#060;/TD><BR>&#060;/td>&#060;/tr><BR><BR>&#060;%end if&#037;&#062;<BR><BR>&#060;%<BR>rspeople.close<BR >set rspeople=nothing<BR>OBJConnection.close<BR>set OBJConnection=nothing<BR>&#037;&#062;<BR>&#060;/table><BR>I could not get the data.