Re: Design Help Needed

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20266
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:

Smart caching problems with 2.1b3? (1997) Refresh cart# (1999) How to Display text in empty fields (1997) (thx) automating a POST (2002) [convertchars] (2000) WebCatalog for guestbook ? (1997) search form problem.. (1997) Example Search Form (1997) Converting SQL Microtime to Date and Time (2003) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Webmerch tags? (1998) [date] tag not working on mac 4.0.1 (2000) Limiting user access to .tmpl files (1997) Calculating multiple shipping... (1997) Fwd: [ANNOUNCE] BIAP W*API Patch plug-in (1998) Line items in table cells (1997) sendmail (2000) [SearchString] problem with [search] context (1997) Mac 2.1b2 speed (1997) Taget _top (2000)