Thanks, that was it.

On edittabstats, line 190 I added
               <cfset form.before = createODBCDate(form.before)>
               <cfset form.after = createODBCDate(form.after)>



On 1/8/07, Jake Churchill <[EMAIL PROTECTED]> wrote:


I ran into a very similar issue in the Reports tab for session reports.
I was on an Oracle 10 DB with a Linux OS so I'm not sure if this is the
same problem you are having.  I reported it as a bug.  See
http://bugs.farcrycms.org:8080/browse/FC-683.  If you keep close tabs on
the format of the date it seems to work.  The issue is that the Java
call being made is not capable of handling a lot of different formats
like ColdFusion is so you have to standardize the format slightly before
passing it on the Java.

Bob wrote:
>
> When I view stats on the site tab (Site tab > Content Item > Stats) the
> report shows the activity since creation but the date range show
> between Oct 9, 2006 and Dec 31, 1969.
>
> When I attempt to change the report date I get the error:
> Cannot format given Object as a Date
>
> The error occurred in
> E:\Farcry\farcry_core\packages\farcry\gregorianCalendar.cfc: line 172
> Called from E:\Farcry\farcry_core\admin\edittabStats.cfm: line 208
> Called from E:\Farcry\farcry_core\admin\edittabStats.cfm: line 204
> Called from E:\Farcry\farcry_core\admin\edittabStats.cfm: line 85
> Called from E:\Farcry\farcry_core\admin\edittabStats.cfm: line 34
> Called from E:\Farcry\farcry_core\admin\edittabStats.cfm: line 31
>
> 170 :         var tDateFormat=javacast("int",arguments.thisDateFormat);
> 171 :         var
> iLocale=aLocale.init(listFirst(arguments.thisLocale,"_"),listLast(
arguments.thisLocale,"_"));
>
> 172 :         return
> aDateFormat.getDateInstance(tDateFormat,iLocale).format(
arguments.thisDate);
>
> 173 :     </cfscript>
> 174 : </cffunction>
>
>
> No matter how I format the date I get the same error. Has anyone
> received this error? Any workarounds?
>
> Thanks, Bob
>
>
> >
>

--
Jake Churchill
CF Webtools
11204 Davenport, Ste. 200b
Omaha, NE  68154
http://www.cfwebtools.com
402-408-3733 x103



>


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to