Sorting Dates in a search

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29738
interpreted = N
texte = Has anyone dealt with a search that must find line data based on a range of dates? I'm able to pass the start and end dates but the search ignores the end date and only works with a start date. The result is a find that list all the dates from the start date which does not sort them. I placed a form variables tags to see if the search criteria was passed to the page so why isn't the date range search in the following code? The sort based on the Receipt date field works only on the Month. I tried placing %m%d%y tags in the string but I need some pointers here.[search db=product.db&rnReceipt_datedatarq=[StartDate]+[EndDate]&asReceipt_Datesort= 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting Dates in a search (Nico 2000)
  2. Sorting Dates in a search (Eric Palhof 2000)
Has anyone dealt with a search that must find line data based on a range of dates? I'm able to pass the start and end dates but the search ignores the end date and only works with a start date. The result is a find that list all the dates from the start date which does not sort them. I placed a form variables tags to see if the search criteria was passed to the page so why isn't the date range search in the following code? The sort based on the Receipt date field works only on the Month. I tried placing %m%d%y tags in the string but I need some pointers here.[search db=product.db&rnReceipt_datedatarq=[StartDate]+[EndDate]&asReceipt_Datesort= 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 Eric Palhof

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:

emailer (1997) Include from DB (2002) Tax Collection for Different Items (2003) Admin Edit prob. (1997) webCatalog and Stocks (1998) [WebDNA] Two different mail servers? (2011) Search/sort in URL Was: GuestBook example (1997) CommandSecurity? (1997) WebSTAR and WebSTAR/SSL with WebCatalog plugins (1998) Where's Cart Created ? (1997) Multiple security dbs (1997) Emailer setup (1997) Paranoid about serial numbers...not (1998) BUG: SiteBuilder -FAQ and?? (2005) Link with [cart] in db field (1999) PCS Frames (1997) Protect and Serve (1999) RE: upload pictures any solution (1999) SiteGuard Admin Feature ? (1997) passing info to thankyou.tpl (1998)