Re: [WebDNA] Searching within a search on the same database

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110730
interpreted = N
texte = No problem to do nested searches on the same DB to create calendars and other lists with subheads. For a calendar, the outer search will summ on the month and display the month, and the interior search will grab the items for each month and display them in date order. You could use showif to do the same thing in a single search though. Set a variable at the end of each founditem (for the month, in the example above), and check to see if the current record's month is different from the variable; if true, you'd display the month. For something with two different sorts, like a personnel DB with department subheads, then names, just use a first, second, etc sort orders. As for server load -- nested searches vs. setting and checking variables on each founditem -- any thoughts on that? Terry > > On Sep 18, 2013, at 2:43 PM, "Francisco A. Hirsch" > wrote: > >> is this a lawful operation? >> [Search db=database.db&etc1] >> [founditems] >> [Search db=database.db&etc2] >> [founditems] >> doingsometing >> [/founditems] >> [/Search] >> [/founditems] >> [/Search] >> >> Regards, >> Francisco >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Searching within a search on the same database (Terry Wilson 2013)
  2. Re: [WebDNA] Searching within a search on the same database (D Brooke 2013)
  3. Re: [WebDNA] Searching within a search on the same database (Stuart Tremain 2013)
  4. Re: [WebDNA] Searching within a search on the same database (Lawrence Banahan 2013)
  5. Re: [WebDNA] Searching within a search on the same database (Lawrence Banahan 2013)
  6. [WebDNA] Searching within a search on the same database ("Francisco A. Hirsch" 2013)
No problem to do nested searches on the same DB to create calendars and other lists with subheads. For a calendar, the outer search will summ on the month and display the month, and the interior search will grab the items for each month and display them in date order. You could use showif to do the same thing in a single search though. Set a variable at the end of each founditem (for the month, in the example above), and check to see if the current record's month is different from the variable; if true, you'd display the month. For something with two different sorts, like a personnel DB with department subheads, then names, just use a first, second, etc sort orders. As for server load -- nested searches vs. setting and checking variables on each founditem -- any thoughts on that? Terry > > On Sep 18, 2013, at 2:43 PM, "Francisco A. Hirsch" > wrote: > >> is this a lawful operation? >> [Search db=database.db&etc1] >> [founditems] >> [Search db=database.db&etc2] >> [founditems] >> doingsometing >> [/founditems] >> [/Search] >> [/founditems] >> [/Search] >> >> Regards, >> Francisco >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Terry Wilson

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:

Setting up WebCatalog with Retail Pro data (1996) www.web-dna.org? (2002) upload to db (2007) update on wn searching (1997) iPLanet (2001) Bug? (1997) Getting Total Quantity (1997) Re:no [search] with NT (1997) WebCat NT v. Mac (1997) [ShowCart]-- was ThankYou page problems (1997) Help! WebCat2 bug (1997) Re:Searching for ALL / empty form field (1997) Latest compatible Apache (2006) Summing fields (1997) Next X hits (1996) WebCat2b12plugin - [search] is broken ... not! (1997) PCS Frames (1997) Running 2 two WebCatalog.acgi's (1996) Still ignoring the 3.x bugs? (2000) WebCommerce: Folder organization ? (1997)