--0-1884661237-969379817=:10166
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
I am looking for someone who has had the same problem
that I am having and has suggestions on how to
overcome it.
PROBLEM: Want to dump results from a query into an
excel file using the cfcontent tag. This code worked
in CF 3.0 but after upgrading to 4.5 it dumps all the
data into one cell. What is causing this and how do I
get the data to dump into separate cells?
I have attached the code. It consists of two pages
for simplicity. There is a form page and an action
page.
Once you submit the form, the action page should open
up excel and display the data in excel.
Any suggestions are appreciated. Again the problem is
that the data is now being dumped into one cell
instead of being separated.
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--0-1884661237-969379817=:10166
Content-Type: text/html; name="test.cfm"
Content-Description: test.cfm
Content-Disposition: inline; filename="test.cfm"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<body>
<FORM action="test2.cfm/test2.xls" method="POST">
<INPUT type="submit" Value="Export Data">
</FORM>
</body>
</html>
--0-1884661237-969379817=:10166
Content-Type: text/html; name="test2.cfm"
Content-Description: test2.cfm
Content-Disposition: inline; filename="test2.cfm"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<CFQUERY NAME="GetBeans" DATASOURCE="FastTrack_Lab">
select * from beans
</CFQUERY>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<CFCONTENT TYPE="application/msexcel" >
beanid beanname
<CFOUTPUT query="GetBeans">
#bean_id# #bean_name#
</CFOUTPUT>
</body>
</html>
--0-1884661237-969379817=:10166--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
