The doc u read is absolutely correct. u need to use fetching method. "Jens-Peter C. Hillers" <[EMAIL PROTECTED]> wrote:Hello,
ill try to get the last ten rows without fetching the whole table (ODBC !) the table CREATE TABLE logtab ( ts timestamp default TIMESTAMP, username varchar(255) NOT NULL default '', domain varchar(255) NOT NULL default '', action varchar(255) NOT NULL default '', data varchar(255) NOT NULL default '' ) in postgres & mysql the query is: SELECT * FROM logtab WHERE domain='$fDomain' ORDER BY ts DESC LIMIT 10 my first idea was: SELECT * FROM logtab WHERE domain='$fDomain' AND ROWNO < 11 ORDER BY ts BUT If I've read the doc right maxDB does first fetch the fits ten rows an then order it. any help`? regards jph ___________________________ Dipl.-Ing. Jens-Peter C. Hillers Remote Web Services GmbH Tel: +49 40 25 49 06 22 Fax: +49 40 36 00 67 27 Email: [EMAIL PROTECTED] ____________________________ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
