search for: select_on

Hi, I''m trying to execute something like this method in a model: def self.sql_for_rankings() sql = "SET @counter:=0;" sql << " SET @counter:=0; SELECT *, @counter:=@counter+1 AS rank FROM testscores. " find_by_sql(sql) end Where the new rank column is a kind of autoincrementer inside of

...pters/mysql_adapter.rb:180:in `execute'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:322:in `select'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in `select_one'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/database_statements.rb:16:in `select_value'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in `count_by_sql'' /usr/local/lib/ruby/gem...

...e.bin mentor.exe ,... err: ntdll: RtlpWaitForCriticalSection Critical Section 0x40e24230 wait timed out. Retrying (60 sec) fs=02b7 Wine failed with return code 143 I ran "wine --debugmsg +ntdll mentor.exe" and it included the above error message plus: wineserver: thread.c:445: select_on: Assertion `!current->wait' failed. Can anyone tell me what the above errors are indicating? Any ideas/solutions on how to fix problem so that I can run /c/Gentran/mentor.exe? THANK YOU. -pat

Hi, after changing a primary key column name, the auto-increment information (MySQL) and sequence (Oracle) are lost. What is the correct way to rename primary keys? Thanks, Gustavo -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

...85:in `execute'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/connection_adapters/mysql_adapter.rb:337:in `select'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/connection_adapters/mysql_adapter.rb:180:in `select_one'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/connection_adapters/abstract/database_statements.rb:16:in `select_value'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/calculations.rb:161:in `execute_simple...

...onfig/.. Application Trace | Framework Trace | Full Trace /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:325:in `select'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in `select_one'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/database_statements.rb:16:in `select_value'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in `count_by_sql'' /usr/lib/ruby/gems/1.8/gems/activ...

...inclusion_of", but I can''t seem to find the logic in it. So, how do I call it? This question could be generalised, because I never know what to call when something is not in de default namespace. For example, how do I know that "ActiveRecord::ConnectionAdapters::SQLServerAdapter.select_one" can be run by "ActiveRecord::Base.connection.select_one"? I happen to know this one, but I would have never guessed... Thanks in advance.

Hi, I just published the first version of a small tutorial I''ve written on Ajax and Rails. It is called "How to paginate, sort and search a table with Ajax and Rails" (sorry, I didn''t manage to find a longer title !) and is available at : http://dev.nozav.org/rails_ajax_table.html There is nothing really new in it, it''s rather a compilation and

Hi, I am quite new to Ruby on Rails so this might have a very simple answer... My problem gives the following error message when I try to call the count function for an item. Mysql::Error: Unknown column ''TournamentTemplate'' in ''where clause'': SELECT count(*) AS count_all FROM action_logs WHERE (action_logs.loggable_id = 1 AND action_logs.loggable_type =

.../config/.. Application Trace | Framework Trace | Full Trace /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:325:in `select'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in `select_one'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/database_statements.rb:16:in `select_value'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in `count_by_sql'' /usr/lib/ruby/gems/1.8/gems/activer...

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "<dsn

Hello, I have a data of Patents from OECD in delimited text format with IPC being one column, I want to filter the data by selecting only certain IPC in that column and delete other rows which do not have my required IPCs. Please, can anybody guide me doing it, also the IPC codes are string variables. The data is somewhat like below, but its a huge dataset containing more than 11 million rows

It would be very helpful if the core team could define and document the expected behavior of DatabaseStatements.execute(). The implementations appear to vary. Most adapters will return some sort of native result set, SQL Server returns nil and expects a block, DB2 and Sybase return the affected row count. So please, will someone in core explain the expected behavior and can the execute()

I know ActiveRecord doesn''t support composite primary keys, but I need to use one, and I need it ASAP. I don''t need any composite foreign keys, luckily; what I have is a table that stores old versions of rows in another table, so the composite key is an id + date stamp. Would someone tell me a hack I can use to support this? -- View this message in context:

Hi, Is there an easy way of querying an active record for a maximum column value? I need to do queries like: SELECT MAX(salary) FROM employees TIA, Jeroen

...on_adapters/mysql_adapter.rb:180:in `execute'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:322:in `select'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in `select_one'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/database_statements.rb:16:in `select_value'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in `count_by_sql'' c:/ruby/lib/ruby/gems/1.8/gem...

...on_adapters/mysql_adapter.rb:180:in `execute'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:322:in `select'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in `select_one'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/database_statements.rb:16:in `select_value'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in `count_by_sql'' c:/ruby/lib/ruby/gems/1.8/gem...

...nk (0x403ee2cc)->(flags=0x00000001,handle=0x00000000) fixme:midi:OSS_MidiInit Synthesizer support MIDI in. Not supported yet (please report) err:wave:DSDB_MapPrimary (0x403f1e90): Could not map sound device for direct access (errno=5) fixme:pthread_kill_other_threads_np wineserver: thread.c:445: select_on: Assertion `!current->wait' failed. --- Bye, Manfred -- /"\ | PGP-Key available at Public Key Servers \ / ASCII ribbon campaign | or at "http://www.mahowi.de/" X against HTML mail | RSA: 0xC05BC0F5 * DSS: 0x4613B5CA / \ and postings...

...lserver'', ''username'', ''password'') => #<DBI::DatabaseHandle:0xb750bf58 @trace_mode=2, @handle=#<DBI::DBD::ODBC::Database:0xb750bea4 @attr={}, @handle=#<ODBC::Database:0xb750becc>>, @trace_output=#<IO:0xb7d35fec>> >> conn.select_one(''SELECT Subject FROM CASE WHERE CaseId = 12345678;'') => ["Test Case"] >> conn.disconnect Assuming this is the best way to achieve this (unless there''s good reason to do so I don''t want to create models as the SQL code above is greatly simpl...

...thod `fetch_fields'' for nil:NilClass): /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/ active_record/connection_adapters/mysql_adapter.rb:204:in `select'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/ active_record/connection_adapters/mysql_adapter.rb:98:in `select_one'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/ active_record/base.rb:452:in `count_by_sql'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/ active_record/base.rb:445:in `count'' /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/ action_controll...