Results 1 to 5 of 5
Thread: PostgreSQL- Execute
Dec 3, 2008, 10:40 #1
- Join Date
- Sep 2004
- Milan, Italy
- 0 Post(s)
- 0 Thread(s)
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
What i want to know is how can I test the result of the execution query and then give a message to the user.
IF EXECUTE goes wrong set a session varible "execute" equal to "false" ELSE set a session varible "execute" equal to "true" END IF