similar to: PATCH for Active Record 0.9 SQL Server Adapter problem => Rails 0.11does not work with SQL Server

I''m having an error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template =>

I''ve got a left join problem of some sort connecting from linux FreeTDS/ODBC to SQL Server. It''s similar to the false post I had earlier, but this is a real problem. Here''s my code: def find_recipes_for_workorder @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :joins => ''left join workorder on

Since we upgraded to Rails 1.0 and lighty last week we''ve had the rails application crash daily with the following error in the production.log file: Errno::EPIPE (Broken pipe): /usr/local/lib/ruby/1.8/mysql.rb:1042:in `flush'' /usr/local/lib/ruby/1.8/mysql.rb:1042:in `write'' /usr/local/lib/ruby/1.8/mysql.rb:462:in `write''

Hi all, Now that I have FastCGI set up and running on my Rails app, I''ve run into some strange behavior. I keep getting errors when trying to hit the DB: ActiveRecord::StatementInvalid in Reports#software_rev Invalid argument: SELECT * FROM versioned_components C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/conn ection_adapters/abstract_adapter.rb:339:in

I''m hand editing my .css and .rhtml files using SciTE and hitting refresh in my browser to see the results - its slow going. What tools are people using to author their .css and .rhtml files? Thanks, Neville _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

I''ve been using the login generator ''out of the box'' for simple authentication, and its been working fine. Now I want to extend it by simply adding ''type_id'' field which links to my ''user_types'' table, but I''m hitting: #<ActionController::SessionRestoreError: Session contained objects where the class definition

Hi and thanks for Ferret! I''m wondering if it would be possible to create a Ferret Win32 gem which includes the c performance code pre-compiled for those of us without a C compiler handy ? Zed Shaw seems to have cracked this particular nut with his Mongrel Win32 gem. Alternately, is there a zip of the Win32 .so Ferret needs that I could download and manually install? Kind Regards

In my app, a user logs in [via the login generator] and has access to details of his account, and transactions attached to his account. This is achieved in the standard rail manner by passing the account id or transaction id between the controller and the view. But what is to stop someone hacking the URL or view html to access another account id or transaction id ? eg /account/show/46 becomes

>> that should be "belongs_to :user_type" Bingo! -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Jarkko Laine Sent: Wednesday, 9 March 2005 6:59 PM To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org Subject: Re: [Rails] Confused about

Upgraded from Rails 1.0 to 1.1 and found that the (slightly modified) acts_as_taggable plugin breaks. The line add_limit!(sql, options) (in the tags_count method) causes this error wrong number of arguments (2 for 3) The documentation still says it takes two args, so I''m not sure what''s wrong. Adding logger.info("SQL here: " + sql)

So, I''ve used Rails to tie into a legacy system which is on SQL Server 2000 with a required timestamp field, DBTimeStamp. The field is defined in SQL Server as type timestamp, but when rails is pulling it in, it appears it may be casting to a datetime format. So, when I try to read or write to the field, it gives me a parsing error: NoMethodError: private method

"bitsweat" has given AR/SQLServer some love, but it''s still unhappy... http://dev.rubyonrails.org/changeset/6912 ------------------------------------------------------------------------ r6912 | bitsweat | 2007-05-31 10:15:56 -0700 (Thu, 31 May 2007) | 1 line Fix an edge case with find with a list of ids, limit, and offset. Closes #8437.

I''m seeing the following in the WEBbrick console output after every GET 192.168.0.108 - - [03/Mar/2005:15:35:19 AUS Eastern Daylight Time] "GET /favicon.ico HTTP/1.1" 200 60 - -> /favicon.ico What does /favicon.ico (which doesnt seem to exist in my source) do for Rails? _______________________________________________ Rails mailing list

/usr/local/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb" -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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

I''m having some trouble with the count method on AR objects. Here is a stack trace: >> t.subscriptions.count ArgumentError: wrong number of arguments (2 for 3) from /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/ lib/active_record/calculations.rb:160:in `add_limit!'' from /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/

So my automated script caught this issue, though I think my email headers were bad, so rails-core has put the automated email on hold pending "moderation". I''ll fix that issue, and look at the one below as well. -------- Original Message -------- Subject: Rails AR/Oracle Unit Test: [4185] failed Date: Thu, 6 Apr 2006 08:32:04 -0700 From: Michael Schoen

Hello, In a model I have: has_many :things, :finder_sql => '' select * from other_things '' + '' where id = #{id} '' When I do MyClass.find(:all, :include => :things) I get a weird error: from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in

Hello, When I try: @tagged_items = Problem.find_tagged_with :all => ''kuba'' or @tagged_items = Problem.tags_count :limit => 100 I get this error: ArgumentError in Volume#index wrong number of arguments (2 for 3) RAILS_ROOT: script/../config/.. Application Trace | Framework Trace | Full Trace

All, Rails 1.1.6. Any AR find() call that generates a SELECT * type query against a table with a DATETIME column in SQL Server whose value occurs before 1970 will fail, because of the coercion of SQL Server datetime types to Time values in Ruby. See sqlserver_adapter.rb line 490 (record[col] = record[col].to_time if record[col].is_a? DBI::Timestamp) If I remove the coercion (just commenting

I implemented a "reindex" command which simply creates an IndexWriter with :create => true for a prexisting index. The "reindexing" seems to start out ok, with several thousand docs added, then Ferret throws an exception: IO Error occured: couldn''t rename file "index\_0.tmp" to "index\_0.cfs": <File exists> I guess that _0.cfs is held