Re: multi-table date sort problem thingy

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45401
interpreted = N
texte = Patrick, your results are because you are first searching for matches and then for the dates.You can't display the matches of events by nearest date because you haven't yet found the the date. (I guess I don't understand why you have the dates separate from the event.db. If you did your sort would work)Since you are searching another database for times you will have to do your formating after all the times are found.make sense?DonovanPatrickJ wrote:[snip]> > > [search db=ThePhil.db&[formvariables name=_&exact=F][getchars > start=2][name][/getchars]=[url][value][/url]&[/formvariables]wseventtype2data=[_wsEventType1data]&startat=[startat]]> > [snip] > [search > db=performances/performances.db&eqeventskudatarq=[sku]&perfdatetype=date&asperfdatesort=1] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: multi-table date sort problem thingy (Donovan Brooke 2002)
  2. Re: multi-table date sort problem thingy (Donovan Brooke 2002)
  3. Re: multi-table date sort problem thingy (PatrickJ 2002)
  4. Re: multi-table date sort problem thingy (Gary Krockover 2002)
  5. Re: multi-table date sort problem thingy (PatrickJ 2002)
  6. Re: multi-table date sort problem thingy (Donovan Brooke 2002)
  7. multi-table date sort problem thingy (PatrickJ 2002)
Patrick, your results are because you are first searching for matches and then for the dates.You can't display the matches of events by nearest date because you haven't yet found the the date. (I guess I don't understand why you have the dates separate from the event.db. If you did your sort would work)Since you are searching another database for times you will have to do your formating after all the times are found.make sense?DonovanPatrickJ wrote:[snip]> > > [search db=ThePhil.db&[formvariables name=_&exact=F][getchars > start=2][name][/getchars]=[url][value][/url]&[/formvariables]wseventtype2data=[_wsEventType1data]&startat=[startat]]> > [snip] > [search > db=performances/performances.db&eqeventskudatarq=[sku]&perfdatetype=date&asperfdatesort=1] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Donovan Brooke

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:

Help! WebCat2 bug (1997) no global [username] or [password] displayed ... (1997) ListFiles Sorting (2000) Using [Showif] tag. Mac (1997) WebCat2 Append problem (B14Macacgi) (1997) Version f1 status (1997) WebCat2 several catalogs? (1997) Navigator 4.01 (1997) Duplicate Hell (1999) RedHat 9 & WebCatalog 4.5 (2004) [WebDNA] Yosemite (2014) Need help with emailer- 2 issues (1997) [WebDNA] listcookies v Windows 7 (2011) Banner DNA (1997) WC1.6 to WC2 date formatting (1997) still having shipCost.db Problem (1997) Coding Technique (2000) How do I get Google to crawl a WebCat site? (2003) Mac webcatalog3_0_5b11 more dead lock throws (1999) WebCat2b12 - nesting [tags] (1997)