ActiveRecord and SQL Server


#1

Hi all,

I am exploring using RoR for a new project but have run into a
problem with ActiveRecord and SQL Server’s timestamp datatype.

We have a NOT NULL timestamp column in a table and ActiveRecord keeps
trying to update it, which promptly causes it to blow up. I have
tried making the value NULL for insert and update in the model, but
SQL Server doesn’t like that either.

Is there any way to get ActiveRecord to just completely ignore that
column short of using a view to hide it?

Cheers,

–Ed


#2

What is the name of the column?

 Erik.

Ed Silva schreef:


#3

On 5/4/06, Ed Silva removed_email_address@domain.invalid wrote:

Is there any way to get ActiveRecord to just completely ignore that
column short of using a view to hide it?

Off the top of my head, something like this may work:

class Record < ActiveRecord::Base
def self.columns
super.reject {|c| c.name == “timestamp”}
end
end

Tom


#4

This did the trick, thanks! Now I won’t have to use perl for this
project! :slight_smile:

Cheers,

–Ed