I've tried posting this in the Adobe (Macromedia) forums with no luck.
I'm hoping that someone here can help. Might be a newbie question, but
I'm thinking I'd get better response here. Sorry for the cross-post and
sorry if this is beneath the level of this list or OT.
I'm trying to send a date from a dateField.selectedDate in Flash to a
CFC. I'm using that date as a filter in the query. The query looks like
this:
<cfquery name="get_classes" datasource="#myDataSource#">
SELECT * FROM trainTrack WHERE classDate > #Flash.Params[2]# ORDER
BY className
</cfquery>
I've tried using a cfm page as a test page and I know that the following
format will filter the result appropriately:
<cfset date1 = CreateDateTime(2006, 02, 10, 4, 20, 20)>
<cfset date2 = CreateDateTime(DatePart("yyyy", date1), DatePart("m",
date1), DatePart("d", date1), 4, 20, 20)>
<cfquery name="get_classes" datasource="#myDataSource#">
SELECT * FROM trainTrack WHERE classDate >= #date2# ORDER BY
className
</cfquery>
This works when used in the query, but whenever I try to do this with
remoting it doesn't work. When I don't try to filter by date, the
correct result of the query is returned so I'm fairly sure that the
problem lies in the way that the date is formated when it hits the
query. I've tried several ways to format the date, but I haven't had any
luck. Oh, and I'm using Access as the DB (which might be some of my
touble). I would really appreciate any insight!
Thanks!
Matt Adams
-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication.
It is intended solely for the use of the designated recipient(s). If this
communication is received in error, please contact the sender and delete this
communication.
===========================================================================================
_______________________________________________
Flashcoders mailing list
[email protected]
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
