Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
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: (7)
As of 2014-11-27 23:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (190 votes), past polls