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:

FlushDatabase Suggestion (1998) GuestBook example (1997) Frames and WebCat (1997) [shippingtotal] & Formulas.db prob (2003) OT: Weird table rendering w/ WebCat in Explorer (2005) Monthly Help File (1997) Which is Faster (1998) OT-JS why it does not run on Mac (2001) Format Thousands Looks Busted (2000) Error:Too many nested [xxx] contexts (1997) Running 2 two WebCatalog.acgi's (1996) [WebDNA] PayPal IPN - solved (2009) Apache2 connector (2003) hideif [x]=1,2,3.. (2003) can webcat determine an image's pixel dimensions? (2000) WebDNA-Talk Digests (1997) [SearchString] (1998) Summarising on two fields (1998) WebCat b15 Mac plug-in (1997) Search Engine questions ... (2002)