> 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]

Reply via email to