Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Browsing a sql table on the web

by eXile (Priest)
on May 13, 2006 at 13:24 UTC ( #549229=note: print w/ replies, xml ) Need Help??


in reply to Browsing a sql table on the web

A simple way of doing this is using 'LIMIT/OFFSET' type of SQL statements. I don't think they are in the official SQL specs, but most SQL servers have some kind of way to just return a limited subset of what you want. MySQL for instance uses this syntax:

SELECT * FROM BLAH ORDER BY ID LIMIT 40 OFFSET 100
to limit your query to items 100-139 in the BLAH table. This makes it easy to write a pager for a table, see for instance Class::DBI::Plugin::Pager, which is a pager for the Class::DBI framework.

This approach doesn't take insertion of rows into account, which may or may not be a problem, depending on how and how often your table changes.


Comment on Re: Browsing a sql table on the web

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://549229]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (6)
As of 2015-01-30 09:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My top resolution in 2015 is:

















    Results (248 votes), past polls