Re: Fun with dates

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12287
interpreted = N
texte = >Ok guys, thanks for the advice - since you didn't spot anything obviously >wrong with my code I'll go back in and try your suggestions to simplify and >build the hyperlinks or radio buttons and test that way. > >Can someone tell me if: > is required?Yes, you need that line because you're dealing with dates. Mine works fine with that line.>If it is present in the search page then no records are ever returned, if >removed then all records are returned.Either way, you're not getting the results you should be getting, but I would definitely stick with the hidden field for now because I'm sure you need it.If you get no records returned, it may be because another part of your search is *not* finding any matching records. Make sure you're not ignoring all your records because of another search parameter.Or maybe all the dates you're seeking are out of range of your search range.Also, take a good look at the dates - directly in your database - because if the formatting is different than what you *think* it is, then that would account for the problems you're seeing, too.Sincerely, Ken Grome WebDNA Solutions Associated Messages, from the most recent to the oldest:

    
  1. Re: Fun with Dates (syntax) (Gary Krockover 2002)
  2. Re: Fun with Dates (syntax) (spam 2002)
  3. Re: Fun with Dates (syntax) (Gary Krockover 2002)
  4. Re: Fun with Dates (syntax) (Brian Boegershausen 2002)
  5. Fun with Dates (syntax) (spam 2002)
  6. Re: Fun with Dates - any progress? (Grant Hulbert 1997)
  7. Fun with Dates - any progress? (Marty Schmid 1997)
  8. Fun with Dates - revisited (again) (Marty Schmid 1997)
  9. Re: Fun with Dates - revisited (Kenneth Grome 1997)
  10. Re: Fun with Dates - revisited (Marty Schmid 1997)
  11. Re: Fun with Dates - revisited (Grant Hulbert 1997)
  12. Fun with Dates - revisited (Marty Schmid 1997)
  13. Re: Fun with Dates - finally resolved but.... (Christer Olsson 1997)
  14. Re: Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
  15. Re: Fun with Dates - finally resolved but.... (Kenneth Grome 1997)
  16. Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
  17. Re: Fun with dates (Kenneth Grome 1997)
  18. Re: Fun with dates (Richard Wylie 1997)
  19. Re: Fun with dates (Marty Schmid 1997)
  20. Re: Fun with dates (Kenneth Grome 1997)
  21. Re: Fun with dates (grichter@panavise.com (Gary Richter) 1997)
  22. Re: Fun with dates (Grant Hulbert 1997)
  23. Fun with dates (Marty Schmid 1997)
  24. Fun with dates (Marty Schmid 1997)
>Ok guys, thanks for the advice - since you didn't spot anything obviously >wrong with my code I'll go back in and try your suggestions to simplify and >build the hyperlinks or radio buttons and test that way. > >Can someone tell me if: > is required?Yes, you need that line because you're dealing with dates. Mine works fine with that line.>If it is present in the search page then no records are ever returned, if >removed then all records are returned.Either way, you're not getting the results you should be getting, but I would definitely stick with the hidden field for now because I'm sure you need it.If you get no records returned, it may be because another part of your search is *not* finding any matching records. Make sure you're not ignoring all your records because of another search parameter.Or maybe all the dates you're seeking are out of range of your search range.Also, take a good look at the dates - directly in your database - because if the formatting is different than what you *think* it is, then that would account for the problems you're seeing, too.Sincerely, Ken Grome WebDNA Solutions Kenneth Grome

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:

[WebDNA] How to use attachment with sendmail (2020) Only charge card when product shipped ? (1997) WebCat2: Items xx to xx shown, etc. (1997) Bug or syntax error on my part? (1997) Bug Report, maybe (1997) So many lookers, hey smith micro (2003) [OT] (waaaay OT) (2004) WebCat b13 CGI -shownext- (1997) WebCatalog can't find database (1997) Stopping bad HTML propagation ? (1997) Optimizing [founditems] (2000) SiteCheck & WebCat ? (1997) calculating tax rates, mail order solutions and version 2 (1997) re: [addlineitem] working almost (1997) # fields limited? (1997) [WebDNA] SEARCH question (2011) WebCatalog2 Feature Feedback (1996) Re[2]: Next X hits (1996) WC2b15 File Corruption (1997) [WebDNA] WebDNA and Coda 2 - Get it up and running... (macOS) (2018)