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:

Interfacing WebMerchant to www.fedex.com (1997) Problems with Summary and WEBCAT (1999) RE: NewCart+Search with one click ? (1997) Pass Thru Page? (1998) redirect with frames (1997) Bulletin Board needed (2007) categorys (1998) European Dates (1998) how to construct a search for not this entire string? (2000) Running _every_ page through WebCat ? (1997) automatically updating all records, one by one in a db (2000) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) charging? (2001) ssl/empty cart problem (2003) Permissions Ignored - PLEASE HELP (2003) [WebDNA] jQuery validation and webdna (2015) founditem align (1998) Protect (1997) WebCat2b15MacPlugin - showing [math] (1997) [Semi-OT] Eaaaaaasy OSX FTP (2003)