Re: rolling LIMIT into C::DBI::Mysql?

[prev] [thread] [next] [Date index for 2004/07/27]

jason scott gessner wrote:

> Hi All.
> 
> I was about to do this, when I saw on the wiki that someone already has 
> the code up for it:

Heh, that was my hack.

> $frag .= " LIMIT $search_opts->{limit}" if $search_opts->{limit};
> 
> added to _do_search will give you limiting in the search options.  If i 
> were to prepare a patch to add this to C::DBI::MySQL, do you think that 
> would be able to make it out and into a release?

I wouldn't expect to see it in CDBI: it's too database specific. It 
won't work on SQL Server, for instance.
I'd suggest we take it up with the developer of CDBI::Mysql or other 
db-specific modules that support LIMIT and/or OFFSET.

Rhesa