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:

SiteCheck & WebCat ? (1997) t or f (1997) Hard Questions ? (1997) Re:quit command on NT (1997) GroupField Returns (2002) WebCommerce: Folder organization ? (1997) Problems with [Applescript] (1997) Multiple catalog databases and showcart (1997) Webcatalog and foreign languages (1998) Non-Cart Files in Shopping Cart Folder (1997) WebCatalog-NT?'s (1996) Download Question (1997) WebCat2 - storing unformatted date data? (1997) Re:Listfiles (1998) Siteedit (1999) RE: extended ASCII with middle command (1999) Is there a 'does not contain' comparison? (1999) Cart questions (1997) null characters (2004) Refering page (1998)