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. Theunique value is SKU+CAT combined; a SKU will have at most one record for anygiven CAT, but there can be multiple CAT's per SKU. And of course, the CATlong description is in another table entirely, so that data is not duped.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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:
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. Theunique value is SKU+CAT combined; a SKU will have at most one record for anygiven CAT, but there can be multiple CAT's per SKU. And of course, the CATlong description is in another table entirely, so that data is not duped.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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)