Since no one seemed able to answer my question, I went looking elsewhere,
and found the solution. Just wanted to share with you, in case anyone else
is having the problem. I realize now (too late), that I should have posted
this on the MySQL .NET list. I'm sure someone would have answered there.
Anyway...
Apparently, MySQL Stores a BIT value as a character. Chr(0) = False, and
Chr(1) = True. Once I discovered this, I was easily able to do a
FirstTime.Checked = (RS(FirstTime) = Chr(1)), and it worked perfectly.
Jesse
- Original Message -
From: Jesse [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Wednesday, January 17, 2007 5:23 PM
Subject: ASP.NET Access to MySQL BIT field-Help
OK. I don't recall having a problem with this before, but, how do I
assign
a variable to a MySQL Bit field? I'm trying to set up a CheckBox that is
on
my form, and I've tried variations of the following:
FirstTime.Checked = CBool(RS(FirstTime))
FirstTime.Checked = CBool(RS(FirstTime).ToString)
FirstTime.Checked = RS(FirstTime)
FirstTime.Checked = Convert.ToBoolean(RS(FirstTime))
I believe that all of them give the error, String was not recognized as a
valid Boolean. When I view the field value in SQL Manager 2005 Lite, It
presents a check box for the field value. When I view it through the
MySQL
Query Browser, it presents the value as b'1'
Any hints? I'm sure this is a basic issue, but I just can't seem to find
a
way to do it.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
