Beefy Boxes and Bandwidth Generously Provided by pair Networks vroom
go ahead... be a heretic
 
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 musing on the Monastery: (9)
As of 2014-04-16 11:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (424 votes), past polls