Php :: Order By Date Taken From MySQL On ColumnCharts (xField="date")?
Jun 17, 2011
I'm kinda new to Flex and I'm using Flash Builder 4.5. I'm so frustrated.. Trying to solve this since yesterday morning and seems like there is just not enough resources to learn more about Flex! so here is the problem: I have a db field with a "date" DataType and i just can't order by it the xField! i tried so many things and nothing works.. when i try to order it by the id its working but its not supporting dates or something.
ok I have amfphp returning a query that is a Date data type in side of mysql. It is in this format "2007-27-5" which is a string. When making a date object in flash you need some thing like this
Code: var testDate:Date = new Date(2007, 4, 27); I would like to know if there is a short cut around this problem. As it would look now I need to take that string and have a regular expression pull the sub-strings ("2007", "5", "27") out and some how convert the sub-strings in to a numbers (2007, 5, 27), then set vars with the number latter sending it to that date constructor.
Anyone has experience to display the last log date from the mysql database to the flash?
i did it with the username - that was displaying but not the last_log_date anyone can profide suggestion or an easier method/solution? sample script would be coolz.
[Code]...
i read the data in actionscript with username_name and then display the data into the textfield. this worked for the username only but not for the last log date..
I've always just kind of randomly chosen DateTime or TimeStamp. What are the pros/cons of each and what do you use and why? (I realize some have more detail, I'm usually looking for year/month/day/hour/minute/second resolution and I'm currently working with PHP, AS3, and Objective-C.
I retrieved the time from MySQL DateTime column and it's formatted just like this. "2010-04-30 04:12:07"How do I convert a MySQL DateTime so that I can display two seperate fields, I'd like to get "April, 30th, 2010" and "4:12 AM" separately.
I have a php page that sends xml compiled from data in a mysql table to my swf. The swf is actually an auction and I need to load in the' end time' of that item and do a date comparision for a countdown.
So what I'm asking for, in a nutshell, is for the best way to load in a date from a database in such a way that it can be used for date comparisons?
The mysql field is a datetime field. I can modify the format in php to whatever you feel in the best format (I need year, month,day,hour,min, seconds) - but I don't know what to do with the date once I have it in flash.
example xml: <Item end_time="2005-04-01 00:00:00" />
can I convert it into a valid date with out string manipulation? since the following doesn't work (obviously)
my_date = new Date(oXML.firstChild.attributes.end_time)
What I need is to be able to take the current time & substract it from the time in the xml to give me the remaining time.
I am using the function below to convert a Flash AS3 Date type to a MySQL- compatible 'datetime' string. It is working fine, BUT I am worried that AS3 may not extract the 'same date format' from different client computers thereby rendering my function useless.Is there a better way of passing date to MySQL? One that gaurantees consistancy.
public function getMySQLdate(flashDate:Date):String var year:String;var month:String;var day:String;var hours:String; var minutes:String;var seconds:String;
Today is 28-05-2010, so I need to list Event 01. On 01-06-2010 I need to list Event 02. I have the basic AS3 code for listing the XML working, but I'm having trouble filtering the result.
I'm trying build a simple band site using flash and as2. All I want to have is a page listing shows that sorts them according to date and also when the show date has passed drops that entry from view.I can do this easily enough with a database and php but want to learn how to do it in actionscript. Here is what I currently have, shows load from the xml file into a simple textbox:
Code: scrollBar.target = shows_txt; showsXML = new XML();
I'm using flash CS4 and actionscript 2.0. I have a situation where I need to locate and check the date of an external file (either .exe or .swf) and return that date string to a variable in flash. I then need to display that date to a piece of dynamic text within the flash file. Is there a function within action script that will check and retrieve the file date of an external file.
my date of string like (2009-12-03 21:05:00) date with time . so i used to store var newdate:Date=new Date(Date.parse(startdate)); but shows some errors.and also i tried to split string(date) used date function likevar datenumber:Number= (new Date(Date.parse(startdate))).getDate();
Does anyone know how to get actionscript to render a null date value '000:00:00T00:00:00'? I am calling a web service that expects date fields in the SOAP xml. I need some of these dates to serialize as null and I can't see how to produce null. The closest value I can get is '1899-11-30T00:00:00Z'. Below is the code I am using:
I'm trying to determine the difference in time between todays date and a future date. I only need to determine how many months and days it is between todays date and this future date. Anyone know of any prebaked scripts anywhere for determining what todays date is and subtracting it from the end date would be? [code]So if today's date is less then the end date I'd like to determine how many months and days are left until the end date is reached and display the number of months and days until that end date.
I'm trying to get a random date in a date range and this is what i have so far but it doesnt seem to be working ? Where I'm I Going wrong ?Gets the date difference
private function differenceBetweenDates(date1:Date, date2:Date):Number{ var MS_PER_DAY:uint = 1000 * 60 * 60 * 24;[code]..........
I have an mx:DateField in my Flex UI that has a formatString="dd.mm.yyyy" attached to it. However, the initial value for that field may not be in the format specified/defined for the DateField (due to legacy reasons). So, currently, if I just set that value (text) on the DateField, the field is shown empty. I think because it fails to accept the value in a format different than what's configured.
I have 2 DateFields named startDate and endDate I want to set startDate's Selected date to Current months start date and endDate's Selected date to Current months End date.
I need some scripts for the countdown with a current date like 01.30.2009 to count down to meet the deadline - 04.16.2009. how to do that except I can only build a very simple countdown.
[URL] how to make a date countdown. I now want to take it a bit further. On my site I have three gears that just continuously turn; now what I want to do is that over a period of time, these symbols change. Like say every 2 hours the symbols change to a different colour or something, and at pacific dates more gears will appear.
I have a situation where I have a date in this format.
Code: var currentDate : String = "09/22/09"
and I want to be able to change this dynamically to the next date.like you had currentDate +1. The reason for this is the user selects this date but I want another field to display the next date after this.I thought about using the date object to take care of this for me but I'm not sure that will work.If I pass the date object this format it returns.
newDate = Wed Sep 22 00:00:00 GMT-0500 1909
I could start stripping out the currentDate and adding in lots of if statements for the month year and date and figuring out leap years but I thought the date object could solve all this.
I am experiencing a very strange behavoiour of Flex Date object. My web service is written in .Net 3.5 and all object which I am retriving or updating have Creation Date (Date Type) in .Net code.
But when I am calling .Net web service and displaying data in Flex, Flex displaying a different Date than what stored in web service. When I update my object using Flex UI, every time update time is very different than actual update time set by .Net code.
Why there are differences between AS Date and Java Date? I have a startTime field in an ActionScript class and also have a startTime in the related Java class. The time set in AS is new Date(2009,11,19,10,35,50); and then I find it has the value of 2009-12-19T10:35:50.000-0500 in the Java object.
