[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 * 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/
RE: [flexcoders] coldfusion convert formatting query in flex 1.5
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: flexcoders@yahoogroups.com on behalf of rgwilson26 Sent: Wed 22-Feb-06 8:50 PM To: flexcoders@yahoogroups.com 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
RE: [flexcoders] coldfusion convert formatting query in flex 1.5
CF query - ** cfquery name=getAllPersonnel datasource=spotDB SELECT PersonName, PersonTitle, convert(datetime, InterviewDate, 101) FROM dbo.PersonnelNeeded WHERE (InterviewDate = '2/20/2005') /cfquery On all the DBMS that I have experience with, using a function in the select statement will cause the name of the column to be changed. The easiest fix for this is to alias the column name. SELECT PersonName, PersonTitle, convert(datetime, InterviewDate, 101) AS InterviewDate This will alias the column back to its original name. But you could put any legal string after that AS statement and then use that string in the flex code. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning -- 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/ ---BeginMessage--- 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 ---End Message---