It doesnot work, all of the things you told are in the code, but for some reason it complains. Any way i will come back to it later. I have a question again I am in the while loop and my output should be FirstName LastName.
                shoakat Kalloo
                Jason Andrew

  If there is nothing in the database by these names. It should out put. Records not in the database. My out put is be FirstName LastName.
                                         shoakat Kalloo
                                        FirstName LastName
                                         Jason Andrew
 Do While not objRst.EOF


  response.Write("<th>FirstName</th><th>LastName</th>")


Loop

this is happening because the header Firstname Lastname is in the loop. Either put the header outside the loop or keep a recordcounter. When the recordcount is at 1 print the header otherwise if >1 then print only the body
which is your names Jason Andrew etc. Also if its 0 u can print out no records in database heres an example:


dim reccount

do while not objrst.EOF

reccount = reccount + 1

if reccount = 1 then
            response.write your header
            response.write your body


elseif reccount = 0 then

            response.write("No records exist in the database")

else

    response.write your body only

end if