Re: MSSQL store proc and invalid result source

I don't know if this will fix it, but why don't you trying wraping your while in a num rows call? Like: if(mssql_num_rows($result) > 0) { while($row = mssql_fetch_array($result)) { echo $row[whatever]; } } Adam Voigt adam.voigt@cryptocomm.com On Tue, 2002-10-22 at 11:49, Hien Nguyen wrote: > I am using a MSSQL stored procedure that is a select > on a table. It works fine in an ASP app. And in Query > Analyzer. > > However, in PHP it works fine unless the select > returns zero rows. When 0 rows are returned I get an > invalid result source. > > In the sample code below I will get an error when I > fetch the row because the result source that is > returned from the stored procedure is invalid, but > only when the result set is empty. > > $stmt=mssql_init("spMyProc"); > mssql_bind($stmt,"@param1",$var1,SQLINT4,false,false,4); > mssql_bind($stmt,"@param2",$var2,SQLINT4,false,false,4);$result > $result = mssql_execute($stmt); > > while ($row=mssql_fetch_array($result)) { > } > > I would appreciate any help or leads. Thank you. > > Hien Nguyen > Rutgers Campus Information Services > hqnguyen77@yahoo.com > > > __________________________________________________ > Do you Yahoo!? > Y! Web Hosting - Let the expert host your web site > http://webhosting.yahoo.com/ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >