5 Replies Latest reply on Oct 27, 2009 7:50 AM by izdabye

    Trouble creating Excel File

    izdabye Level 1

      Hi

       

      Here is the code I got and modified from the internet

       

       

       

      <cfsetting enableCFOutputOnly="Yes">

      <cfquery datasource="#dsn#" name="getInfo">
      SELECT distinct route
        FROM empDB
        where route > 100 and route < 4999
        order by route asc
      </cfquery>

      <cfset tabChar = chr(9)>     
      <cfset newLine = chr(13) & chr(10)>
      <cfheader name="Content-Disposition" value="filename=pay1.xls">
      <cfcontent type="application/msexcel">

      <cfoutput>Street Number#tabChar#Street Name#newLine#</cfoutput>
      <cfloop query="getFilms">
      <cfoutput>#streetNumber##tabChar##streetName##newLine#</cfoutput>
      </cfloop>

       

      When I run the code, i get Error: "internet explorer cannot download math.cfm from www.brantnews.com"

       

      anyone got any ideas why

       

       

      Thanks

      Craig