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:

Error.html (1997) Forms Search Questions (1997) carriage returns in data (1997) Quickie question on the email templates (1997) [WebDNA] Problem with Sendmail (2012) [addlineitems] (1997) [/application] error? (1997) Forumulas.db & Variables (2002) unable to launch acgi in WebCat (1997) DocNote#1 - GREP info missing ... (2000) Separate SSL Server (1997) PCS Customer submissions ? (1997) Showing unopened cart (1997) wc 2 pro users - sites, quotes wanted (1997) Strange Crash (1998) Setting up WebCatalog with Retail Pro data (1996) WebCat2 several catalogs? (1997) form data submission gets truncated (1997) Date format problems (1997) Webcat 2.0.1 date math bug -> Crash! (1997)