By: Jim
Date: 2003-09-17
Time: 07:39
|
Functionality
Hi
Very nice examples included in the package.
But im missing examples on how to make tamplate and php for
example 'limited select'.
Like if I want to select from the database 10 items per click.
And I dont want to select "all" and then make pages, coz there are no time saving in the sql select when doing that.
I would like to use from the ADODB the limited select and fetch 10 rows each time from database, thats no problem, but problem is how I can apply that to TBS.
|
By: Skrol29
Date: 2003-09-17
Time: 18:19
|
Re: Functionality
Hello Jim,
Only your Database System can read 10 items without calling all the select.
So if you Db System support such a feature (like MySQL with the LIMIT clause) the you can do it. Otherwsie, you will have to call the query if you want only a part of it.
SQL-Server supports a TOP clause but that's only for the first records.
|