show related items

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47125
interpreted = N
texte = 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.dba 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 2What 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: show related items (Tim Robinson 2003)
  2. Re: show related items (Lester Emo 2003)
  3. Re: show related items (Tim Robinson 2003)
  4. show related items (Lester Emo 2003)
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.dba 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 2What 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/ Lester Emo

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:

all records returned. (1997) RED QUESTION MARK (1999) Can't find templaes (1997) MS Access data conversion (2001) looping table rows (1999) Speed Optimization - Mac (1997) GuestBook example (1997) question: search return in order (1997) Problems with dbcatalog.exe (1997) OT: FTP problems (2003) Formating found categories (1997) [shell]? (2000) Emailer setup (1997) WebDNA 5.1e (2003) Webdna is dead! (2003) [WebDNA] Problem with SendMail - seems succesfull but nothing to recieve (2016) Further tests with the infamous shipCost (1997) emailer (1997) Add sizes from check boxes (2002) ShowNext & Showif together (1999)