Re: need some help with a loop

This WebDNA talk-list message is from

1999

It keeps the original formatting. numero = 23097
interpreted = N
texte = >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.This is called a nested search. You can see an example using 2 databasesin your online docs athttp://www.smithmicro.com/WebDNAReference/SearchMultipleDatabases.htmlIn your case, you're searching a single database, but the idea is the same.There is no looping or counting necessary, because the [founditems] do thatfor you:[searchdb=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsumm=T&max=1] [foundItems] [location] - [category]
 [searchdb=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&wslocationdata=[location]&airlinesort=1&airlinessdir=as&aircrafttypesort=2] [foundItems] [airline] [aircrafttype] [regn] [MSN] [notes] [/founditems] [/search] [/founditems][/search]The interior search gets its values for [issue], [category], etcetera, fromthe exterior search's [founditems] loop.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: need some help with a loop [nested search?] (Bill Heissenbuttel 1999) Re: need some help with a loop [nested search?] (Christer Olsson 1999) Re: need some help with a loop [nested search?] (Bill Heissenbuttel 1999) Re: need some help with a loop (PCS Technical Support 1999) Re: need some help with a loop (Bill Heissenbuttel 1999) Re: need some help with a loop (Howard Wolosky 1999) need some help with a loop (Bill Heissenbuttel 1999)

>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.This is called a nested search. You can see an example using 2 databasesin your online docs athttp://www.smithmicro.com/WebDNAReference/SearchMultipleDatabases.htmlIn your case, you're searching a single database, but the idea is the same.There is no looping or counting necessary, because the [founditems] do thatfor you:[searchdb=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsumm=T&max=1] [founditems] [location] - [category]
 [searchdb=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&wslocationdata=[location]&airlinesort=1&airlinessdir=as&aircrafttypesort=2] [founditems] [airline] [aircrafttype] [regn] [MSN] [notes] [/founditems] [/search] [/founditems][/search]The interior search gets its values for [issue], [category], etcetera, fromthe exterior search's [founditems] loop.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

attachment (2000) Separate SSL Server (1997) textA (1998) Need WebDNA that crashes server for testing (2000) Test (2003) Chicago based WebCat Hosters (2000) guest book problem (2000) Dummy Credit Card Number for debug? (1997) Pipes instead of tabs (1998) Help name our technology! (1997) template not found error (1998) If search results are blank... (2003) wrong authentication (1998) Getting it as [raw] (2004) PCS Frames (1997) Web Commerce thoughts and needs.. (1996) [WebDNA] WebDNA 7 (2011) Stumpted Again (1997) Mozilla/4. and Browser Info.txt (1997) Email within tmpl ? (1997)