Re: need some help with a loop

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23092
interpreted = N
texte = That works, but I need the heading location to show up between the data types.ie-USA ----------------- <---- heading USA data, USA data, USA data <---- dataCANADA -------------- <---- heading CANADA data, CANADA data, CANADA data <---- dataEUROPE ______________ <---- heading EUROPE data, EUROPE data, EUROPE data <---- dataetc...This is why I am assuming that I need to do the first search, loop, do the second search, loop, do the third search, (ad naseum)BillAt 4:02 PM 1/29/99, Howard Wolosky wrote:>I think you're making this harder than it needs to be (unless I've >misunderstood what you're trying to do) >Why not just do this? > >[search >db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsort=1 >&airlinesort=2&airlinessdir=as&aircrafttypesort=3][foundItems] >[airline] >[aircrafttype] >[regn] >[MSN] >[notes] >[/founditems][/search] > > >This will show all 150 (or whatever it is) results categorized first by >location, then airline, then aircraft. > > > >At 10:34 AM 1/29/99 -0800, you wrote: >>Hiya folks, >> >>I've come to a programming point where I think I need a loop, but really >>don't know how to go about it. Hopefully someone else has some info. >> >>I need to return data based on a location, of which there are 8 (USA, >>CANADA, THE AMERICAS, EUROPE, AFRICA, EAST ASIA, WEST ASIA, OCEANIA). These >>are Summarized from a list of about 150 entries. >> >>Currently, when it searches, it finds all the locations (and runs them all >>together) and all the returned data (and runs it all together). >> >>What I'd like to do is search, find one location and it's data, loop, find >>the next location and data, loop, etc, etc. >> >>To find the location, it does this >>--------------------------------------- >>[search >>db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsumm=T >>&max=1] >>[foundItems][location] - [category][/founditems][/search] >> >> >>To display the data, it does this >>--------------------------------------- >>[search >>db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&wslocationdata >>=[location]&airlinesort=1&airlinessdir=as&aircrafttypesort=2][foundItems] >>[airline] >>[aircrafttype] >>[regn] >>[MSN] >>[notes] >>[/founditems][/search] >> >>I'm assuming that I need to have it count the summarized locations and then >>[break] after I get to the end. >> >>Something like >> >>[loop start=1&end=[??????????????]&advance=1] >> >>index=[index] <----?????? >> >>location search >>--- >>datasearch >> >>[showif [index]=?????????][break][/showif] >>[/loop] >> >> >>Any ideas? >> >> >>Bill >>-- >>Bill Heissenbuttel (bill@pagehouse.com) - http://www.pagehouseinc.com >>PageHouse, Inc. - Internet Presence Provider (509) 892-1973 >>- >>PGP key ID: 0xE8544665 (http://pgpkeys.mit.edu:11371) >> > > > >Howard Wolosky >============ > >Lead Programmer / Webmaster > www.willitwork.com >Will It Work presented by Lab 2K > -The World's Largest Year 2000 > Compliance Search Engine-- Bill Heissenbuttel (bill@pagehouse.com) - http://www.pagehouseinc.com PageHouse, Inc. - Internet Presence Provider (509) 892-1973 - PGP key ID: 0xE8544665 (http://pgpkeys.mit.edu:11371) Associated Messages, from the most recent to the oldest:

    
  1. Re: need some help with a loop [nested search?] (Bill Heissenbuttel 1999)
  2. Re: need some help with a loop [nested search?] (Christer Olsson 1999)
  3. Re: need some help with a loop [nested search?] (Bill Heissenbuttel 1999)
  4. Re: need some help with a loop (PCS Technical Support 1999)
  5. Re: need some help with a loop (Bill Heissenbuttel 1999)
  6. Re: need some help with a loop (Howard Wolosky 1999)
  7. need some help with a loop (Bill Heissenbuttel 1999)
