Displaying 2 results from an estimated 2 matches for "capodir".
Did you mean:
caldir
2006 Jan 25
4
Cannot :order when using :offset and :limit in find
...@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 control over this (line is there, line isn''t, line is
there, line isn''t...) and would rather not resort to using a find_by_sql
but if I have to I will.
I am ru...
2006 Jan 26
1
Help constructing a find_by_sql command
...statement. I cannot use the build in because the
adaptor isn''t quite right (OCI8)
When I use it I get the following error
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 am not sure how to convert this into a find_by_sql statement, I tried:
result = Componentlog.find_by_sql ["select * from (select raw_sql_.*,
rownum raw_rnum_ from (SELECT * FROM componentlog WHERE (c...