blizz1001
|
Posted: 07/23/2004, 1:43 AM |
|
Hi,
I've got a question. Is it true that when using Data Type as Boolean, you can only set up to 3 values? Eg. Data type: Yes;No;Dunno and DBFormat: 1;2;3?
What if i need to convert the values in the DB (1,2,3,4,5,6,7,8,9,10,11,12) to different values (Jan,Feb, Mar,Apr,May.Jun,Jul,Aug,Sep,Oct,Nov,Dec) to display in the control? By using the boolean method i can only display the values up to Mar. Any value after 3, eg, 4 or 5 or 6, etc, will return 'Mar' in the display field.
How do I rectify this problem?
Any help is appreciated.... thanks!
Lia
|
|
|
dataobjx
Posts: 181
|
Posted: 07/23/2004, 4:57 AM |
|
A boolean value is 1 (True), 0 (False) and NULL (neither 0 or 1)
If you want to do the months thing, you need to change your field to 'Number' or 'Integer' - depending on your database.
_________________
www.DataObjx.net
www.mydigitalapps.com |
|
|
Walter Kempees
|
Posted: 07/24/2004, 1:07 PM |
|
Better still, avoiding creating an extra table and retaining all values in
the master table
you could use the ENUM field type or the SET type. http://dev.mysql.com/doc/mysql/search.php?q=enum&from=%...ET.html&lang=en
(larger collections) http://dev.mysql.com/doc/mysql/en/SET.html (smaller collections).
Note: This is usually only usefull for static (not changing) array of data,
if at any time in the future of yr project you anticipate addig or modifying
values then go for a separate table containing the reference id and value,
linking this to your master table containing only the id pointing to.......
Walter
"dataobjx" <dataobjx@forum.codecharge> schreef in bericht
news:44100fd142b089@news.codecharge.com...
> A boolean value is 1 (True), 0 (False) and NULL (neither 0 or 1)
>
> If you want to do the months thing, you need to change your field to
'Number'
> or 'Integer' - depending on your database.
> _________________
> www.DataObjx.net
> Provider of Database Driven Applications
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|