[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

activerecord new version differences

Ernst Tanaka

6/10/2008 6:49:00 PM

I am sorry, but I am struggling. I installed new versions of my gems and
my programs don't run anymore. As suggested I tried to roll back to
older versions, but that is becoming a bigger mess. The flight forward
has at least recovered 90% of my application.

Both statement worked perfect with the old version of activerecord.
Now the first one works okay, the last one does not get the join built
up in the sql statement.

Again thanks for all the help.
Ernst

This statement works:

owner = Owner.find(:all, :include => {:accounts => {:orders =>{}}},
:conditions => ['Orders.flag = 0'],
:order => ['owners.name, accounts.name, orders.id'])

This statement does not work:
owner = Owner.find(:all,
:include => {:accounts => {:trades =>{}}},
:order => ['owners.name, accounts.name, trades.underlying, trades.month,
trades.strategy'] )

---------
The error I get is a that accounts.name is not a valid column. Which is
caused by the fact that the join is not added into the SQL statement.



Here is my Schema:
class Owner < ActiveRecord::Base
has_many :accounts
end
class Account < ActiveRecord::Base
belongs_to :owner
has_many :trades
has_many :orders
end
class Order < ActiveRecord::Base
belongs_to :account
end
class Trade < ActiveRecord::Base
belongs_to :account
has_many :legs
end
class Leg < ActiveRecord::Base
belongs_to :trade
end
class Earning < ActiveRecord::Base
end
--
Posted via http://www.ruby-....
4 Answers

Ryan Davis

6/10/2008 6:58:00 PM

0


On Jun 10, 2008, at 11:48 , Ernst Tanaka wrote:

> I am sorry, but I am struggling. I installed new versions of my gems
> and
> my programs don't run anymore. As suggested I tried to roll back to
> older versions, but that is becoming a bigger mess. The flight forward
> has at least recovered 90% of my application.

this really isn't the place for rubyonrails questions... join the
rubyonrails mailing list and ask there, or ask in irc on #rubyonrails
on irc.freenode.net.

The mailing list is probably more helpful (signal:noise), I dunno, but
irc is more immediate.

Ernst Tanaka

6/10/2008 7:04:00 PM

0

Ryan; I might be misguided but I am not using rails in this application.
Just trying to access a database while using Activerecord. There are
probably 100 smarter ways to do it. But as a nuby I am happy with the
one I found that worked for my over the last 6 months.

Thks,

Ernst
--
Posted via http://www.ruby-....

Ryan Davis

6/10/2008 9:10:00 PM

0


On Jun 10, 2008, at 12:04 , Ernst Tanaka wrote:

> Ryan; I might be misguided but I am not using rails in this
> application.
> Just trying to access a database while using Activerecord. There are
> probably 100 smarter ways to do it. But as a nuby I am happy with the
> one I found that worked for my over the last 6 months.

Active record is developed and maintained by the rails developers.
They provide the support for it.

Ernst Tanaka

6/10/2008 9:31:00 PM

0

thanks; I re-posted on the rails section of this forum.
--
Posted via http://www.ruby-....