My bad. Sorry folks. It turns out the culprit was another component I was
invoking from within that same CFC. The error code/message was leading me in
the wrong direction. Just began commenting everything out until it ran
properly.
What's strange is that until I commented out this call it would throw an
"Out of bounds exception" on the first compile but would run fine on every
request afterwards from what I could see.
The sub-component I was invoking contained a QofQ with the following syntax:
<cffunction name="combineDataSrc" returntype="any" hint="Combine two
recordsets">
<cfargument name="aRecordset1" type="query" required="yes">
<cfargument name="aRecordset2" type="query" required="yes">
<cfargument name="orderBy" type="string">
<cfargument name="orderByDir" type="string" default="asc">
<cfquery name="newRecordSet" dbtype="query">
<cfif IsDefined( "arguments.orderBy" )>
SELECT *
FROM
(
</cfif>
SELECT *
FROM aRecordset1
UNION
SELECT *
FROM aRecordset2
<cfif IsDefined( "arguments.orderBy" )>
)
ORDER BY #arguments.orderBy# #arguments.orderByDir#
</cfif>
</cfquery>
<cfreturn newRecordSet>
</cffunction>
Any ways I removed the external SELECT and put that as a function on it's
own rather then trying to do everything in one shot...problem seems to have
disappeared.
Stace
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 4:17 PM
To: CF-Talk
Subject: RE: Passing Date Object thru CFINVOKE
Stacy, I'm not able to reproduce this. Are you sure?
=======================================================================
Raymond Camden, ColdFusion Jedi Master for Macromedia
Email : [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 11, 2002 4:08 PM
> To: CF-Talk
> Subject: Passing Date Object thru CFINVOKE
>
>
> If I've defined a CFC with an argument of type "DATE", CF chokes when
> I attempt to invoke that component and I pass in a date object.
>
> <cfinvoke component="com.mydomain.reports.activity"
> method="getSummary">
> <cfinvokeargument name="startDate"
> value="#CreateDateTime(2002,01,01,00,00,00)#">
> <cfinvokeargument name="endDate"
> value="#CreateDateTime(2002,02,02,23,59,59)#">
> </cfinvoke>
>
>
> <cffunction name="getSummary" access="remote" returntype="any"
> output="yes">
> <cfargument name="startDate" type="date" required="yes">
> <cfargument name="endDate" type="date" required="yes">
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
