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" <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
