Well, what you are doing in the second query is actually getting more
resultsets in one query. The current sybase modules can't handle more
than 1 resultset at a time. Try running sp_help through sybase_query(),
you'll notice that only the first resultset is given back, all the rest
is discarded.
OK, I understand that php won't recieve multiple result sets, but in the
case of a series of inserts why is this an issue?
One thing I had hoped to do was to run the first insert and then select the
@@identity. The lack of the ability to get multiple result sets is obviously
why I can't retrieve
I'm running PHP 3 (and PHP 4 on another server) with Sybase 11.9.2 on the
database server.
I have tried in a number or variations to insert a series of updates and
inserts in the same sybase_query. I build a $query consisting of around
15-20 inserts and updates and call the sybase_query