re: SPAM-LOW: [PHP-WIN] PDO ODBC & MSSQL Stored Procedures that return record sets

I just realised the problem was the SP was not setting set nocount on so the first record set was the number of records returned ---------------------------------------- From: "Aspen Olmsted" <aspen.olmsted@alliance.biz> Sent: Thursday, October 12, 2006 6:21 AM To: php-windows@lists.php.net Subject: SPAM-LOW: [PHP-WIN] PDO ODBC & MSSQL Stored Procedures that return record sets Hello, I am having trouble with pdo_odbc and calling a stored procedure that returns a record set. I have tried with out using parameters: $stmt = $dbh->prepare("EXEC ASC_GridData @StartRecordIndex=0,@PageSize=15,@SortColumn='',@SortDirection='ASC',@Filter ='lscShowCode=14 and lscType=2',@PrimaryKey='lscCode',@Fields='lscComponent,lscDescription,lscPos ition',@TableName='BB_LC_ShowComponent'"); And with using parameters $a[StartRecordIndex] = 0; $a[PageSize] = 15; $a[SortColumn] = ''; $a[SortDirection] = 'ASC'; $a[Filter] = 'lscShowCode=14 and lscType=2'; $a[PrimaryKey] = 'lscCode'; $a[Fields] = 'lscComponent,lscDescription,lscPosition'; $a[TableName] ='BB_LC_ShowComponent'; //$stmt = $dbh->prepare("exec ASC_GridData :StartRecordIndex,:PageSize,:SortColumn,:SortDirection,:Filter,:PrimaryKey,: Fields,:TableName"); $stmt->execute($a); print_r($stmt); $row = $stmt->fetch(); print_r($row); Both do not return data thought using sql profiler it looks like it is running the query just not navigating the result set. Aspen Olmsted Alliance Software Corporation 17 Pitt St Charleston SC, 29401 aspen.olmsted@alliance.biz -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php