Could find much on this, so:

I have this

my @reviews = LSRfm::Database::CMS::Articles->search_like(section => 'reviews_p_%', { order_by => 'date DESC, time DESC' } );

and just want to add a sql limit, like:

my @reviews = LSRfm::Database::CMS::Articles->search_like(section => 'reviews_p_%', { order_by => 'date DESC, time DESC' }, LIMIT 2 );

but the limit does not work, suggestions/solutons please

The contents of LSRfm::Database::CMS::Articles is irrelevant

Next Question

How would i do a section => 'reviews_p_%' search using the abstract search as suggested, ive tried a few derivations, with either an error or no data

Solved by myself

my @reviews = LSRfm::Database::CMS::Articles->search_where( section => { 'LIKE', 'reviews_p_%' } );

New Problem

my @reviews = LSRfm::Database::CMS::Articles->search_where( { section => { 'LIKE', 'reviews_p_%' } }, { order_by => "date DESC, time DESC", limit => 2 } );

doesent work? - help please

UPDATE

The limit command that you can use from class::dbi::abstractsearch, isnt working...., and im not getting anything from the error log...

Sorted forget to limit_dialect, and set the offset, one should read cpan properly :-)
Hang On still not working its not limiting (im using mysql)
Final Update
Sall working, laggy server day :-)
Thanks every one for the help

Barry Carlyon barry@barrycarlyon.co.uk

In reply to search like by barrycarlyon

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.