Date search bug

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15337
interpreted = N
texte = I have a database with a createDate field in it. All the dates in that field use the standard MM/DD/YYYY format. When I search using the following parameters:&createDateType=date &rncreateDatedatarq=[dateRange]and when the [dateRange] value is:11/15/1997 12/15/1997WebCat retrieves 4 records with the following create dates:10/25/1997 11/10/1997 12/01/1997 12/01/1997Clearly, the first two dates do NOT belong in this group. And what's even stranger is that there's another record in the database with a createDate of 12/01/1997, but that record is NOT being retrieved, even though it's supposed to be ...It looks like I may have found a bug ... either that, or I'm not supposed to be using 'rn' to search for a date within a certain range of values.I made sure to tell WebCat that the createDate field is a date type, so I 'assumed' that this would make the 'rn' search work properly. Was I wrong about this?Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... Associated Messages, from the most recent to the oldest:

    
  1. Re: Date search bug? (Kenneth Grome 1998)
  2. Re: Date search bug (Kenneth Grome 1998)
  3. Re: Date search bug (Gil Poulsen 1998)
  4. Re: Date search bug (Kenneth Grome 1998)
  5. Re: Date search bug (Gil Poulsen 1998)
  6. Re: Date search bug (John Hill 1998)
  7. Re: Date search bug (Gil Poulsen 1998)
  8. Date search bug (Gil Poulsen 1998)
  9. Re: Date search bug (nelson@fwgi.com 1998)
  10. Re: Date search bug (Kenneth Grome 1997)
  11. Date search bug (Kenneth Grome 1997)
I have a database with a createDate field in it. All the dates in that field use the standard MM/DD/YYYY format. When I search using the following parameters:&createDateType=date &rncreateDatedatarq=[dateRange]and when the [dateRange] value is:11/15/1997 12/15/1997WebCat retrieves 4 records with the following create dates:10/25/1997 11/10/1997 12/01/1997 12/01/1997Clearly, the first two dates do NOT belong in this group. And what's even stranger is that there's another record in the database with a createDate of 12/01/1997, but that record is NOT being retrieved, even though it's supposed to be ...It looks like I may have found a bug ... either that, or I'm not supposed to be using 'rn' to search for a date within a certain range of values.I made sure to tell WebCat that the createDate field is a date type, so I 'assumed' that this would make the 'rn' search work properly. Was I wrong about this?Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... 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:

Search in 2 or more catalogs (1997) About to give up (1998) Problem with order processing (2006) text size limitation (1997) What am I doing wrong? (2000) lookups or math? (1998) Extra equals signs with IE? (More debugging questions...) (1997) WC TableGrinder (1997) Blog/social networking shortcut (2007) OT : Site speed feedback (2002) emailer and other smtp (1998) Paths, relative paths, webstar server setup and security (Mac) (1997) HELP WITH DATES (1997) Another question (1997) PDF Tools (2006) WebCat2b12 CGI Mac - [shownext] problem (1997) Webmerch tags? (1998) cybercash (1997) Nav. 4 probs with cart - Serious problem (1997) Sorting by date (1997)