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:
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)