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.TerryAt 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:
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.TerryAt 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:
OT: test (1998)
SKU lookup (1997)
Format of Required fields error message (1997)
[format] (1998)
Hiding HTML and breaking the page (1997)
Databases inside [SHOWIF] (1998)
CommandSecurity? (1997)
Search design (1997)
Duplicate Cart Problem in Netscape (2000)
UPDATE PROBLEM (1997)
RE: Questions To Answer (1997)
Showif probably dumb question (1997)
Emailer update for Mac? (1998)
Nested search (1997)
Date and Comparisons (2002)
emailer (1997)
Silly Question (1997)
help with duplicate records posted (1998)
HELP! Search finding too much! (1998)
HTML Email and Images (2004)