Got RaiseError enabled?
Got PrintError enabled?
Looked at a trace log?
Tim.
On Fri, Feb 27, 2004 at 04:45:03PM -0800, Tim Howell wrote:
> 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
>
>
