Rails are postgreSQL booleans different from mySQL booleans?

Question

I am using that problem that nothing gets saved on my server that uses PostgreSQL.

I have this action here, that updates a boolean it works on my local machine that uses mySQL:

def reel_online

    @movie = Photographer.find(params[:id])

    if @movie.reel_online == false
      @movie.update_attributes(:reel_online => true)
    else
      @movie.update_attributes(:reel_online => false)
    end

    render :nothing => true
end

The strange thing is that with firebug I can see there is no error on the server, but the boolean dos not get changed.

UPDATE: I changed my action to:

def reel_online

    @movie = Photographer.find(params[:id])

    if @movie.reel_online == 'f'
      @movie.update_attributes(:reel_online => 't')
    else
      @movie.update_attributes(:reel_online => 'f')
    end

    render :nothing => true
end

Still there is no error but the boolean is not saved. And my count of true reel_online is 0: <%= @movies.where(:reel_online => 't').count %> In my MySQL database I have set all reel_online to 0

Possible duplicate of stackoverflow.com/questions/6109060/… — bricker
– bricker, Commented Oct 15, 2011 at 10:45
By the way, a better way to write that would be @movie.update_attributes(:reel_online => [email protected]_online). Just a tip. — bricker
– bricker, Commented Oct 15, 2011 at 11:57
It's just more concise. Not a big deal really, just thought I'd point it out. — bricker
– bricker, Commented Oct 15, 2011 at 12:07

Rails beginner · Accepted Answer · 2011-10-15 11:06:15Z

1

The problem is that in my controller I should use true and false and in view it should be:

<%= @movies.where(:reel_online => 't').count %>

answered Oct 15, 2011 at 11:06

Rails beginner

14.5k35 gold badges140 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails are postgreSQL booleans different from mySQL booleans?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related