Mark Leder wrote:
> I'm attempting to filter a query set based on a date. However, it looks
> like the DateAdd function is not in an ODBC format, so I can't compare the
> current date to the filePostDate + twgFileExpDate. I've looked around CFLib
> without success. How would I write this?
>
> <cfset ARGUMENTS.twgFileExpDate = 21>
>
> SELECT F.fileURL, F.filePostDate, F.caseID
> FROM #APPLICATION.prefix#_Clients_Files_List F
> WHERE F.caseID = <cfqueryparam cfsqltype="cf_sql_char"
> value="#ARGUMENTS.caseID#">
> AND #CreateODBCDateTime(Now())# <=
> #DateAdd('D',ARGUMENTS.twgFileExpDate,F.filePostDate)#
>
You are trying to do the dateadd on F.filePostDate on the CF side of
things, but the F.filePostDate value will not exist until the query is
being run...use a function on the db side of things...
AND #CreateODBCDateTime(Now())# <= DATEADD(day,
#ARGUMENTS.twgFileExpDate#, F.filePostDate)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261711
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
