related data

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47157
interpreted = N
texte = I think I did a poor job of explaining this last night.2 databases in useproduct.dba typical entry in products.db would have in a [sections] field +1+6+2+8+sections.dbThese 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 productMy 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¬Found=][/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:

    
  1. Re: related data (Lester Emo 2003)
  2. Re: related data (Gary Krockover 2003)
  3. related data (Lester Emo 2003)
  4. Re: Related database (John Butler 2000)
  5. Related database (…©rßa 2000)
I think I did a poor job of explaining this last night.2 databases in useproduct.dba typical entry in products.db would have in a [sections] field +1+6+2+8+sections.dbThese 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 productMy 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¬Found=][/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/ 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:

Sorting by date (1997) Changing names of .hdr field names (2003) limiting found items (2001) Re:Emailer and encryption (1997) Strange Search Results (2004) Can't Update records (1997) username = 115 (1999) For those of you not on the WebCatalog Beta... (1997) FYI-WebCat Mac or NT (1997) WebCat2b15MacPlugin - [protect] (1997) absolute paths for databases? (1997) Web Logs (1998) WebCommerce: Folder organization ? (1997) Req: Array Tags Explained, simple and clear (2003) no global [username] or [password] displayed ... (1997) WC1.6 to WC2 date formatting -FIXED! (1997) Possible Bug in 2.0b15.acgi (1997) Speed questions (1998) Occasional crashes with $remove (1997) wild question (1998)