Re: Search wbrk (repost)

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40303
interpreted = N
texte = Bob Minor wrote: > > On 11/26/01 9:19 AM, John Peacock wrote: > > > and populate it with a single category per record. Then you don't have to > > play with wbrk at all. I don't know any other answer to your question, > > however, since I never store more than one value per field. > > But then a sku cant be in more than one cat at one time unless redundant > data is used, which is why I have cats and mcats. Where mcats store the > multilple categories that the sku is kept.Why do you think that? The SKU has as many records as it has CATegories. The unique value is SKU+CAT combined; a SKU will have at most one record for any given CAT, but there can be multiple CAT's per SKU. And of course, the CAT long description is in another table entirely, so that data is not duped.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search wbrk (repost) (John Peacock 2001)
  2. Re: Search wbrk (repost) (Bob Minor 2001)
  3. Re: Search wbrk (repost) (John Peacock 2001)
  4. Re: Search wbrk (repost) (Kimberly Ingram 2001)
  5. Re: Search wbrk (repost) (John Peacock 2001)
  6. Re: Search wbrk (repost) (Bob Minor 2001)
  7. Re: Search wbrk (repost) (John Peacock 2001)
  8. Re: Search wbrk (repost) (Glenn Busbin 2001)
  9. Re: Search wbrk (repost) (John Peacock 2001)
  10. Search wbrk (repost) (Bob Minor 2001)
Bob Minor wrote: > > On 11/26/01 9:19 AM, John Peacock wrote: > > > and populate it with a single category per record. Then you don't have to > > play with wbrk at all. I don't know any other answer to your question, > > however, since I never store more than one value per field. > > But then a sku cant be in more than one cat at one time unless redundant > data is used, which is why I have cats and mcats. Where mcats store the > multilple categories that the sku is kept.Why do you think that? The SKU has as many records as it has CATegories. The unique value is SKU+CAT combined; a SKU will have at most one record for any given CAT, but there can be multiple CAT's per SKU. And of course, the CAT long description is in another table entirely, so that data is not duped.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ John Peacock

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:

Sorting Various Sizes (2003) Solved. was pulldown menu differences (2005) [cart]'s ever get recycled? (2000) Search/sort in URL Was: GuestBook example (1997) Comments in db? (1997) [WebDNA] Ubuntu 11.10 (2012) SQL newbie (2002) delete fails (2000) (1997) attn: smitmicro - cart limitation (2002) ImageMagick and [shell] (2003) test (2002) Multiple Pulldowns (1997) Photo Album (2000) HTML encoding in URLs (1997) Database wiped clean (2005) Some Questions (1997) Help! WebCat2 bug (1997) READFILE command? (1998) I've been thinking (2002)