I have this form with a a drop-down box and a submit
button. The drop down box displays a list of
departments and has a onChange
event, that calls a _javascript_ function that reloads
the page. ColdFusion reads the querystring,
passes it in a cfquery select statement and displays
the usernames and fullnames associated
with the dept from a sql table.
I have been asked to also add a submit button which
would take the results returned from the query and
export it to a xls spreadsheet.
I have added the code, for some reason when it is
submitted, the File Download windows dialog box
displays the wrong information
File Name : Displays the name of the coldfusion file
which contains this code, when I want it to display
the file name given in the cffile FILE attribute.
File Type : empty, when I want it to display MSExcel
Here is my code. Somebody please show me how to get
round this problem.
report.cfm
<cfparam name="url.dept" default="">
<script language="_javascript_" type="text/_javascript_">
function setDept() {
if (document.the_form.deptselect.selectedIndex != 0)
{
myindex=document.the_form.deptselect.selectedIndex;
location=document.the_form.deptselect.options[myindex].value;
return true;
}
else
{
location.href="" an option";
return true;
}
}
function setFlag(){
document.the_form.flag.value=1;
return true;
}
</script>
<table align="left" border="0">
<form name="the_form" action=""> method="post">
<tr>
<td align="left" nowrap>
<select name="deptselect" > <option value="" selected>-----select a
department----</option>
<option value="report.cfm?dept=Finance" <cfif
url.dept EQ "Finance">selected</cfif>>Finance</option>
<option value="report.cfm?dept=HR" <cfif url.dept EQ
"HR">selected</cfif>>HR</option>
<option value="report.cfm?dept=Mgmt" <cfif url.dept
EQ "Mgmt">selected</cfif>>Mgmt</option>
</select>
<cfif url.dept eq "">
</td>
</tr>
<cfelseif url.dept neq "">
<input type="hidden" name="flag" value="0">
<input type="Submit" name="submit" value="Export to
Spreadsheet" setFlag();">
</td>
</tr>
</cfif>
</form>
<cfquery name="getDetails" datasource="mydsn">
select firstlastname, useremail from userdetails
where area like '%#url.dept#%'
</cfquery>
<tr vAlign="top">
<th vAlign="bottom" width="50%" bgColor="#444444"
class="arttext">
<font color="#FFFFFF">Username</font>
</th>
<th vAlign="bottom" width="50%" bgColor="#444444"
class="arttext">
<font color="#FFFFFF">Email</font>
</th>
</tr>
<cfoutput query="getDetails">
<tr>
<td vAlign="bottom" width="50%" bgColor="E4E4E4"
class="arttext">
#firstlastname#
</td>
<td vAlign="bottom" width="50%" bgColor="E4E4E4"
class="arttext">
#useremail#
</td>
</tr>
<cfif IsDefined("form.flag")>
<cfif form.flag EQ "1">
<CFSET QUOTE = Chr(127)>
<CFSET log_string = QUOTE & firstlastname & QUOTE &
","
& QUOTE & useremail & QUOTE>
<cfset log_string =
Replace(log_string,"#chr(34)#","#chr(34)##chr(34)#","All")>
<cfset log_string =
Replace(log_string,"#chr(127)#","#chr(34)#","All")>
<CFFILE ACTION=""> FILE="\ExportToXLS.xls"
ADDNEWLINE="Yes"
OUTPUT="#log_string#">
</cfif>
</cfif>
</cfoutput>
<cfif IsDefined("form.flag")>
<cfif form.flag EQ "1">
<CFHEADER NAME="Content-Type"
VALUE="application/msexcel">
<CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=\ExportToXLS.xls">
<CFCONTENT TYPE="application/msexcel"
FILE="\ExportToXLS.xls" deletefile="Yes">
</cfif>
</cfif>
</table>
Best Regards,
cfcoder
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
