Re: categories and subcategories

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59911
interpreted = N
texte = We had to tweak the categories (sections.db I believe) database to include the related ID for categories. This allowed us to know when a category was a sub to another and to which it was a sub to. This allowed for something similar to this: [search db=sections.db&eqS_TYPEdatarq=eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1] [founditems] [include subs.inc] [/founditems] [/search] --- subs.inc [search db=sections.db&eqS_TYPEdatarq=eqR_IDdatarq=[SKU]&S_RANKtype=number&asS_RANKsort=1] [founditems] [include subs.inc] [/founditems] [/search] This will created a crawl effect. This is sample code, not what we used in production. But this is the general idea. Hope this helps. Ron ----- Original Message ----- From: "Paul Berman" To: "WebDNA Talk" Sent: Friday, November 05, 2004 2:13 PM Subject: Re: categories and subcategories > Hi Donovan > > What I have is this > > [search > db=admin/sections.db&eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1][foun > ditems] > > > [text]more=[search > db=admin/products.db&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&[hideif > [admin]=T]eqVISIBLEdatarq=T&[/hideif]max=1][numfound][/search][/text] > [showif [more]>0] > href="default.tpl?startat=1&--woSECTIONSdatarq=[s_id]&--SECTIONSword=ww&cart > =[cart]" onMouseOver="window.status='Product catagory for [S_Name] click > here to find products'; return true"> > [/showif] > [S_NAME] > [showif [more]>0] > > [/showif] > > [include file=sitemap_loop.inc] > > [/founditems][/search] > > and the sitemaploopfile is > > [search > db=admin/sections.db&eqS_RELATEDdatarq=[S_ID]&S_RANKtype=number&asS_RANKsort > =1] > > > > [founditems] > > > [hideif [lookup > db=admin/sections.db&lookinfield=S_RELATED&value=[S_ID]&returnfield=S_ID¬ > found=]=] > > [/hideif] > > > [/founditems] >
> [text]more=[search > db=admin/products.db&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&[hideif > [admin]=T]eqVISIBLEdatarq=T&[/hideif]max=1][numfound][/search][/text] > [showif [more]>0] > href="default.tpl?startat=1&--woSECTIONSdatarq=[s_id]&--SECTIONSword=ww&cart > =[cart]" onMouseOver="window.status='Click here to find the products we > offer in this category'; return true"> > [/showif] > [S_NAME] > [showif [more]>0] > > [/showif] > [include file=sitemap_loop.inc]
> [/search] > > > it works well but its slow > > it picks up the sections and subsections nicely but its significantly > slower > than it should be > > What I am looking for is a method that shows all the sections and > subsections quickly and clearly > > THanks > paul > > > > ----- Original Message ----- > From: "Donovan Brooke" > To: "WebDNA Talk" > Sent: Friday, November 05, 2004 11:08 PM > Subject: Re: categories and subcategories > > >> Paul, can you state the verbose version of what results >> you are wanting? Perhaps give a sample. >> >> thx, >> Donovan >> >> >> >> Paul Berman wrote: >> >> > I am trying to find a neat and quick solution to the issue I am having > with >> > the search.inc file from the original storebuilder >> > >> > I need it to show all the categories and subcategories but when I use > the >> > listing tecnique on the sitemap.inc page its very slow >> > >> > has anyone got an neat solution for this >> > >> > THanks >> > Paul >> >> >> >> -- >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> DONOVAN D. BROOKE Eucalyptus Design >> <-Web Development (specializing in eCommerce), -> >> <- Graphic Design, Custom Tags and Labels -> >> >> ADDRESS:> Donovan Brooke >> DBA Eucalyptus Design >> N2862 Summerville Park Rd. >> Lodi, WI 53555 >> PH:> 1.608.592.3567 >> Web:> http://www.euca.us >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> >> ------------------------------------------------------------- >> 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://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: categories and subcategories ( "WebDna @ Inkblot Media" 2004)
  2. Re: categories and subcategories ( "Paul Berman" 2004)
  3. Re: categories and subcategories ( Donovan Brooke 2004)
  4. Re: categories and subcategories ( "WebDna @ Inkblot Media" 2004)
  5. Re: categories and subcategories ( "Paul Berman" 2004)
  6. Re: categories and subcategories ( Donovan Brooke 2004)
  7. Re: categories and subcategories ( "Paul Berman" 2004)
