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:
[WebDNA] [BULK] WebDNA Windows Install (2016)
Setting up WebCatalog with Retail Pro data (1996)
Date Math (1999)
Re2: frames & carts (1997)
SandBox and ImageMagick (2003)
RAM variables (1997)
Separate SSL Server (1997)
NT considerations (1997)
[SearchString] usage (1997)
Some ThankYou page problems (1997)
Memory Leak (2000)
convert WebDNA from flat file to MySQL (2006)
security problem (1997)
Which is Faster (1998)
Sku numbers (1997)
displaying New products (using [date]) (1997)
includes and cart numbers (1997)
WebCat2b15MacPlugin - showing [math] (1997)
listfiles-looking for slick solution (1997)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)