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:
Re2: Calculating multiple shipping... (1997)
[WebDNA] WebDNA on PowerPC Leopard Server (2009)
WebDNA 5.0 Questions (2003)
[OT] How'd it go, Sal? (2006)
Help name our technology! I found it (1997)
WriteFile and returns... (2000)
Format of Required fields error message (1997)
redirect strangeness (2000)
bug report -- leading < character (1998)
problem (how to mark orders as 'opened') (1998)
Bulk capture for Authorize.net (2004)
[BULK] [WebDNA] [BULK] WebDNA AJAX example wanted! (2010)
show all problem (1997)
an easy one... (2000)
Some ThankYou page problems (1997)
Two submit buttons ? (1997)
2.1 bugs left over from beta cycle (1998)
WebCat2b12--[searchstring] bug (1997)
Dashes and dots in credit card (1998)
Price and Formula.db (2002)