RE: Date? What Date?
One question: is there any reason why you can't change the date format? Have you tested it if it is in ODBC date format? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 2:09 PM To: JRun-Talk Subject: RE: Date? What Date? > I have done that to resolve the problem already, however I'm > curious as to why this is happening, incase it's a problem > elsewhere in our app, where the results are not quite so > obvious I suspect it has to do with the database drivers you're using. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
> I have done that to resolve the problem already, however I'm > curious as to why this is happening, incase it's a problem > elsewhere in our app, where the results are not quite so > obvious I suspect it has to do with the database drivers you're using. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Date? What Date?
- Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> > I suspect you'd have better luck with this sort of question on the CF-Talk > list, actually. Thanks, I'll have to try it there.. > You might have better luck if you use the to_date function with dates in > Oracle: I have done that to resolve the problem already, however I'm curious as to why this is happening, incase it's a problem elsewhere in our app, where the results are not quite so obvious [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
> I know this may be a little less JRUN related, however it's > seemingly the only un-common denominator, between two > different instances, which are behaving differently. > > Basically I have a CFM, running inside an application, on a > JRUN 4 application server, hitting an Oracle database. I suspect you'd have better luck with this sort of question on the CF-Talk list, actually. > The CFM has a cfquery in it, which has one parameter. > > The query is running, and returning a row, which the criteria > of the query should be eliminating. > > ... > > The portion of the query i have narrowed it down to, is the line > > " or somedate >= '26-Jun-2004' " You might have better luck if you use the to_date function with dates in Oracle: http://www.techonthenet.com/oracle/functions/to_date.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
That's my point, that row, should not be returned, but it is. It's in a three-part OR in the where clause. If I remove that particular line, then the record will not appear. Regardless of the fact that Jan 1st 2001, is prior to June 26th 2004, the record is being returned in response to " date >= '26-Jun-2004'" -Original Message- From: Drew Falkman [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:08 PM To: JRun-Talk Subject: RE: Date? What Date? To start, if the record is Jan 1, 2001 it will not comply with your logic (that the date is after or on June 26, 2004)... -Original Message- From: Jon Austin [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:00 AM To: JRun-Talk Subject: Date? What Date? I know this may be a little less JRUN related, however it's seemingly the only un-common denominator, between two different instances, which are behaving differently. Basically I have a CFM, running inside an application, on a JRUN 4 application server, hitting an Oracle database. The CFM has a cfquery in it, which has one parameter. The query is running, and returning a row, which the criteria of the query should be eliminating. I have run this query in numerous places, from numerous clients, and cannot replicate the behavior experienced on the cold-fusion server. To add an element to this, I have a local JRUN 4 server, same patch-level, which runs correctly, and does not return the additional row. The portion of the query i have narrowed it down to, is the line " or somedate >= '26-Jun-2004' " (The record's date is Jan 1st 2001).. I've checked server settings, date formats, etc etc.. and have come up blank.. Both my local server, and the App server should be running the same versions of pretty much everything, yet the debug output, shows exactly the same query.. on exactly the same database, returning a recordcount=1 on my local server, and 2 on the application server. Has anyone run into this? ~ Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
To start, if the record is Jan 1, 2001 it will not comply with your logic (that the date is after or on June 26, 2004)... -Original Message- From: Jon Austin [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:00 AM To: JRun-Talk Subject: Date? What Date? I know this may be a little less JRUN related, however it's seemingly the only un-common denominator, between two different instances, which are behaving differently. Basically I have a CFM, running inside an application, on a JRUN 4 application server, hitting an Oracle database. The CFM has a cfquery in it, which has one parameter. The query is running, and returning a row, which the criteria of the query should be eliminating. I have run this query in numerous places, from numerous clients, and cannot replicate the behavior experienced on the cold-fusion server. To add an element to this, I have a local JRUN 4 server, same patch-level, which runs correctly, and does not return the additional row. The portion of the query i have narrowed it down to, is the line " or somedate >= '26-Jun-2004' " (The record's date is Jan 1st 2001).. I've checked server settings, date formats, etc etc.. and have come up blank.. Both my local server, and the App server should be running the same versions of pretty much everything, yet the debug output, shows exactly the same query.. on exactly the same database, returning a recordcount=1 on my local server, and 2 on the application server. Has anyone run into this? ~ Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Date? What Date?
I know this may be a little less JRUN related, however it's seemingly the only un-common denominator, between two different instances, which are behaving differently. Basically I have a CFM, running inside an application, on a JRUN 4 application server, hitting an Oracle database. The CFM has a cfquery in it, which has one parameter. The query is running, and returning a row, which the criteria of the query should be eliminating. I have run this query in numerous places, from numerous clients, and cannot replicate the behavior experienced on the cold-fusion server. To add an element to this, I have a local JRUN 4 server, same patch-level, which runs correctly, and does not return the additional row. The portion of the query i have narrowed it down to, is the line " or somedate >= '26-Jun-2004' " (The record's date is Jan 1st 2001).. I've checked server settings, date formats, etc etc.. and have come up blank.. Both my local server, and the App server should be running the same versions of pretty much everything, yet the debug output, shows exactly the same query.. on exactly the same database, returning a recordcount=1 on my local server, and 2 on the application server. Has anyone run into this? ~ Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]