Re: Design Help Needed
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20267
interpreted = N
texte = >>My question is what do I store in the database for these later items? My >>initial thought ws to store a T of F whether they have or don't have >>these features. But, I am real new to database design and need some >>advice before I get too deep. > >I think this is a good idea. This will also make it easier to re-use those >databases in some other program like FileMaker if you ever need to do some >manipulation there. You can search for those various criteria more easily >when they are in separate fields like that, too.Good, this is the way I will go. I have one more question though. I am using check boxes for the options. If it is checked I will send the value 'T', is there a way to have an 'F' sent if the box is not checked or is it cool to just leave the field empty in the database? _______________________________________________________________ Charles Kline ckline@macsultants.com MacSultants Professional Solutions for Computer SystemsPhone# 609-273-3255 Fax# 609-273-3721
Associated Messages, from the most recent to the oldest:
>>My question is what do I store in the database for these later items? My >>initial thought ws to store a T of F whether they have or don't have >>these features. But, I am real new to database design and need some >>advice before I get too deep. > >I think this is a good idea. This will also make it easier to re-use those >databases in some other program like FileMaker if you ever need to do some >manipulation there. You can search for those various criteria more easily >when they are in separate fields like that, too.Good, this is the way I will go. I have one more question though. I am using check boxes for the options. If it is checked I will send the value 'T', is there a way to have an 'F' sent if the box is not checked or is it cool to just leave the field empty in the database? _______________________________________________________________ Charles Kline ckline@macsultants.com MacSultants Professional Solutions for Computer SystemsPhone# 609-273-3255 Fax# 609-273-3721
charles kline
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[WebDNA] WebDNA 6.1 Info (2008)
Is there a max number of fields? (1998)
show all problem (1997)
[WriteFile] problems (1997)
Summing fields (1997)
[WebDNA] CICADA (2008)
taxTotal, grandTotal (1997)
New public beta available (1997)
WebCatalog 4 Install Problems - Not Answered ?? (2000)
oops private message leaked into talk list (1997)
WCS Newbie question (1997)
Cookie set browser session. (1998)
GoLive CyberStudio 1.0.1 (1997)
WebCat 4.5 Email Problems? (2003)
Migrating to NT (1997)
WebCat2 several catalogs? (1997)
Runtime (1998)
Separate SSL Server (1997)
[WebDNA] WebDNA version 7 feature list? (2011)
Text data with spaces in them... (1997)