This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C02260.DCB649F0
Content-Type: text/plain;
charset="iso-8859-1"
you have to insert the comma characters in ascii format. ie.
<cfoutput>#variable1##chr(9)##variable2##chr(9)#</cfoutput>
-----Original Message-----
From: S C [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 19, 2000 12:10 PM
To: [EMAIL PROTECTED]
Subject: [CF-Talk] excel and CF
--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.
------_=_NextPart_001_01C02260.DCB649F0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: [CF-Talk] excel and CF</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>you have to insert the comma characters in ascii format. ie.</FONT>
</P>
<P><FONT
SIZE=2><cfoutput>#variable1##chr(9)##variable2##chr(9)#</cfoutput></FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: S C [<A
HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, September 19, 2000 12:10 PM</FONT>
<BR><FONT SIZE=2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=2>Subject: [CF-Talk] excel and CF</FONT>
</P>
<BR>
<P><FONT SIZE=2>--0-1884661237-969379817=:10166</FONT>
<BR><FONT SIZE=2>Content-Type: text/plain; charset=us-ascii</FONT>
<BR><FONT SIZE=2>Content-Disposition: inline</FONT>
</P>
<P><FONT SIZE=2>I am looking for someone who has had the same problem</FONT>
<BR><FONT SIZE=2>that I am having and has suggestions on how to</FONT>
<BR><FONT SIZE=2>overcome it.</FONT>
</P>
<P><FONT SIZE=2>PROBLEM: Want to dump results from a query into an</FONT>
<BR><FONT SIZE=2>excel file using the cfcontent tag. This code worked</FONT>
<BR><FONT SIZE=2>in CF 3.0 but after upgrading to 4.5 it dumps all the</FONT>
<BR><FONT SIZE=2>data into one cell. What is causing this and how do I</FONT>
<BR><FONT SIZE=2>get the data to dump into separate cells?</FONT>
</P>
<P><FONT SIZE=2>I have attached the code. It consists of two pages</FONT>
<BR><FONT SIZE=2>for simplicity. There is a form page and an action</FONT>
<BR><FONT SIZE=2>page.</FONT>
<BR><FONT SIZE=2>Once you submit the form, the action page should open</FONT>
<BR><FONT SIZE=2>up excel and display the data in excel.</FONT>
</P>
<P><FONT SIZE=2>Any suggestions are appreciated. Again the problem is</FONT>
<BR><FONT SIZE=2>that the data is now being dumped into one cell</FONT>
<BR><FONT SIZE=2>instead of being separated.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>__________________________________________________</FONT>
<BR><FONT SIZE=2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=2>Send instant messages & get email alerts with Yahoo!
Messenger.</FONT>
<BR><FONT SIZE=2><A HREF="http://im.yahoo.com/"
TARGET="_blank">http://im.yahoo.com/</A></FONT>
<BR><FONT SIZE=2>--0-1884661237-969379817=:10166</FONT>
<BR><FONT SIZE=2>Content-Type: text/html; name="test.cfm"</FONT>
<BR><FONT SIZE=2>Content-Description: test.cfm</FONT>
<BR><FONT SIZE=2>Content-Disposition: inline; filename="test.cfm"</FONT>
</P>
<P><FONT SIZE=2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN"></FONT>
</P>
<P><FONT SIZE=2><html></FONT>
<BR><FONT SIZE=2><head></FONT>
<BR> <FONT
SIZE=2><title>Untitled</title></FONT>
<BR><FONT SIZE=2></head></FONT>
</P>
<P><FONT SIZE=2><body></FONT>
<BR><FONT SIZE=2><FORM action="test2.cfm/test2.xls"
method="POST"></FONT>
<BR><FONT SIZE=2><INPUT type="submit" Value="Export
Data"></FONT>
<BR><FONT SIZE=2></FORM></FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2></body></FONT>
<BR><FONT SIZE=2></html></FONT>
</P>
<P><FONT SIZE=2>--0-1884661237-969379817=:10166</FONT>
<BR><FONT SIZE=2>Content-Type: text/html; name="test2.cfm"</FONT>
<BR><FONT SIZE=2>Content-Description: test2.cfm</FONT>
<BR><FONT SIZE=2>Content-Disposition: inline; filename="test2.cfm"</FONT>
</P>
<P><FONT SIZE=2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN"></FONT>
<BR><FONT SIZE=2><CFQUERY NAME="GetBeans"
DATASOURCE="FastTrack_Lab"></FONT>
<BR> <FONT SIZE=2>select * from beans</FONT>
<BR><FONT SIZE=2></CFQUERY></FONT>
<BR><FONT SIZE=2><html></FONT>
<BR><FONT SIZE=2><head></FONT>
<BR> <FONT
SIZE=2><title>Untitled</title></FONT>
<BR><FONT SIZE=2></head></FONT>
</P>
<P><FONT SIZE=2><body></FONT>
<BR><FONT SIZE=2><CFCONTENT TYPE="application/msexcel" ></FONT>
<BR><FONT SIZE=2>beanid beanname</FONT>
<BR><FONT SIZE=2><CFOUTPUT query="GetBeans"></FONT>
<BR><FONT SIZE=2>#bean_id# #bean_name#</FONT>
<BR><FONT SIZE=2></CFOUTPUT></FONT>
</P>
<P><FONT SIZE=2></body></FONT>
<BR><FONT SIZE=2></html></FONT>
</P>
<P><FONT SIZE=2>--0-1884661237-969379817=:10166--</FONT>
<BR><FONT
SIZE=2>------------------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>Archives: <A
HREF="http://www.mail-archive.com/[email protected]/"
TARGET="_blank">http://www.mail-archive.com/[email protected]/</A></FONT>
<BR><FONT SIZE=2>To Unsubscribe visit <A
HREF="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
TARGET="_blank">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</A>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C02260.DCB649F0--
------------------------------------------------------------------------------
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.
