Hello again

I have an INSER INTO, created using values passed in an XML and i have to insert it in to my PostgreSQL table via ASP.

What i do is, I collect all the values in to a variable and then execute it as the following.

--- create my INSERT INTO ---

conn.Execute strSQL
So far this works

What i want to know is how can I test the result of the execution query and then give a message to the user.

For example
IF EXECUTE goes wrong
 set a session varible "execute" equal to "false"
 set a session varible "execute" equal to "true"
Is there anyway to test this??

Thank you.