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 PMSubject: 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]>> > [/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:
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 PMSubject: 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]> > [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]> | >> [hideif [lookup> db=admin/sections.db&lookinfield=S_RELATED&value=[S_ID]&returnfield=S_ID¬> found=]=]> [include file=sitemap_loop.inc] | > [/hideif]>>
> [/founditems]>
> [/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)