hello all, here's the scenario; i'm calling a MSSQLServer stored proc that returns a value which happens to be an identity value (@@identity) generated from an insert statement inside the stored procedure. How do i get at this return value using DBI/DBD::ODBC? i can't find any good examples on the web that address this problem. I've heard that running the statement below on the current $dbh should return the correct value: "select @@identity" i'd rather not execute another statement and not to mention that this only works for getting at the @@identity variable. i have other stored procs that simply return status codes that i'd like to examine. i was told that i could create OUTPUT variables in my stored procedure and if DBI supported it i'd be able to bind to these OUTPUT variables. any ideas? -marco __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
