Wow! Ray Camden posts here... next you'll tell me Ben Forta does too.
I am in the process of reading their excellent book on Coldfusion MX7 and
was surprised to see his post today.
I have a bit of a problem that is causing major hair loss and was wondering
if someone might help me with it.
Please help me save some hair!
I am trying to do a bit of flash remoting using flash 8 and coldfusion mx7.
Here's the problem. The newsdate record of my database displays in flash as:
Fri Jan 20 00:00:00 GMT-0600 2006
when I want it to display as just plain ole Jan 20, 2006. I was trying to
accomplish the change with actionscript when someone on the
actionscript forum at chattyleaf suggested I try to change the format in my
cfc.
Here's the cfc:
<cffunction name="getProductsDetails" access="remote" returnType="query"
output="true">
<cfargument name="newsID" type="numeric">
<cfquery name="productDetailQuery" datasource="MASEnews">
SELECT * FROM news WHERE newsID = #newsID#
</cfquery>
<cfreturn productDetailQuery >
</cffunction>
I tried to change it to
SELECT DateFormat(newsdate,'mmmm dd, yyyy'), title, article, newsId FROM
news
but that didn't work
As you can see I haven't read *enough* of their excellent book yet!
Anyone have any ideas?
thanks in advance!
Camden-Forta Fan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:254573
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
