Re: LIMIT alternative

2005-09-02 Thread Vladimir B. Tsarkov
Hello! Bastian Balthazar Bux, Pooly, Shawn Green, Peter Brawley, I thank you all! In fact, I don't understand why this command is not standardized (ANSI SQL, etc.). -- Удачи! Владимир Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments

Re: LIMIT alternative

2005-09-01 Thread Peter Brawley
Vladimir, >Is there any portable alternative to LIMIT? I'd like >to create a portable PHP pager for a web site ... No, there's not a 'super SQL' which all SQL engines understand. To hide the details of LIMIT | TOP from your apps, you can write a PHP funcion which applies or updates the appro

Re: LIMIT alternative

2005-09-01 Thread SGreen
"Vladimir B. Tsarkov" <[EMAIL PROTECTED]> wrote on 09/01/2005 06:16:12 AM: > Hello! > > I've heard that LIMIT is a MySQL specific, and cannot be used in any other > DBMS. Is there any portable alternative to LIMIT? I'd like to create a > portable PHP pager for a web site, but all the tutorials

Re: LIMIT alternative

2005-09-01 Thread Pooly
2005/9/1, Vladimir B. Tsarkov <[EMAIL PROTECTED]>: > Hello! > > I've heard that LIMIT is a MySQL specific, and cannot be used in any other > DBMS. Is there any portable alternative to LIMIT? I'd like to create a > portable PHP pager for a web site, but all the tutorials that I've found, > contain

Re: LIMIT alternative

2005-09-01 Thread Bastian Balthazar Bux
Vladimir B. Tsarkov wrote: > Hello! > > I've heard that LIMIT is a MySQL specific, and cannot be used in any other > DBMS. Is there any portable alternative to LIMIT? I'd like to create a > portable PHP pager for a web site, but all the tutorials that I've found, > contain solutions based on th

LIMIT alternative

2005-09-01 Thread Vladimir B. Tsarkov
Hello! I've heard that LIMIT is a MySQL specific, and cannot be used in any other DBMS. Is there any portable alternative to LIMIT? I'd like to create a portable PHP pager for a web site, but all the tutorials that I've found, contain solutions based on the LIMIT usage. Thanks! -- Good Luck