We are using the thin client. I remember I had the same problem with this, but it was a code issue. Here is the code that I have that pulls both date and time from a date time field...
I am not doing anything special in the query. Io4c_date is a date field that is coming from the query... #ucase(left(dateformat(io4c_date,"DDD"), 2))# #timeformat(io4c_date, 'h:mmt')# Eric /*-----Original Message----- /*From: Maureen Barger [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, October 07, 2008 4:49 AM /*To: cf-talk /*Subject: Re: ColdFusion 8 with Oracle 10g R2 Issue /* /*I noticed differences when we moved as well. I am betting when you /*connected /*to non-RAC instances, you used the Oracle driver from the pulldown in the /*DSN section. When you connect to RAC instances, you have downloaded /*Oracle's /*thin client and are using Oracle jdbc string. /* /*You have 3 options in my experience: /*- change your code to manipulate the date strings /*- change mask on date columns in database /*- change driver. If you use Macromedia's (DataDirect's) jdbc connection to /*your RAC instances your date issues will disappear. However if you use /*OID, /*this driver does not support it. If you use stored procs, this is the only /*driver you can use. /* /*On Mon, Oct 6, 2008 at 12:20, Boysie Tupaz <[EMAIL PROTECTED]> wrote: /* /*> Hi everyone, /*> /*> I have an application that uses ColdFusion 8 and Oracle 10g R2. Both CF8 /*> and 10g are working very well but the problem that I'm having is that /*the /*> cursor never gets drop every time a query runs. All cursors never get /*> release. /*> /*> Does anyone experienced this problem before? /*> Any suggestions, ideas, answers are welcome. /*> /*> Thanks in advance. /*> /*> /* /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
