On Wed, Jul 16, 2003 at 09:07:39PM -0700, Michael Kovalcik wrote:
> i have a postgresql database created with over 20,000
> rows. i'm trying to pull all the information via dbi
> and it always stops at 268 rows (it works great for
> the information it does send). is there a load issue
> with the way dbi works? am i doing something wrong?
> i've attached my perl script....
When you paste the select into psql or dbish how many rows does it
return?
> my $sth=$dbh->prepare("SELECT
> O.id,O.locationid,O.shippingid,O.statusid,O.ups,O.date,O.
> cost,L.store,S.method,OS.status FROM ${Orders} AS
> O,${Location} AS L,${Shipping} AS S,$
> {OrderStatus} AS OS WHERE L.id = O.locationid AND S.id
> = O.shippingid AND OS.id = O.sta
> tusid ORDER BY O.id");
