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:

[NT] ie 4.0 required (1997) Tech question about web dna actions (1998) Just Testing (1997) cart info (1998) WebCat Admin access w/ClearlyHome p.i. (1997) Show shoppingcart after remove last item (1997) Storing calculated data (2002) Summing fields (1997) [WebDNA] Another strange WebDNA problem (2013) [OT] (waaaay OT) (2004) Physical Security for WebCatalog Directories (1997) Accounting System and WebCatalog/WebMerchant (2000) WCS Newbie question (1997) Tax & Shipping (1997) ATTN:SMITH MICRO (2001) WCS Newbie question (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) emailer setup (1997) wierd crashes for multi-sendmails on NT (1997) Shipping Tables (1999)