wardk,
I think it is different when running over freeTDS on linux,
because when I tried to do it as two seperate commands,
@@IDENTITY was empty. I think it has something to do with
the concept of "current session", but I don't really know.
Nice work in Identity nabber for MSSQL, by the way.
Thanks,
Scott | [reply] |
| [reply] [d/l] |
Since you are using two commands off one prepare, you may need to
use the:
while ( $someVar = $sth->fetch ) {
do (
something...
) while ( $sth->{syb_more_results} );
syntax.
This is explained in the "Programming the Perl DBI" book
PG: 326
Don't know if it helps - but it's worth a try. | [reply] [d/l] |