Sql Server 2000 booleans not working


#1

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:
http://www.nabble.com/Sql-Server-2000-booleans-not-working-t1241136.html#a3285183
Sent from the RubyOnRails Users forum at Nabble.com.


#2

On 3/7/06, glassneck removed_email_address@domain.invalid wrote:


View this message in context:
http://www.nabble.com/Sql-Server-2000-booleans-not-working-t1241136.html#a3285183
Sent from the RubyOnRails Users forum at Nabble.com.


Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails

Hi.
Use bit. Watch for NULL in the data. ActiveRecord maps true/false for
the
values.
I’m not sure what you’re after with “auto-populating”… I thought
everything was hand-coded in Rails. If you mean scaffolding, scaffolds
don’t know about checkbox.


#3

Much appreciated. bit is doing the trick.

Thanks!

View this message in context:
http://www.nabble.com/Sql-Server-2000-booleans-not-working-t1241136.html#a3309397
Sent from the RubyOnRails Users forum at Nabble.com.