PostgreSQL- Execute

[dreamduster]

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"
ELSE
 set a session varible "execute" equal to "true"
END IF

Is there anyway to test this??

Thank you.

[longneck]

i don't think that's possible. what's wrong with detecting if the execution failed in your host program?

[wwb_99]

It's ASP. Error handling was not it's strong suit . . .

[dreamduster]

but i wonder has anyone never wanted to test if an execute failed or not??!!

[wwb_99]

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.