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:

Dismissing dialogs (was 2.1b3 --> way slow) (1997) Bug or syntax error on my part? (1997) Pithy questions on webcommerce & siteedit (1997) [WriteFile] problems (1997) RE: Nesting [ListFiles] (1998) [WebDNA] 2nd pair of eyes on redirect please (2011) WebCat2.0 [format thousands .0f] no go (1997) RE: (OFF TOPIC) System 8.5.1 FINDER ERROR (1999) New 4.5 installer (2002) Problems with SELECT MULTIPLE (1999) Multiple prices (1997) Browser Problem?!? NN 4.0+ and Browser Info.txt? (1997) WebCat2b15MacPlugin - showing [math] (1997) [WebDNA] Forum Module Made In WebDNA (2020) A question on sub-categories (1997) How To get Some Help (2003) Next X hits (1996) Another form question (2000) WebCat editing, SiteGuard & SiteEdit (1997) RE: Cart Template (1997)