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. The only downside is that someday you may want some automatic way to display a list of all such categories, and there is no easy way to grab those words as 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 | Typhoon 619/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. The only downside is that someday you may want some automatic way to display a list of all such categories, and there is no easy way to grab those words as 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 | Typhoon 619/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:
A question on sub-categories (1997)
Mass deletion of records (2006)
[WebDNA] Installation problems for IIS 6 (2010)
MS Access data conversion (2001)
WebCat2 several catalogs? (1997)
WebCatalog for guestbook ? (1997)
Stopping bad HTML propagation ? (1997)
Cookie woes with Mac IE4 (1998)
[OT] Indexing of dynamic web sites (2003)
Different Drive (2003)
F*** you (1998)
404 error -- but wc code executes... (2001)
[OT] Indexing of dynamic web sites (2003)
wierd crashes for multi-sendmails on NT (1997)
javascript & webdna... search without refresh (2002)
Stumped on ShowNext -using variables (1997)
WC2b12: Yes, Formulas.db is for real (1997)
WCS Newbie question (1997)
WebCat2b15MacPlugin - [protect] (1997)
WC2b12: Yes, Formulas.db is for real (1997)