That works, but I need the heading location to show up between the data types.ie-USA ----------------- <---- heading USA data, USA data, USA data <---- dataCANADA -------------- <---- heading CANADA data, CANADA data, CANADA data <---- dataEUROPE ______________ <---- heading EUROPE data, EUROPE data, EUROPE data <---- dataetc...This is why I am assuming that I need to do the first search, loop, do the second search, loop, do the third search, (ad naseum)BillAt 4:02 PM 1/29/99, Howard Wolosky wrote:>I think you're making this harder than it needs to be (unless I've >misunderstood what you're trying to do) >Why not just do this? > >[search >db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsort=1 >&airlinesort=2&airlinessdir=as&aircrafttypesort=3][founditems] >[airline] >[aircrafttype] >[regn] >[MSN] >[notes] >[/founditems][/search] > > >This will show all 150 (or whatever it is) results categorized first by >location, then airline, then aircraft. > > > >At 10:34 AM 1/29/99 -0800, you wrote: >>Hiya folks, >> >>I've come to a programming point where I think I need a loop, but really >>don't know how to go about it. Hopefully someone else has some info. >> >>I need to return data based on a location, of which there are 8 (USA, >>CANADA, THE AMERICAS, EUROPE, AFRICA, EAST ASIA, WEST ASIA, OCEANIA). These >>are Summarized from a list of about 150 entries. >> >>Currently, when it searches, it finds all the locations (and runs them all >>together) and all the returned data (and runs it all together). >> >>What I'd like to do is search, find one location and it's data, loop, find >>the next location and data, loop, etc, etc. >> >>To find the location, it does this >>--------------------------------------- >>[search >>db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsumm=T >>&max=1] >>[founditems][location] - [category][/founditems][/search] >> >> >>To display the data, it does this >>--------------------------------------- >>[search >>db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&wslocationdata >>=[location]&airlinesort=1&airlinessdir=as&aircrafttypesort=2][founditems] >>[airline] >>[aircrafttype] >>[regn] >>[MSN] >>[notes] >>[/founditems][/search] >> >>I'm assuming that I need to have it count the summarized locations and then >>[break] after I get to the end. >> >>Something like >> >>[loop start=1&end=[??????????????]&advance=1] >> >>index=[index] <----?????? >> >>location search >>--- >>datasearch >> >>[showif [index]=?????????][break][/showif] >>[/loop] >> >> >>Any ideas? >> >> >>Bill >>-- >>Bill Heissenbuttel (bill@pagehouse.com) - http://www.pagehouseinc.com >>PageHouse, Inc. - Internet Presence Provider (509) 892-1973 >>- >>PGP key ID: 0xE8544665 (http://pgpkeys.mit.edu:11371) >> > > > >Howard Wolosky >============ > >Lead Programmer / Webmaster > www.willitwork.com >Will It Work presented by Lab 2K > -The World's Largest Year 2000 > Compliance Search Engine-- Bill Heissenbuttel (bill@pagehouse.com) - http://www.pagehouseinc.com PageHouse, Inc. - Internet Presence Provider (509) 892-1973 - PGP key ID: 0xE8544665 (http://pgpkeys.mit.edu:11371) Bill Heissenbuttel

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:

Re:2nd WebCatalog2 Feature Request (1996) A question on sub-categories (1997) Credit card issuer by cc number? (1999) Another bug to squash (WebCat2b13 Mac .acgi) (1997) WebCatalog NT beta 18 problem (1997) Sorry But This seems to be my fate (2000) WebCat for Unix?? (1997) [WebDNA] Local Development On Windows 8.1 (2015) Stinkin' [Referrer] (1998) Quickie question on the email templates (1997) Date problems (1997) Authenticate (1997) update problem (1998) WebCat2 several catalogs? (1997) [HIDEIF] inside [FOUNDITEM] (1997) Quick ShowIf question (1997) format_to_days on NT (1997) Test (2003) [listfiles] (2004) IIS4b2 and WebCatalog b19 (1997)