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 ----------------- <---- headingUSA data, USA data, USA data <---- dataCANADA -------------- <---- headingCANADA data, CANADA data, CANADA data <---- dataEUROPE ______________ <---- headingEUROPE data, EUROPE data, EUROPE data <---- dataetc...This is why I am assuming that I need to do the first search, loop, do thesecond 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.comPageHouse, 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:
That works, but I need the heading location to show up between the data types.ie-USA ----------------- <---- headingUSA data, USA data, USA data <---- dataCANADA -------------- <---- headingCANADA data, CANADA data, CANADA data <---- dataEUROPE ______________ <---- headingEUROPE data, EUROPE data, EUROPE data <---- dataetc...This is why I am assuming that I need to do the first search, loop, do thesecond 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.comPageHouse, 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)