Re: related data

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 47165
interpreted = N
texte = Can you show more fields that are in the products.db? And on your search ofthis 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 cityand> not all the cities for a product>> My search when accessing a page is> [Search>db=^frugal/products.db&eqVisibleDatarq=T&woSECTIONSdatarq=[city]&SECTIONSword=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¬Found=][/Text]> [Text]maincat=[lookup>db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_TYPE¬Found=][/Text]> [Text]curr=[lookup>db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_RELATED&notFound=][/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/ Associated Messages, from the most recent to the oldest:

Re: related data (Lester Emo 2003) Re: related data (Gary Krockover 2003) related data (Lester Emo 2003) Re: Related database (John Butler 2000) Related database (…©rßa 2000)

Can you show more fields that are in the products.db? And on your search ofthis 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 cityand> not all the cities for a product>> My search when accessing a page is> [Search>db=^frugal/products.db&eqVisibleDatarq=T&woSECTIONSdatarq=[city]&SECTIONSword=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¬Found=][/Text]> [text]maincat=[lookup>db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_TYPE¬Found=][/Text]> [text]curr=[lookup>db=^frugal/sections.db&value=[curr]&lookInField=S_ID&returnField=S_RELATED&notFound=][/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/ Gary Krockover

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:

WebCat B13 Mac CGI -- Frames question (1997) WebDNA 4.5.1 Now Available (2003) Bug alert! (1997) NT Version on IIS 4.0 (1997) [carts] and databases (1997) Summary search -- speed (1997) Calendar (1997) ShowNext (1997) Security stumper [mildly OT] (2004) FW: ANother SHOWIF problem (1997) [WebDNA] User - Group - permissions (2009) Execute Applescript (1997) Emailed problem (2000) PCS Emailer's role ? (1997) Newbie Tax Question (1997) Searchable WebCat (etc.) Docs ? (1997) [OT] Java Servlet Q (2002) Further tests with the infamous shipCost (1997) [isfile] ? (1997) Speed Optimization - Mac (1997)