Did you try using the DateFormat() function?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adams, Matt Sent: Monday, January 30, 2006 8:57 PM To: [email protected] Subject: [Flashcoders] dateField and Remoting problem 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 _______________________________________________ Flashcoders mailing list [email protected] http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
