Add a field name for the converted value (probably best to use something other than InterviewDate to avoid confusion) to your SQL, like so:
SELECT PersonName, PersonTitle, convert(datetime, InterviewDate, 101) AS ConvertedInterviewDate FROM dbo.PersonnelNeeded WHERE (InterviewDate = '2/20/2005') Then change the columnName for your DataGridColumn to "ConvertedInterviewDate". Doug --- In [email protected], "rgwilson26" <[EMAIL PROTECTED]> wrote: > > 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 <*> 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/
