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:

GuestBook example (1997) simple answer? [hideif] (1997) Authorize.Net down 2 days in row (2004) [WebDNA] sem_open bugfix for os x version 6.2 (2012) How to Display text in empty fields (1997) PIXO Support (1997) truncating email part II (1997) Using Plug-In while running 1.6.1 (1997) Nested vs conditional (1997) Google Web Accelerator (2005) WebDNA Solutions ... sorry! (1997) Appending current [date] to a database (1997) [WebDNA] passing a variable in an include - precedence (2017) Re:Running 2 two WebCatalog.acgi's (1996) Shopping with Accounts (2003) WebCat b15 Mac plug-in (1997) Dynamic Generation of PDFs? (2003) Great product and great job ! (1997) Textarea (1998) flushdatabases (1997)