Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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.

Replies are listed 'Best First'.
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.


    New address of my CGI Course.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://329655]
[Lady_Aleena]: I hope you have a wonderful day Discipulus. 8)
[Corion]: A good morning to you too ;)
[choroba]: Good morning, Monks!
[Corion]: And a good daypart to you as well, Lady_Aleena !
[robby_dobby]: Hey monkeys, do you ever get the realization that you're all waking up to chaos? I suppose not :P
[Lady_Aleena]: Good morning Corion, I hope you have a wonderful day as well. 8)
[Corion]: Yesterday I encountered an interesting data structure problem. I have a remote program that emits events, and my client listens for these events with one-shot callbacks, that is, I register the callback and if the event gets generated that callback ...
[Lady_Aleena]: robby_dobby, every day. Chaos is my life with few controls.
[Corion]: ... gets called once. The data structure for that is just a hash of arrays, mapping the event type to a queue of registered one-shots, and the first one-shot from the queue gets removed and called.
[Corion]: But now I want to register a one-shot for two events, of which only one will arrive, so my data structure doesn't work anymore...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (10)
As of 2017-05-29 07:50 GMT
Find Nodes?
    Voting Booth?