Re: show related items
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47126
interpreted = N
texte = Maybe it's best to do a quick lookup in the search.[Search db=^frugal/sections.db&eqS_RELATEDdata=[LOOKUPdb=^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 RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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/
Associated Messages, from the most recent to the oldest:
Maybe it's best to do a quick lookup in the search.[Search db=^frugal/sections.db&eqS_RELATEDdata=[LOOKUPdb=^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 RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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/
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:
no [search] with NT (1997)
Banner Ads (2000)
WebCat2.0b15-to many nested [xx] tags (1997)
A Current Feature or Futre Concept (1998)
F3 crashing server (1997)
WC2b15 File Corruption (1997)
2.0 Beta (1997)
redirect with frames (1997)
[WebDNA] WebDNA glitch, no response required ... (2009)
[browsername] not working? (1997)
Setting up shop (1997)
Overridding E-Mailer (1998)
encryption in browser? (1998)
Sku numbers (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
Format all of a sudden doesn't work (1997)
textarea input truncated at 255 chars (1999)
Authorize.net setup (2002)
Stumped on ShowNext -using variables (1997)
More on the email templates (1997)