Converting CFGRID from Flash to HTML in Coldfusion

sglee
sglee used Ask the Experts™
on
Order History in Flash and HTMLHi,
  I have CFGird using Flash format, but IE and Chrome browsers fail to display it. Firefox used to be the only browser to display it, but even the most recent version of Firefox fails to display it.
 So I had no choice but to change it to HTML format.
 However  My new code generates an error.
 Can you help?

Thanks.

*** OLD CODE ***
<cfform name="frmtest" skin="HaloBlue" timeout="120">
    <cfgrid name="gridtest"
        height="400" width="700"
        selectMode="row"
            sort = "yes"
        format="flash"
        rowHeaders="no"
            query = "GetOrderHistory"
        onChange = "getURL('OrderHistoryDetails.cfm?cfgridkey='+gridtest.selectedItem.ID)">

        <cfgridcolumn name="OrderDate" header="Order Date">
        <cfgridcolumn name="ID" header="Order No" width="60">
               <CFGRIDCOLUMN NAME="CustomerNo" DATAALIGN="LEFT"  HEADER="Cust##" width="60">
               <CFGRIDCOLUMN NAME="ShipTo1" DATAALIGN="LEFT"  HEADER="Ship To" width="150">
        <cfgridcolumn name="PONo" header="PONo">
        <cfgridcolumn name="Processor" header="Processor">
     </cfgrid>
</cfform>

**** NEW CODE ****
<cfform action = "#CGI.SCRIPT_NAME#">
    <cfgrid name = "FirstGrid" width = "800"
            query = "GetOrderHistory" colheaderbold="Yes"
            font = "Tahoma" rowHeaders = "No"
            selectColor = "Red" selectMode = "Edit" Format = "HTML">

        <cfgridcolumn name = "ID" header="ID" Select="No" display = "Yes" width=5>
        <cfgridcolumn name = "CustomerNo" header = "Customer No" Select="No" width="75" textcolor="blue"
                      bold="Yes" href="OrderHistoryDetails.cfm" hrefkey="ID">
               <CFGRIDCOLUMN NAME="OrderDate" DATAALIGN="LEFT"  HEADER="Order Date" mask="m-d-y" width="100">
        <cfgridcolumn name="ShipTo1" header="ShipTo1" width=70>
        <cfgridcolumn name="PONo" header="PONo" width=30>
        <cfgridcolumn name="Processor" header="Processor">          
    </cfgrid>
    <br>
    <cfinput type="submit" name="gridEntered">
</cfform>
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Commented:
Yeah, a lot of browsers are dropping Flash support.

Which version of CF are you running? AFAIK, format="HTML" has been supported since CF8.  Unless you're using a really old version it should work.  The above displays correctly with CF11 and FF40:

<cfset GetOrderHistory = queryNew("ID,CustomerNo,OrderDate,ShipTo1,PONo,Processor")>
<cfset queryAddRow(GetOrderHistory, 1)>
<cfloop list="#GetOrderHistory.columnList#" index="col">
   <cfset GetOrderHistory[col][1] = col &" "& 1>
</cfloop>

<cfform action = "#CGI.SCRIPT_NAME#">
    <cfgrid name = "FirstGrid" width = "800"
            query = "GetOrderHistory" colheaderbold="Yes"
            font = "Tahoma" rowHeaders = "No"
            selectColor = "Red" selectMode = "Edit" Format = "html">

        <cfgridcolumn name = "ID" header="ID" Select="No" display = "Yes" width=5>
        <cfgridcolumn name = "CustomerNo" header = "Customer No" Select="No" width="75" textcolor="blue"
                      bold="Yes" href="OrderHistoryDetails.cfm" hrefkey="ID">
               <CFGRIDCOLUMN NAME="OrderDate" DATAALIGN="LEFT"  HEADER="Order Date" mask="m-d-y" width="100">
        <cfgridcolumn name="ShipTo1" header="ShipTo1" width=70>
        <cfgridcolumn name="PONo" header="PONo" width=30>
        <cfgridcolumn name="Processor" header="Processor">  			
	</cfgrid>
    <cfinput type="submit" name="gridEntered">
</cfform> 

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial