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 databases in your online docs at http://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 that for you:[search db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsumm=T&max =1] [foundItems] [location] - [category]
[search db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&wslocationdata=[lo cation]&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, from the 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 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ 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)
>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 databases in your online docs at http://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 that for you:[search db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&locationsumm=T&max =1] [founditems] [location] - [category]
[search db=fleet.db&wsissuedatarq=[issue]&wscategorydatarq=[category]&wslocationdata=[lo cation]&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, from the 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 | Typhoon 619/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:

A little help on e-mail (HELP!!! :-) ) (1998) Country & Ship-to address & other fields ? (1997) no global [username] or [password] displayed ... (1997) [searchString] (1997) change the number format (1997) Shopping Cart Page (1997) New public beta available (1997) WebDNA permissions? (2002) Bug Report, maybe (1997) [append] and SSL (1997) FoundItems Question (1998) IRC Channel (2003) Help name our technology! (1997) Using tags to create a file name (2000) Date Formats (1997) Mac 2.1b4 unknown error: BadSuffix (1997) Multiple Ad databases? (1997) Re2: Calculating multiple shipping... (1997) Enhanced Master Counter? (1997) [SQL] context OT question (2002)