Re: oddball sorting problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55057
interpreted = N
texte = Thanks Brian. Yes, that was one thought. Then I wouldn't need the allhit=1 any more either. What I decided though, is to have the trigger find records with past dates and if a date 2 exists, make date1=date2 then delete date2. If no date2, then delete the whole record, since I'll be searching on past date1 anyway to peel them off the database. Terry At 2:00 AM -0800 12/19/03, WebDNA Talk wrote: >Alternatively, you could add a "sort date" field to the original DB >and run a nightly trigger that puts the chosen value into that field >and clears that field if the sale was in the past. This would >simplify the search and sort to: > >[search ...gesortDatedatarq=[date]&allhit=1&sortDatesort=1&sortDatetype=date] ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: oddball sorting problem ( Terry Wilson 2003)
  2. Re: oddball sorting problem [feature request] ( Donovan Brooke 2003)
  3. Re: oddball sorting problem ( Brian Fries 2003)
  4. Re: oddball sorting problem ( Terry Wilson 2003)
  5. Re: oddball sorting problem ( Donovan Brooke 2003)
  6. oddball sorting problem -- almost okay now ( Terry Wilson 2003)
  7. Re: oddball sorting problem ( Tim Robinson 2003)
  8. Re: oddball sorting problem ( "WebDna @" 2003)
  9. oddball sorting problem ( Terry Wilson 2003)
Thanks Brian. Yes, that was one thought. Then I wouldn't need the allhit=1 any more either. What I decided though, is to have the trigger find records with past dates and if a date 2 exists, make date1=date2 then delete date2. If no date2, then delete the whole record, since I'll be searching on past date1 anyway to peel them off the database. Terry At 2:00 AM -0800 12/19/03, WebDNA Talk wrote: >Alternatively, you could add a "sort date" field to the original DB >and run a nightly trigger that puts the chosen value into that field >and clears that field if the sale was in the past. This would >simplify the search and sort to: > >[search ...gesortDatedatarq=[date]&allhit=1&sortDatesort=1&sortDatetype=date] ------------------------------------------------------------- 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://webdna.smithmicro.com/ 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:

Ooops-Serial Number for NT (1997) GuestBook example (1997) FORMS: Returning a specific page (1997) Updated DRC Labs (2004) Help with Repost Data msg from form (1997) interactive .pdf files and WebCatalog (2000) Re:2nd WebCatalog2 Feature Request (1996) WebSite and *NO* Authentication Dialog Box!!? (1998) Username for Admin Group (1997) Execute Applescript (1997) WebCat2b15MacPlugin - showing [math] (1997) wrong input values? (1997) Re:Running 2 two WebCatalog.acgi's (1996) Rollovers (1999) Problems getting parameters passed into email. (1997) WCS Newbie question (1997) Simple way to create unique SKU (1997) did I miss anything (1997) encryption in browser? (1998) WebCat2.0 [format thousands .0f] no go (1997)