Re: DBI SQL Returns Less than Direct SQL

You probably are using an inappropriate DBI method for your desired result. In your perl, try the following and see if you get the right number of rows:

my $results = $dbh->selectall_arrayref($your_sql) ;
print Dumper($_) foreach (@{$results}) ;
[download]

Comment on Re: DBI SQL Returns Less than Direct SQL Download Code

Replies are listed 'Best First'.
Re^2: DBI SQL Returns Less than Direct SQL by DaveNagy (Initiate) on Oct 17, 2011 at 23:10 UTC
Thanks, onelesd, for this suggestion but I don't have a subroutine 'Dumper' on my system. I'll be posting code and some snippets of trace messages later. Dave	[reply]
Re^3: DBI SQL Returns Less than Direct SQL by onelesd (Pilgrim) on Oct 17, 2011 at 23:55 UTC
Oops, I left out the use statement. It's from the Data::Dumper module which you probably do have installed (lots of modules use it).	[reply]
Re^4: DBI SQL Returns Less than Direct SQL by DaveNagy (Initiate) on Oct 18, 2011 at 12:17 UTC
Thanks! It works now but still shows only the one row returned.	[reply]
Re^4: DBI SQL Returns Less than Direct SQL by DaveNagy (Initiate) on Oct 18, 2011 at 12:22 UTC
OK - got Dumper to work but it still shows only one row returned from MySQL. Dave	[reply]