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:

UPS Shipping Calculations (2001) Re:[off] Promotions Co? (1997) Never Mind - Was - Credit Card Processing (2000) searchable list archive (1997) Upgrading old WebCat Database Files (1997) security (1997) multiple search commands (1997) Using Plug-In while running 1.6.1 (1997) WebCatalog Plug-in for Webstar. (1997) error: Too many nested [xxx] contexts (1997) [addlineitems] (1997) Upload Feature - was (Feedback on new features) (2000) IIS4/IIS3 and WebCatalog registry settings (1998) RE: WebDNA-Talk searchable? (1997) Opinion: [input] should be called [output] ... (1997) FORMS: Returning a specific page (1997) WebCat2 several catalogs? (1997) could someone please try this - it's very quick and easy (2000) Referrer field to header field conversion (1997) FYI: virus alert (1996)