similar to: tinyint(1) and boolean

Hello, there is a table that has a column TINYINT(1) called status. Through mysql console I see its value as 1 (when is true) but if I do this in Rails console: Mytable.status => true give me "true" rather "1". How could I change 1 to true using some method? Or true to 1? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

this may seem silly but i just noticed that if in mysql the column which is a tinyint(1) happens 2 or greater, by a chance of glitch or corruption in the database(i did it manually ofcourse but i am speaking hypothetically), rails would see it as false. but i find that really wrong seeing how in mysql it sees any non-zeroes as true. i really think if it does happen to be any number other than 1

Hey all -- I''ve been using enumerable char(1)''s with ''y'' and ''n'' values for my Boolean columns in Rails, but it strikes me there should be a better way. How do you setup columns that represent true/false-ness in your schemas on Rails? Wondering what kind of standard approaches there are other than me writing something like class MyEntity

http://dev.rubyonrails.org/ticket/1117 I''ve attached a patch to ticket 1117 which fixes it so that booleans are escaped as booleans, not integers. Specifically, this situation will now work find_all(["send_date=? and sent=?", Date.today, false]) Which matches peoples expectations, but it causes some problems with the postgresql unit tests. Specifically, the use of

I''ve been reading the tutorial and I have problems with the TinyInt(1) for the attribute "item.done". I thought this thread would be the best to post it. I''m using Rails 1.1.14. When in the partial template _list_stripes appears: <%= list_stripes["done"] == 1 ? show_image("done_ico.gif") : "&nbsp;" %> it always returns the

Hey all I've been running a Dovecot 1X server for awhile. Most of the config was pretty simple using flat files. I'm switching to Dovecot 2X now, and want to switch to using SQL for lookups so I can share info with the Postfix front end. For starters I setup two SIMPLE SQL tables -- a 'users' table and a 'aliases' table, where each user can have many aliases. I want to

I am migrating to sql server 2000 from postgres and I have tried char(1), int, tinyint and bit datatypes to replace booleans, but without luck. the 1''s and 0''s are stored properly in the db, but checkboxes and dropdowns are not being auto-populated in rails. Anyone experience this before? thanx -- View this message in context:

Hi, I''m trying to get through the popular "Four Days with Rails" tutorial and am experiencing some problem with the "Priority" of the item. Right from the start, RoR seems to want to consider it as a value that must be boolean. The scaffolded code asks for "True/ False" as the input. PHPMyAdmin shows that the database thinks it should be an unsigned

Hi, Everything is in the title. With Rails 2.3.4 and MySQL 5.0.41: If have a table like this: +----------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL |

Hi, I''ve a boolean database field (tinyint(1)) wich allows nulls. Then, I''ve something like this: radio_button(''server'',''customer_has_login'',"NULL") radio_button(''server'',''customer_has_login'',true) radio_button(''server'',''customer_has_login'',false) The problem is

Hi everyone, I''m working on a new rails project and have to build it on top of a legacy oracle database. I''m trying to figure out how to get the number value from a NUMBER(1) datatype. So far I''m only getting a "true" value for 1 and "false" for any other number. From the console I can print out my object values and can see that there are number

Hi, Anyone got any cool tricks for converting a Rails site (in this case, a typo installation) from a mysql database to a postgresql database? I''ve got it almost working -- I''m doing a SQL dump from mysql and loading it into postgres. However, mysql does booleans as a tinyint with 0 = false and 1 = true. When I try to import that into a postgres database that expects booleans

There is a little problem in handling logicals in RMySQL: # here is the MySQL connection > con <MySQLConnection:(1816,0)> # here is the data frame > print(a<-data.frame(x=c(TRUE,FALSE),y=c(FALSE,TRUE))) x y 1 TRUE FALSE 2 FALSE TRUE # as promised, the two data frame columns are identified as logicals and # the field types are set to tinyint > field.types <-

Hi, I spent more than 4 days getting done with the "Four Days with Rails" tutorial, mostly because I ran into a few issues that seemed to stop me in my tracks.  But, after looking around, I was able to find the problems and solve them (in whatever way I thought best) :-) I''m posting the whole list of problems that I ran into with "Four Days with Rails" to the list so

Thanks for the input Blair Zajac and Chris (Nolan and Hall), and for others. If all of you have time, please follow this (the question still relates to the previous posts by me): I have provided full steps to reproduce the symptoms. If it matters, I''m running Ruby 1.8.2, Rails 1.0, and MySQL 5.0.15 on Windows XP Professional. 1. First, the setup MySQL ----- create database testdb;

Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in

Hi! I try to use a layered webservice and I want to get back an array of users; In the API I use: api_method :listUsers,:returns=>[[User]] in the service: def listUsers User.find(:all) end Result in soap mode: Don''t know how to cast TrueClass to Object Result in XML-RPC mode: You have a nil object when you didn''t expect it! You might have expected

Hi All, I am running into a little issue the ODBC adapter: rails: 1.2 ruby: 1.8.4 ODBC ruby binding: .0997 Rails ODBC adapter: 1.4 I have added the ruby bindings to the /ruby/1.8/i386-msvcrt and used gem to install the ODBC adapter I updated the enviroment.rb when I run ruby -e ''require "odbc"'' it appears to correct (no error response) 1. Is my understanding

I have defined a web service to return information from a database as follows. class BackendApi < ActionWebService::API::Base api_method :find_all_vobs, :returns => [[:int]] api_method :find_vob_by_id, :expects => [:int], :returns => [Vob] class BackendController < ApplicationController wsdl_service_name ''Backend''

All, This is really starting to get me as i can''t figure out why I am getting this error. Here is what is going on. I have a table called items and a item controller. When I add a new item to the items table I am also creating several associated tables. the code for this so that you can follow along is: def create @item = Item.new(params[:item]) # The item belongs to