We had to tweak the categories (sections.db I believe) database to include the related ID for categories. This allowed us to know when a category was a sub to another and to which it was a sub to. This allowed for something similar to this: [search db=sections.db&eqS_TYPEdatarq=eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1] [founditems] [include subs.inc] [/founditems] [/search] --- subs.inc [search db=sections.db&eqS_TYPEdatarq=eqR_IDdatarq=[SKU]&S_RANKtype=number&asS_RANKsort=1] [founditems] [include subs.inc] [/founditems] [/search] This will created a crawl effect. This is sample code, not what we used in production. But this is the general idea. Hope this helps. Ron ----- Original Message ----- From: "Paul Berman" To: "WebDNA Talk" Sent: Friday, November 05, 2004 2:13 PM Subject: Re: categories and subcategories > Hi Donovan > > What I have is this > > [search > db=admin/sections.db&eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1][foun > ditems] > > > [text]more=[search > db=admin/products.db&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&[hideif > [admin]=T]eqVISIBLEdatarq=T&[/hideif]max=1][numfound][/search][/text] > [showif [more]>0] > href="default.tpl?startat=1&--woSECTIONSdatarq=[s_id]&--SECTIONSword=ww&cart > =[cart]" onMouseOver="window.status='Product catagory for [S_Name] click > here to find products'; return true"> > [/showif] > [S_NAME] > [showif [more]>0] > > [/showif] > > [include file=sitemap_loop.inc] > > [/founditems][/search] > > and the sitemaploopfile is > > [search > db=admin/sections.db&eqS_RELATEDdatarq=[S_ID]&S_RANKtype=number&asS_RANKsort > =1] > > > > [founditems] > > > [hideif [lookup > db=admin/sections.db&lookinfield=S_RELATED&value=[S_ID]&returnfield=S_ID¬ > found=]=] > > [/hideif] > > > [/founditems] >
> [text]more=[search > db=admin/products.db&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&[hideif > [admin]=T]eqVISIBLEdatarq=T&[/hideif]max=1][numfound][/search][/text] > [showif [more]>0] > href="default.tpl?startat=1&--woSECTIONSdatarq=[s_id]&--SECTIONSword=ww&cart > =[cart]" onMouseOver="window.status='Click here to find the products we > offer in this category'; return true"> > [/showif] > [S_NAME] > [showif [more]>0] > > [/showif] > [include file=sitemap_loop.inc]
> [/search] > > > it works well but its slow > > it picks up the sections and subsections nicely but its significantly > slower > than it should be > > What I am looking for is a method that shows all the sections and > subsections quickly and clearly > > THanks > paul > > > > ----- Original Message ----- > From: "Donovan Brooke" > To: "WebDNA Talk" > Sent: Friday, November 05, 2004 11:08 PM > Subject: Re: categories and subcategories > > >> Paul, can you state the verbose version of what results >> you are wanting? Perhaps give a sample. >> >> thx, >> Donovan >> >> >> >> Paul Berman wrote: >> >> > I am trying to find a neat and quick solution to the issue I am having > with >> > the search.inc file from the original storebuilder >> > >> > I need it to show all the categories and subcategories but when I use > the >> > listing tecnique on the sitemap.inc page its very slow >> > >> > has anyone got an neat solution for this >> > >> > THanks >> > Paul >> >> >> >> -- >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> DONOVAN D. BROOKE Eucalyptus Design >> <-Web Development (specializing in eCommerce), -> >> <- Graphic Design, Custom Tags and Labels -> >> >> ADDRESS:> Donovan Brooke >> DBA Eucalyptus Design >> N2862 Summerville Park Rd. >> Lodi, WI 53555 >> PH:> 1.608.592.3567 >> Web:> http://www.euca.us >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> >> ------------------------------------------------------------- >> 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://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/ "WebDna @ Inkblot Media"

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:

Problems passing [SKU] with $Replace in 2.0 (1997) Tax on shipping (1998) Date subtraction (2002) Search design (1997) How to Sort Summ data ? (1997) Running _every_ page through WebCat ? (1997) maximu values for sendmail! (1997) Showif ~ Netscape : Showif ~ MSIE (2001) Suffix Slowdown? (2004) formulas.db (1999) process out of control....... (2002) Re:Emailer and encryption (1997) security (https) w webcat (1999) [LOOKUP] (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) 2nd WebCatalog2 Feature Request (1996) Database Erroe (2000) Feedback Please (2003) WebDNA tags in WebMerchant email templates ... (1997) Showif Context combined with Search (1997)