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 inthat field use the standard MM/DD/YYYY format. When I search usingthe 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/199711/10/199712/01/199712/01/1997Clearly, the first two dates do NOT belong in this group. And what'seven stranger is that there's another record in the database with acreateDate 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 adate 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 GromeWebDNA Solutionshttp://www.smithmicro.com/webdnasolutions/...
Associated Messages, from the most recent to the oldest:
I have a database with a createDate field in it. All the dates inthat field use the standard MM/DD/YYYY format. When I search usingthe 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/199711/10/199712/01/199712/01/1997Clearly, the first two dates do NOT belong in this group. And what'seven stranger is that there's another record in the database with acreateDate 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 adate 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 GromeWebDNA Solutionshttp://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)