Re: Db design question (relational vs. flat?)
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17046
interpreted = N
texte = >I'd like to have certain products show up in more than one product category:>1) using the current category field, include all the appropriate category>names then [search] the category field for the desired cateogry and>return True when foundThis is certainly the fastest in terms of search speed and data entry --it's what we use for groups in the Users.db for the [protect] tag. Theonly downside is that someday you may want some automatic way to display alist of all such categories, and there is no easy way to grab those wordsas separate chunks once they're all stuffed into one big field.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I'd like to have certain products show up in more than one product category:>1) using the current category field, include all the appropriate category>names then
[search] the category field for the desired cateogry and>return True when foundThis is certainly the fastest in terms of search speed and data entry --it's what we use for groups in the Users.db for the
[protect] tag. Theonly downside is that someday you may want some automatic way to display alist of all such categories, and there is no easy way to grab those wordsas separate chunks once they're all stuffed into one big field.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
carriage returns in data (1997)
Assigning new CART number (1997)
Emailer help....! (1997)
WebMerchant 1.6 and SHTML (1997)
Cookies [was How do I get Google to crawl a WebCatsite?] (2003)
Stopping bad HTML propagation ? (1997)
2.1 Stuff (1998)
Help getting [shownext] to increment (2003)
PCS Frames (1997)
color and size options / ARCHIVES (1997)
Practice runs ? (1997)
If Empty ? (1997)
ListFiles and .DS_Store (2004)
[GROUPS] followup (1997)
[WriteFile] problems (1997)
WebCat2 several catalogs? (1997)
Shipcost Based on SubTotal (1998)
textarea (2000)
sort problems....bug or brain fart? (1997)
[WebDNA] [convertchars] and ascii problem (2010)