U need to give necessary spaces between quotation marks and SQL keywords so that the SQL server can interpret them.

If you dont give them properly especially in ASP. it is very difficult to trace them

better make use of Reponse.Write for the SQL statement to be executed before only