Re: Design Help Needed
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20248
interpreted = N
texte = What would be the benefit to this? I am new to databases so if there is a reason to do it this way, what would it be? I would like to be able to use the quantity of matches in a search to dictate the order in which it displays. more matches = higher on the list of returned records.Could this method be helpful in doing that?- charles>Rather than have separate fields for each one of your options, why not >have one field called OPTIONS and store a separated list of options in >the field. Like the following: 1CarGarage+Basement+SwimPool. I would >maintain the options in a separate database so the codes you store in the >OPTION field are different than the actual names that appear in the HTML >(to prevent the plus sign from being in the name). Thus the option >database might be:>>OPTION_ID OPTION_NAME>1CAR 1 Car Garage>2CAR 2 Car Garage>POOL Swimming Pool>etc.>>Then the option field in your main database would have entries like the >following:>>OPTIONS>1CAR+POOL>2CAR+POOL>1CAR>>>John.>>>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 Systems>>>>Phone# 609-273-3255>>Fax# 609-273-3721>> John A. Hill, V.P. Marketing> Pacific Coast Software>eCommerce / Web Developer Tools> http://www.smithmicro.com>>_______________________________________________________________Charles Kline ckline@macsultants.com MacSultantsProfessional Solutions for Computer SystemsPhone# 609-273-3255Fax# 609-273-3721
Associated Messages, from the most recent to the oldest:
What would be the benefit to this? I am new to databases so if there is a reason to do it this way, what would it be? I would like to be able to use the quantity of matches in a search to dictate the order in which it displays. more matches = higher on the list of returned records.Could this method be helpful in doing that?- charles>Rather than have separate fields for each one of your options, why not >have one field called OPTIONS and store a separated list of options in >the field. Like the following: 1CarGarage+Basement+SwimPool. I would >maintain the options in a separate database so the codes you store in the >OPTION field are different than the actual names that appear in the HTML >(to prevent the plus sign from being in the name). Thus the option >database might be:>>OPTION_ID OPTION_NAME>1CAR 1 Car Garage>2CAR 2 Car Garage>POOL Swimming Pool>etc.>>Then the option field in your main database would have entries like the >following:>>OPTIONS>1CAR+POOL>2CAR+POOL>1CAR>>>John.>>>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 Systems>>>>Phone# 609-273-3255>>Fax# 609-273-3721>> John A. Hill, V.P. Marketing> Pacific Coast Software>eCommerce / Web Developer Tools> http://www.smithmicro.com>>_______________________________________________________________Charles Kline ckline@macsultants.com MacSultantsProfessional Solutions for Computer SystemsPhone# 609-273-3255Fax# 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:
OT: Quick poll (2003)
ERROR in docs (2003)
AutoCommit Preference? (1998)
What's New Date (2002)
Newbie Tax Question (1997)
Exclude by date - multiple (1997)
"Advanced" Search Algorithm (2008)
Sendmail & Time Issue (2001)
Need help with emailer- 2 issues (1997)
pc (1997)
Clean Code: Rules for inserting keyboard returns? (1997)
PCS Frames (1997)
A question on sub-categories (1997)
[WebDNA] HMAC-SHA1 Encryption (2013)
nested context (1998)
OT - good CC processor(s)? (1999)
Search Folder? (1998)
Navigator 4.01 (1997)
Items XX to XX shown (1997)
Special delete ... (1997)