0 Replies Latest reply on Oct 28, 2006 3:21 AM by Newsgroup_User

    Query to Excel problem

    Level 7
      Hi I want to export my query (from cfc) to excel. I got the code but can't
      figure out how to use it with flex.

      My cfc function is as follows:


      cffunction name="getExcel" access="remote" returntype="void">
      <cfquery datasource="db" name="qryAccessData">
      SELECT *
      FROM tbl_ords
      </cfquery>
      <cfheader name="content-disposition"
      value="inline;filename=AccessToExcelDump.xls">
      <cfcontent type="application/msexcel">

      </cffunction>

      Note that my query is much more complicated than this one, it has many fields
      (over 50).

      So, should I include the code fro excel in my function as above, or are there
      any additional piece of code missing.
      Or is my code wrong.

      Pls let me know how to proceed with this.
      And also how do I call the function on a button in flex.

      Many Thx