Remove the quotes from "session.reportDate". You're passing a literal
string, not a variable reference.
cheers,
barneyb
On 9/14/05, Mark Fuqua <[EMAIL PROTECTED]> wrote:
> Hey there,
>
> Sorry for my ignorance. Trying to test out <cfchart>. Having trouble with
> using a date in the where clause of my query. I know I am more than likely
> doing something really dumb and imagine the solution is quite simple. So,
> before I spend more hours trying to figure this out...Thought I would ask
> for help. Here is the code:
>
> <cfmodule template="#Request.layout#/Header.cfm" pageType="JobAdmin">
>
> <cfset session.reportdate = 1>
> <cfset session.associate = 23>
> <cfset session.reportDate eq '09/14/05'>
> <cfset session.jobId = 26>
> <cfquery name="test" datasource="mdfinish">
> SELECT Associate, Job, ReportDate, TotalHours
> FROM TimeCard
> WHERE TimeCard.Associate = session.Associate AND timeCard.ReportDate =
> #createodbcDate ("session.ReportDate")# and TimeCard.job = #session.jobId#
> </cfquery>
>
>
> <cfchart chartwidth="600">
> <cfchartseries type="bar">
> <cfchartdata item="Total Hours" value="#test.totalhours#">
>
> </cfchartseries>
> </cfchart>
>
> <cfmodule template="#Request.layout#/Footer.cfm">
>
>
>
>
> Here is the error message:
>
> Parameter validation error for function CREATEODBCDATE.
> The value of the parameter 1, which is currently "session.ReportDate", must
> be a class java.util.Date value.
>
> Thanks,
>
> Mark
>
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 100 invites.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
