search for: raw_rnum_

...= 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 control over this (line is there, line isn''t, line is there, line isn''t...) and would...

...gt; items_per_page, :order => "cl_spr DESC" ) in a find_by_sql 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 (sel...

...key, name varchar2(100)); And ruby script\generate model Customer ruby script\generate controller Customer http://localhost:3000/customer/ - show a fine list, but when I click show/edit/destroy, I get an ORA-01722: OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM customers WHERE (customers.id = ''5.0'') ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 The problem comes from the parameter applied: Request Parameters: {"id"=>"5.0"} id is a number, not a text string !?! Is this a configurat...

I''m using 2 database. The first wrote in MySQL and the second in Oracle. If i use the command "SET_TABLE_NAME" to forge the model to use another table, there isn''t no error with MySQL, while with Oracle if i ask the view "_Form.rhtml" The compiler tell me "No sequence in SELECT TableName_seq.nextval id from dual"(???). Could someone tell me where

..._default_integers'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/mocha-0.5.1/lib/mocha/test_case_adapter.rb:19:in `run'' 4) Error: test_joins_dont_clobber_id(FinderTest): ActiveRecord::StatementInvalid: OCIError: ORA-00905: missing keyword: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT companies.* FROM companies INNER JOIN companies AS clients ON clients.firm_id = companies.id WHERE (companies.id = 1) AND ( (companies.type = ''Firm'' ) ) ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 ./test/../lib/active_record/connection_adapters/abstra...

Hello everyone, I am trying to convince my colleagues to convert to Ruby on Rails, however I am up against the following problem: Ruby on rails seems to be primarily designed a single database doing a small number of queries. While trying to process a webpage that does thousands of sql queries on Oracle, I get the message that I have used up too many cursors. In Java, I can use stmt.close()