have you looked at the docs to see how dateFormat() is used?
it's quite clear you haven't... take 5 secs and it will be VERY
evident amigo
tw
Sent from my iPhone... don't hate
On Oct 27, 2009, at 12:10 AM, Matthew Smith <chedders...@gmail.com>
wrote:
>
>> wrap dateformat() around the dateadd() function.
>>
>> tw
>>
>> Sent from my iPhone... don't hate
>>
>> On Oct 27, 2009, at 12:02 AM, Matthew Smith <chedders...@gmail.com>
>> 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:327753
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
