Re: related data
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47166
interpreted = N
texte = The other fields really aren't relevant to this issue.The [sections] field contains the main section and subsections within it. You are correct . . . in the case of +1+6 +1 is the city (chicago) and +6 is a suburb (arlington)I need to just show the main city and its suburbs I can't seem to separate them from the others that may be in [sections] as wellI'm using storebuilder admin templates for all of this. It stores all section data in the sections.db as I've shown below At 10:41 PM 1/23/03 -0600, you wrote: >Can you show more fields that are in the products.db? And on your search of >this database, it looks like [city] would contain something like +1+6, >correct? > >GK > > > > > I think I did a poor job of explaining this last night. > > > > 2 databases in use > > > > product.db > > > > a typical entry in products.db would have in a [sections] field >+1+6+2+8+ > > > > > > > > sections.db > > > > 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 > > > > > > I need to only show +1+6 when the Chicago page is accessed > > and only show +2+8 when the Milwaukee page is accessed. > > Items in the products.db will have multiple main city and suburban > > locations and I only want to show corresponding cities with a main city >and > > not all the cities for a product > > > > My search when accessing a page is > > [Search > > >db=^frugal/products.db&eqVisibleDatarq=T&woSECTIONSdatarq=[city]&SECTIONSwor >d=ww&namewbrk=+] > > > > > > I've tried the following in the [sections] field on the final page and its > > close but not quite there. I can't seem to stop Milwaukee from showing in > > Chicago and vice versa . . . > > > > [ListWords Words=[sections]&delimiters=+] > > [Text]city=[/Text] > > [Text]curr=[word][/Text] > > [loop start=1&end=10&advance=1] > > [Text]t=[lookup > > >db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_NAME¬F >ound=][/Text] > > [Text]maincat=[lookup > > >db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_TYPE¬F >ound=][/Text] > > [Text]curr=[lookup > > >db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_RELATED&n >otFound=][/Text] > > [Showif [t]!] > > [Text]city=[Showif [maincat]=M]
[/showif][t][Showif > > [maincat]=M][/showif] [Showif [city]!][city][/Showif][/Text] > > [/Showif] > > [/loop] > > [city]
> > [/Listwords] > > > > > > How would I separate these entries from the [section] field and show them > > in my [founditems]?? > > > > I seem to be close but I'm missing something it seems. > > > > thanks again > > >------------------------------------------------------------- >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:
The other fields really aren't relevant to this issue.The [sections] field contains the main section and subsections within it. You are correct . . . in the case of +1+6 +1 is the city (chicago) and +6 is a suburb (arlington)I need to just show the main city and its suburbs I can't seem to separate them from the others that may be in [sections] as wellI'm using storebuilder admin templates for all of this. It stores all section data in the sections.db as I've shown below At 10:41 PM 1/23/03 -0600, you wrote: >Can you show more fields that are in the products.db? And on your search of >this database, it looks like [city] would contain something like +1+6, >correct? > >GK > > > > > I think I did a poor job of explaining this last night. > > > > 2 databases in use > > > > product.db > > > > a typical entry in products.db would have in a [sections] field >+1+6+2+8+ > > > > > > > > sections.db > > > > 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 > > > > > > I need to only show +1+6 when the Chicago page is accessed > > and only show +2+8 when the Milwaukee page is accessed. > > Items in the products.db will have multiple main city and suburban > > locations and I only want to show corresponding cities with a main city >and > > not all the cities for a product > > > > My search when accessing a page is > > [Search > > >db=^frugal/products.db&eqVisibleDatarq=T&woSECTIONSdatarq=[city]&SECTIONSwor >d=ww&namewbrk=+] > > > > > > I've tried the following in the [sections] field on the final page and its > > close but not quite there. I can't seem to stop Milwaukee from showing in > > Chicago and vice versa . . . > > > > [ListWords Words=[sections]&delimiters=+] > > [text]city=[/Text] > > [text]curr=[word][/Text] > > [loop start=1&end=10&advance=1] > > [text]t=[lookup > > >db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_NAME¬F >ound=][/Text] > > [text]maincat=[lookup > > >db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_TYPE¬F >ound=][/Text] > > [text]curr=[lookup > > >db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_RELATED&n >otFound=][/Text] > > [Showif [t]!] > > [text]city=[Showif [maincat]=M][/showif][t][Showif > > [maincat]=M][/showif] [Showif [city]!][city][/Showif][/Text] > > [/Showif] > > [/loop] > > [city]
> > [/Listwords] > > > > > > How would I separate these entries from the [section] field and show them > > in my [founditems]?? > > > > I seem to be close but I'm missing something it seems. > > > > thanks again > > >------------------------------------------------------------- >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!
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:
HELP!! problems with e-mail from WebCAT (1998)
syntax question, not in online refernce (1997)
CreateDate and ModDate issues (2004)
groupfields .. again... (2000)
RE: Template not found error messages (1997)
WebCat2.0 acgi vs plugin (1997)
Re:no [search] with NT (1997)
URL encoding -- still a problem (1998)
$Replace with [founditems] (1997)
sendmail tag when with in comment tags. (2000)
Another issue with [Date format] (1998)
X etc.... (1999)
Date sorting (1997)
Add htmlarea 3 to SiteBuilder (2004)
Separate SSL Server (1997)
Where is eudora plugin? (1998)
5.0 Pricing (2003)
[WebDNA] Snippets: EXPORT RECORDS using WRITEFILE (2009)
Virtual hosting and webcatNT (1997)
Separate SSL Server (1997)