Categories > TinyButStrong general >

Functionality

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
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.