Problem with mssql, stored procedures and temp tables

From: Date: Wed, 24 Jan 2001 17:21:35 +0000
Subject: Problem with mssql, stored procedures and temp tables
Groups: php.db 
Request: Send a blank email to php-db+get-6141@lists.php.net to get a copy of this message
Hi there, I have a slight problem with a stored procedure in mssql to does 2 selects into temporary tables and then does another select joining them with another table from the database to return the data. when this is run in query analyzer it returns the following (86 row(s) affected) (86 row(s) affected) then the data... I have run this in asp and it returns the data but in php it seems to see the '(86 row(s) affected)' and returns nothing. Anyone any ideas Thanks Nick

« previous php.db (#6141) next »