Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: LIMIT clause in Class::DBI

by larsen (Parson)
on Feb 17, 2004 at 16:37 UTC ( #329655=note: print w/ replies, xml ) Need Help??


in reply to LIMIT clause in Class::DBI

I've found Class::DBI::Extension on CPAN that should have what you're looking for. By the way, beware the Description:

THIS RELEASE IS FOR TEMPORARY DEVELOPMENT. Hope this will eventually be merged into Class::DBI and/or Class::DBI::mysql.
FWIW, I think it should be included in Class::DBI::mysql, or in Class::DBI provided some general implementation of the LIMIT idiom.


Comment on Re: LIMIT clause in Class::DBI
Re: Re: LIMIT clause in Class::DBI
by Ovid (Cardinal) on Feb 17, 2004 at 17:26 UTC

    Regrettably, the code notes that it the SQL it implements is specific to MySQL. In Oracle, for example, you use a "where rownum < ?" to limit results. Thus the code is not terribly portable (yet). It would be nice to see that added.

    Cheers,
    Ovid

    New address of my CGI Course.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (14)
As of 2015-07-06 16:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (77 votes), past polls