|
Replies:
0
-
Pages:
1
|
|
|
Posts:
4
Registered:
6/2/08
|
|
|
|
ERROR ON DISPLAYING TINYINTS AS CHECKBOXES [1 Attachment]
Posted:
Aug 23, 2011 9:37 AM
|
|
|
<*>[Attachment(s) from Bob Syslo-Seel included below]
<<ToadSupportBundleToad for MySQL.zip>>
1. Create a table with multiple tinyint(1) columns. Make them null with
NO default value.
2. Create a spreadsheet that has value of 1 for some rows for some of
these columns
3. LEAVE REMAINING COLUMNS BLANK in EXCEL.
4. Use IMPORT tool to load spreadsheet to table.
5. Query resulting data. Its a mess, some values are "TRUE" but shown
as checked box, some are represented as dark blue checkbox with no
checkmark.
6. Go to column header in result set and try to display the list of
values to filter by--BOOM you get error.
7. Interestingly, if you do an export to an Excel Instance, some of the
values actually say "TRUE", and the rest are ones.
Solved the problem by revising the table definition to be tinyint(1) not
null default 0. Loaded the data and got grey checkboxes in the result
set, some of which were checked.
Have fun!
Bob Syslo-Seel
Data Architect
All Star Directories
bobs@allstardirectories.com
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
