RE: [PHP-DB] Difficulties in handling LIMIT queries

Are you using MySql?? > -----Original Message----- > From: João Barreto Fernandes [SMTP:barreto@convex.pt] > Sent: Friday, August 11, 2000 8:55 AM > To: php-db@lists.php.net > Subject: [PHP-DB] Difficulties in handling LIMIT queries > > Hi all ... > > I have a simple that many of you might find extremelly simple to answer. > > I have a DB with a table with around 50.000 rows. When I do a query > that gives me back around 15.000 rows, I have no problems in using > LIMIT x,y to get only a few of them. If a use some ordering I only get > back some values if the query (without the order by) would give me > back no so many rows. > > The error I get is 1114: The table 'SQL4677_0' is full > > Any ideas or workarounds? I am using indexes on the order columns. > > Thanks in advance, > Joao > ------------------------------------------------------------- > Joao Barreto Fernandes - e-Business, Security, Accounting & Billing > CONVEX Portugal - Informática e Sistemas de Comunicações, Lda > Edf. Inovação III, 624 - 2780-920 Porto Salvo - Portugal > barreto@convex.pt http://www.convex.pt +351 214229200 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >