Design Help Needed

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20233
interpreted = N
texte = I am building a website where people can post homes for sale and search for homes. Kind of like realtor.com In my database I have fields for all the usual stuff: city state, price, square footage, floors, bedrooms, lot size, etc. I also have fields that are more specific and are using check boxes like: 1CarGarage, 2CarGarage, Basement, Wooded Lot, Swimming Pool...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 want the search form to be able to search for all the different criteria and show the results in a rated list. Showing the most matches first.let me know what y'all think.Thanks,Charles_______________________________________________________________ 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)
I am building a website where people can post homes for sale and search for homes. Kind of like realtor.com In my database I have fields for all the usual stuff: city state, price, square footage, floors, bedrooms, lot size, etc. I also have fields that are more specific and are using check boxes like: 1CarGarage, 2CarGarage, Basement, Wooded Lot, Swimming Pool...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 want the search form to be able to search for all the different criteria and show the results in a rated list. Showing the most matches first.let me know what y'all think.Thanks,Charles_______________________________________________________________ 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:

WebCat2b13MacPlugIn - More limits on [include] (1997) Multiple catalog databases and showcart (1997) Searchable WebCat (etc.) Docs ? (1997) WebCat2: multiple currency support (1997) webcat- multiple selection in input field (1997) PCS Frames (1997) Questions (1998) admin login weirdness (2000) shownext (1997) Bug? (1997) Price characteristics? (1997) No luck with taxes (1997) Mac Lockup Problems (1998) Can WC remember people? (1998) Sort Order on a page search (1997) Re:Saving/Looking Up customer numbers (1998) WebCatalog Hosting (1996) 2nd WebCatalog2 Feature Request (1996) Re:2nd WebCatalog2 Feature Request (1996) [Announce]: Web server security and password protection (1997)