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:

Using Plug-In while running 1.6.1 (1997) [DOS] (1999) Wireless WebDNA available today! (2000) Re[2]: 2nd WebCatalog2 Feature Request (1996) Mult-File Upload w/ Web Star (2000) TRAINING videos - Prove IT. (1998) Decrypting a user password (2000) TCPConnect strange behaviour (2004) Forumulas.db & Variables (2002) Null Characters (2005) Stumpted Again (1997) Need relative path explanation (1997) Am I going senile? (Price recalc based on quantity) (1997) [OT] Checkboxes! Javascript? (2005) MySQL Dates and WebDNA (2005) Error with [applescript] (1999) Protect (1997) Email notification to one of multiple vendors ? (1997) Question about [encrypt] (1998) Webcat2, WebCommerce, Mod 10 etc. (1997)