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:

    
  1. Re: Design Help Needed (Rob Marquardt 1998)
  2. Re: Design Help Needed (PCS Technical Support 1998)
  3. Re: Design Help Needed (charles kline 1998)
  4. Re: Design Help Needed (Rob Marquardt 1998)
  5. Re: Design Help Needed (Howard Wolosky 1998)
  6. Re: Design Help Needed (charles kline 1998)
  7. Re: Design Help Needed (charles kline 1998)
  8. Re: Design Help Needed (charles kline 1998)
  9. Re: Design Help Needed (PCS Technical Support 1998)
  10. Re: Design Help Needed (Laurent Pladys 1998)
  11. Design Help Needed (charles kline 1998)
>>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:

Squares instead of spaces (2001) math with multiple [founditems] (1999) Search with Special Chars (1997) brain teaser with an advanced search (2001) purchase plugin (1996) Popup Menu Options (1998) Emailer or [sendmail] questions ... (1998) show all problem (1997) Email (1998) Summary search -- speed (1997) underscore in variable name (2000) Making Thumbnail Graphics (1997) ShowNext (1997) [WebDNA] [BULK] WebDNA 7 - Showing every other far DB - Fault! (2011) Encrypting WebDNA Templates (1999) set header in DB (no cart) (2003) default error on NT? (1997) Getting total number of items ordered (1997) Summing fields (1997) select multiple (1997)