Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
Shiny7 #1
Re: CFMX7 Flash Grid Date Column
The data was originally passed in as a query, a query generated from cfpop.
although, the data column is a varchar. Since a query must be passed in, I
attempted to do a query of query on the cfpop recordset and cast the date
column to a DATE or TIMESTAMP. And then pass in the new query into the cfgrid.
FYI, casting to a DATE datatype does not work, though casting to a TIMESTAMP
does. An example below
<cfpop name="popmail" action="GETALL" server="*" username="*" password="*">
<cfquery name="qrymail" dbtype="query">
SELECT CAST([date] AS TIMESTAMP) AS popdate FROM popmail
</cfquery>
<cfdump var="#GetMetaData(qrymail)#">
<cfform format="flash">
<cfgrid name="gridmail" query="qrymail">
<cfgridcolumn name="popdate" mask="MM/DD/YYYY"/>
</cfgrid>
</cfform>
Shiny7 Guest
-
CFMX7 flash forms cfgrid time is two hours ahead in grid
I can't understand a query to the database and output to a cfgrid inside a flash form. My db is mysql and cfmx7 is the server. The info that I am... -
Add a column at the end of the Grid
Does anyone know how to add a column to the end of a datagrid. Thanks in Advance. -
2 column grid w/ scrollbar help
Anyone have decent solution for making a 2 column list that could scroll if it has to? For example, i have a client list that i want to populate into... -
hide column in data grid
Hello. I just populated my datagrid but I need to hide one of the column. Since I need this column's data, I cannot drop that column from my... -
Last grid column
Hi void BindDataSource() { System.Web.UI.WebControls.BoundColumn c1 = new System.Web.UI.WebControls.BoundColumn(); c1.DataField =...



Reply With Quote

