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:

    
  1. Re: Db design question (relational vs. flat?) (Grant Hulbert 1998)
  2. Re: Db design question (relational vs. flat?) (Dale Stokdyk 1998)
  3. Re: Db design question (relational vs. flat?) (PCS Technical Support 1998)
  4. Db design question (relational vs. flat?) (Dale Stokdyk 1998)
>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:

Speaking of... (1999) WordBreak Qestion (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Creditcard verification with WebCat (1998) help! problem using [referrer] still in 2.01 (1997) Cancel Subscription (1996) Great product and great job ! (1997) BBEdit WedDNA Codeless Language Module (2004) sorting... (2003) Sorting Various Sizes (2003) [showif],[refferer],[include] in errormessages.db (2002) OT-JS why it does not run on Mac (2001) WC2.0 Memory Requirements (1997) close to search (2001) Summary search -- speed (1997) Where's Cart Created ? (1997) can WC render sites out? (1997) Can you do this??? and other stuff (1997) Error Lob.db records error message not name (1997) Cancel Subscription (1996)