CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> IDE/GUI

 Web Designer

Print topic Send  topic

Author Message
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
View profile  Send private message
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/
>


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.