Re: database persistence with mysql, sqlite

2007-09-26 Thread Bryan Olson
Lawrence D'Oliveiro wrote: > Bryan Olson wrote: > >> Lawrence D'Oliveiro wrote: >>> In Bryan Olson wrote: >>> coldpizza wrote: > It turned out that the method above ('SELECT * FROM TABLE LIMIT L1, > L2') works ok both with mysql and sqlite3, therefore I have decided to > stick wit

Re: database persistence with mysql, sqlite

2007-09-26 Thread Lawrence D'Oliveiro
In message <[EMAIL PROTECTED]>, Bryan Olson wrote: > Lawrence D'Oliveiro wrote: >> In Bryan Olson wrote: >> >>> coldpizza wrote: It turned out that the method above ('SELECT * FROM TABLE LIMIT L1, L2') works ok both with mysql and sqlite3, therefore I have decided to stick with it

Re: database persistence with mysql, sqlite

2007-09-26 Thread Bryan Olson
Lawrence D'Oliveiro wrote: > In Bryan Olson wrote: > >> coldpizza wrote: >>> It turned out that the method above ('SELECT * FROM TABLE LIMIT L1, >>> L2') works ok both with mysql and sqlite3, therefore I have decided to >>> stick with it until I find something better. With Sqlite3 you are >>> supp

Re: database persistence with mysql, sqlite

2007-09-26 Thread Lawrence D'Oliveiro
In message <[EMAIL PROTECTED]>, Bryan Olson wrote: > coldpizza wrote: >> It turned out that the method above ('SELECT * FROM TABLE LIMIT L1, >> L2') works ok both with mysql and sqlite3, therefore I have decided to >> stick with it until I find something better. With Sqlite3 you are >> supposed to

Re: database persistence with mysql, sqlite

2007-09-26 Thread Bryan Olson
coldpizza wrote: > It turned out that the method above ('SELECT * FROM TABLE LIMIT L1, > L2') works ok both with mysql and sqlite3, therefore I have decided to > stick with it until I find something better. With Sqlite3 you are > supposed to use LIMIT 10 OFFSET NN, but it also apparently supports >

Re: database persistence with mysql, sqlite

2007-09-25 Thread M.-A. Lemburg
On 2007-09-23 01:11, coldpizza wrote: > Hi, > > I want to run a database query and then display the first 10 records > on a web page. Then I want to be able to click the 'Next' link on the > page to show the next 10 records, and so on. > > My question is how to implement paging, i.e. the 'Next/Pr

Re: database persistence with mysql, sqlite

2007-09-24 Thread coldpizza
On Sep 24, 7:23 am, Lawrence D'Oliveiro <[EMAIL PROTECTED] central.gen.new_zealand> wrote: > In message <[EMAIL PROTECTED]>, coldpizza > wrote: > > > So far, with mysql I use 'SELECT * FROM TABLE LIMIT L1, L2' where L1 > > and L2 define the range for the 'Next' and 'Previous' commands. I > > have

Re: database persistence with mysql, sqlite

2007-09-24 Thread Gerardo Herzig
coldpizza wrote: >Hi, > >I want to run a database query and then display the first 10 records >on a web page. Then I want to be able to click the 'Next' link on the >page to show the next 10 records, and so on. > >My question is how to implement paging, i.e. the 'Next/Prev' NN >records without ree

Re: database persistence with mysql, sqlite

2007-09-23 Thread Lawrence D'Oliveiro
In message <[EMAIL PROTECTED]>, coldpizza wrote: > So far, with mysql I use 'SELECT * FROM TABLE LIMIT L1, L2' where L1 > and L2 define the range for the 'Next' and 'Previous' commands. I > have to run the query every time a click a 'Next/Prev' link. But I am > not sure that this is the best and

Re: database persistence with mysql, sqlite

2007-09-23 Thread Bryan Olson
coldpizza wrote: > I want to run a database query and then display the first 10 records > on a web page. Then I want to be able to click the 'Next' link on the > page to show the next 10 records, and so on. > My question is how to implement paging, i.e. the 'Next/Prev' NN > records without reestab