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.
So far this works
--- create my INSERT INTO ---
What i want to know is how can I test the result of the execution query and then give a message to the user.
Is there anyway to test this??
IF EXECUTE goes wrong
set a session varible "execute" equal to "false"
set a session varible "execute" equal to "true"