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"
i don't think that's possible. what's wrong with detecting if the execution failed in your host program?
It's ASP. Error handling was not it's strong suit . . .
but i wonder has anyone never wanted to test if an execute failed or not??!!
Oh, with most other stacks, one would be able to have a better angle for handling errors, but for classic asp, your options were limited. You might want to think about upgrading to something more modern.