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:
>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:
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)