RE: Not getting all rows from SQL Server using DBD::ODBC

[Tim Howell]

 do{
        while (my $shelby_db_data_ref = $shelby_db_sth->fetchrow_hashref()){
                #Do stuff with data from $shelby_db_data_ref
        }
} while ($shelby_db_sth->{odbc_more_results});

--TWH

-----Original Message-----
From: Tim Johnson [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 27, 2004 4:24 PM
To: Tim Howell; [EMAIL PROTECTED]
Subject: RE: Not getting all rows from SQL Server using DBD::ODBC


You're missing the part where you show us the code you've used so far.
Seriously, though, it's impossible to tell from this email.  Obviously we don't want 
you to expose any confidential or sensitive information, but chances are that it is a 
problem with your algorithm, and we can probably help.




-----Original Message-----
From: Tim Howell [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 4:09 PM
To: [EMAIL PROTECTED]
Subject: Not getting all rows from SQL Server using DBD::ODBC

I've got a query that executes against SQL Server 2000 using DBD::ODBC.
It should be returning about 170 rows; however, I'm only getting about
25 rows.  I've tried checking $sth->{odbc_more_results}, but it is false.  The query 
returns behaves as expected when executed within Access.

Am I missing something obvious?

Thanks!  =)

--TWH