>wrap dateformat() around the dateadd() function.
>
>tw
>
>Sent from my iPhone... don't hate
>
>On Oct 27, 2009, at 12:02 AM, Matthew Smith <[email protected]>
>wrote:
>
>>
Still the same:
<cffunction access="public" name="qry_contestthisweek_get" output="false"
returntype="query">
<cfargument name="lastthursday" type="string" default="">
<cfset nextthursday = dateformat(dateadd("d", 7, arguments.lastthursday))>
<cfquery
name="qry_contestthisweek_get"
datasource="#variables.datasource#">
select *
from #variables.sqlobjectprefix#contest
where 1 = 1
and addeddate between <cfqueryparam
value="#createodbcdatetime(arguments.lastthursday)#"
cfsqltype="CF_SQL_TIMESTAMP"> and <cfqueryparam
value="#createodbcdatetime(nextthursday)#" cfsqltype="CF_SQL_TIMESTAMP">
order by score, age
</cfquery>
<cfreturn qry_contestthisweek_get>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327737
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
