Displaying 1 result from an estimated 1 matches for "doolal".
Did you mean:
dollar
2006 Jan 25
4
Cannot :order when using :offset and :limit in find
...set => offset,
:limit => items_per_page )
However if I try and add an order...
@componentlogs = Componentlog.find(:all,
:conditions => [ "cl_compname like ?", @criteria ],
:offset => offset,
:limit => items_per_page,
:order => "cl_spr DESC" )
It goes totally doolally.
OCIError: ORA-00907: missing right parenthesis: select * from (select
raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM componentlog WHERE
(cl_compname like ''CAPODIR'') ORDER BY cl_spr DESC ) raw_sql_ where
rownum <= 25) where raw_rnum_ > 0
I don''t have much...