Re: show related items

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 47128
interpreted = N
texte = Where its getting a little goofy for me is:in the products db.the sections info is entered into the db as +1+6+4+5+2+8+7+For Chicago as an example, I need +1+6+4+5 but not +2+8+7+thats where I'm not suceeding in my results.At 02:01 PM 1/23/03 +1100, you wrote:>Maybe it's best to do a quick lookup in the search.>>[Search db=^frugal/sections.db&eqS_RELATEDdata=[LOOKUP>db=^frugal/sections.db&value=[city]&lookInField=S_NAME&returnField=S_RELATED>¬Found=TextIfNotFound]]>[Founditems]>[hideif [S_NAME]=[city]][S_Name]
[/hideif]>[/Founditems]>[/Search]>>>Regards,>Tim>-->Tim Robinson>IDFK Web Developments>tim@idfk.com.au>114a/40 Yeo Street>Neutral Bay 2089>Australia>Phone +612 9908 2134>Fax +612 9908 4837>> > From: Lester Emo > > Reply-To: (WebCatalog Talk)> > Date: Wed, 22 Jan 2003 20:52:31 -0600> > To: (WebCatalog Talk)> > Subject: show related items> >> > I have a couple of sites that use lots of the Admin thats inside > storebuilder.> > It just fit the useability of those sites and all is well . . .> >> > I'm trying to use these same storebuilder routines for another site but I> > can't seem to pull the related data that I want from the databases . > . . .> >> > 2 databases uses.> >> > product.db> > sections.db> >> > a typical entry in products.db would have in the [sections] field> > +1+6+4+5+2+8+7+> >> > These numerical entries are for pulling information from the sections.db> > which looks like this:> > S_ID S_TYPE S_NAME S_RANK S_RELATED> > 1 M Chicago 1> > 2 M Milwaukee 1> > 3 M Detroit 1> > 4 Joliet 1 1> > 5 Schaumburg 2 1> > 6 Arlington 3 1> > 7 Racine 1 2> > 8 Kenosha 2 2> >> >> >> > What I want to do is show all items from the Chicago but then list all> > the related cities as well . . .> >> >> > The closest I've come is with this, but its not right.> > It shows ALL related items, even those not relevant.> >> > [Search db=^frugal/sections.db&eqS_RELATEDdata=[city]]> > [Founditems]> > [S_Name]
> > [/Founditems]> > [/Search]> >> >> > Is there a better way to pull the city and related cities from a database> > other than what I'm trying to do with storebuilder???> >> >> >> > Again the only reason storebuilder templates were used and pulled apart to> > work was it had all the needed admin areas already there and useable with> > little changes.> >> > does it make sense how I explained it??> >> >> > thanks.> >> >> > hey, that thread on security in a strorefront and switching to asp etc.> > I;m sure Bob Minor and his NFL teams could offer a rebuttal on webdna> > working well and being secure to function well in e-commerce.> >> >> >> >> > -------------------------------------------------------------> > 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:

Re: show related items (Tim Robinson 2003)
Re: show related items (Lester Emo 2003)
Re: show related items (Tim Robinson 2003)
show related items (Lester Emo 2003)

Where its getting a little goofy for me is:in the products db.the sections info is entered into the db as +1+6+4+5+2+8+7+For Chicago as an example, I need +1+6+4+5 but not +2+8+7+thats where I'm not suceeding in my results.At 02:01 PM 1/23/03 +1100, you wrote:>Maybe it's best to do a quick lookup in the search.>>[Search db=^frugal/sections.db&eqS_RELATEDdata=[LOOKUP>db=^frugal/sections.db&value=[city]&lookInField=S_NAME&returnField=S_RELATED>¬Found=TextIfNotFound]]>[founditems]>[hideif [S_NAME]=[city]][S_Name]
[/hideif]>[/Founditems]>[/Search]>>>Regards,>Tim>-->Tim Robinson>IDFK Web Developments>tim@idfk.com.au>114a/40 Yeo Street>Neutral Bay 2089>Australia>Phone +612 9908 2134>Fax +612 9908 4837>> > From: Lester Emo > > Reply-To: (WebCatalog Talk)> > Date: Wed, 22 Jan 2003 20:52:31 -0600> > To: (WebCatalog Talk)> > Subject: show related items> >> > I have a couple of sites that use lots of the Admin thats inside > storebuilder.> > It just fit the useability of those sites and all is well . . .> >> > I'm trying to use these same storebuilder routines for another site but I> > can't seem to pull the related data that I want from the databases . > . . .> >> > 2 databases uses.> >> > product.db> > sections.db> >> > a typical entry in products.db would have in the [sections] field> > +1+6+4+5+2+8+7+> >> > These numerical entries are for pulling information from the sections.db> > which looks like this:> > S_ID S_TYPE S_NAME S_RANK S_RELATED> > 1 M Chicago 1> > 2 M Milwaukee 1> > 3 M Detroit 1> > 4 Joliet 1 1> > 5 Schaumburg 2 1> > 6 Arlington 3 1> > 7 Racine 1 2> > 8 Kenosha 2 2> >> >> >> > What I want to do is show all items from the Chicago but then list all> > the related cities as well . . .> >> >> > The closest I've come is with this, but its not right.> > It shows ALL related items, even those not relevant.> >> > [Search db=^frugal/sections.db&eqS_RELATEDdata=[city]]> > [founditems]> > [S_Name]
> > [/Founditems]> > [/Search]> >> >> > Is there a better way to pull the city and related cities from a database> > other than what I'm trying to do with storebuilder???> >> >> >> > Again the only reason storebuilder templates were used and pulled apart to> > work was it had all the needed admin areas already there and useable with> > little changes.> >> > does it make sense how I explained it??> >> >> > thanks.> >> >> > hey, that thread on security in a strorefront and switching to asp etc.> > I;m sure Bob Minor and his NFL teams could offer a rebuttal on webdna> > working well and being secure to function well in e-commerce.> >> >> >> >> > -------------------------------------------------------------> > 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/ Lester Emo

DOWNLOAD WEBDNA NOW!

Re: show related items

2003

Top Articles:

Related Readings: