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---