Your convert(datetime, InterviewDate, 101) doesn't have a alias. Try this convert(datetime, InterviewDate, 101) as interviewdate.
Anyway, I always return non formated dates to Flex and format there and return a non-formated date back to CF. If your problem is the format in your dataGrid, you should try the labelFunction in your dataGridColumn. João Fernandes -----Original Message----- From: [email protected] on behalf of rgwilson26 Sent: Wed 22-Feb-06 8:50 PM To: [email protected] Subject: [flexcoders] coldfusion convert formatting query in flex 1.5 I am working with a query in coldfusion where I am converting the date format from the database. 2 of the 3 columns show up in my datagrid, but the 3rd (InterviewDate) does not display. However, it does if I take out the convert formatting and just query the column name. Is this due to FLEX not recognizing the columnName or somthing else? CF query - ****************************** <cfquery name="getAllPersonnel" datasource="spotDB"> SELECT PersonName, PersonTitle, convert(datetime, InterviewDate, 101) FROM dbo.PersonnelNeeded WHERE (InterviewDate = '2/20/2005') </cfquery> FLEX - ******************************* <mx:DataGridColumn headerText="Name" columnName="PersonName" width="225" /> <mx:DataGridColumn headerText="Title" columnName="PersonTitle" width="650" wordWrap="true"/> <mx:DataGridColumn headerText="Date" columnName="InterviewDate" width="100"/> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<<winmail.dat>>
