Re: show related items
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47130
interpreted = N
texte = It's a bit confusing! Which field in the sections.db is supposed to pertain to the [sections] field in the products.db? > From: Lester Emo
> Reply-To: (WebCatalog Talk) > Date: Wed, 22 Jan 2003 21:31:09 -0600 > To: (WebCatalog Talk) > Subject: Re: show related items > > 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/ > ------------------------------------------------------------- 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:
It's a bit confusing! Which field in the sections.db is supposed to pertain to the [sections] field in the products.db? > From: Lester Emo > Reply-To: (WebCatalog Talk) > Date: Wed, 22 Jan 2003 21:31:09 -0600 > To: (WebCatalog Talk) > Subject: Re: show related items > > 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/ > ------------------------------------------------------------- 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/
Tim Robinson
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:
Range in [showif] (2000)
SiteEdit Pro Update Announcement (1997)
WC 2.0 frames feature (1997)
Where is Orders.db appended? (2000)
New public beta available (1997)
Global replace (2000)
SKU (1997)
Protecting Files (how to display vs. present a link to (2005)
[WebDNA] WebSite Examples (2008)
ShowNext for method=POST (1997)
Db design question (relational vs. flat?) (1998)
[WebDNA] Error 500 with SUMM=T (2017)
Exclude by date - multiple (1997)
billing system (2003)
Secure server question (1997)
(2000)
Help! WebCat2 bug (1997)
Emailer (1997)
[WebDNA] why is this cookie being set to expire at end of browser (2009)
Date problems-more (1997)