Dear Readers.
Using Javascript in ASP I need a way of returning through ADO
(connection or recordset) the message returned via SQL when I run a
query that UPDATES, DELETES or an SP that returns a message.
So I basically when the below code gets executed I need a way of
returning the message if it's there and if not nothing.
a)
var conn = Server.CreateObject("ADODB.Connection")
conn.Open(connStr)
conn.Execute("UPDATE shoe SET size = 12"); /*returns (12 row(s)
affected)*/
conn.Close
conn = null
b)
var conn = Server.CreateObject("ADODB.Connection")
conn.Open(connStr)
conn.Execute("EXEC usp_bob"); /*SP returns Couldn't find bob or
nothing*/
conn.Close
conn = null
It's being used in a generic function, so no case specific code.
Any help or link really appreciated.
Thanks folks!