Thanks, David...
Rick
Anything similar to save data/HTML to Word documents
in a tab delimited format?
> -----Original Message-----
> From: Boardwine, David L. [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 10:06 AM
> To: CF-Talk
> Subject: RE: query output to Excel file
>
>
> Try something like this.
>
> <CFQUERY name="Dynamic" datasource="#Session.dsn#">
> #PreserveSingleQuotes(MyQueryString)#
> </CFQUERY>
>
> <CFSAVECONTENT variable="mynewxlsfile">
> <CFOUTPUT>
> <Table>
> <CFLOOP query="Dynamic">
> <TR>
> <TD>#Dynamic.FldName1#</TD>
> <TD>#Dynamic.FldName2#</TD>
> <TD>#Dynamic.FldName3#</TD>
> </TR>
> </CFLOOP>
> </TABLE>
> </CFOUTPUT>
> </CFSAVECONTENT>
> <CFOUTPUT>
> <CFSET FileToWrite =
> "QueryResults_Date#dateformat(Now(),'dd-mm-yyy')#_Time#Timefo
> rmat(Now(),'hhm
> msstt')#.xls">
> <CFFILE action="WRITE" output="#mynewxlsfile#"
> File="d:\somedir\#FileToWrite#" nameconflict="OVERWRITE">
> </CFOUTPUT>
>
> HTH
>
> DavidB
>
>
> -----Original Message-----
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 10:05 AM
> To: CF-Talk
> Subject: RE: query output to Excel file
>
>
> What's the code look like for "pushing an ordinary html
> table as a file with
> an .xls extention
> using cfcontent"? Can you give an example for us?
>
> Rick
>
>
> > -----Original Message-----
> > From: Chris Stoner [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, September 04, 2003 4:37 PM
> > To: CF-Talk
> > Subject: Re: query output to Excel file
> >
> >
> > push an ordinary html table as a file with an .xls
> extention using
> > cfcontent.
> >
> >
> > ----- Original Message -----
> > From: "Petr Kysela" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, September 04, 2003 10:45 AM
> > Subject: query output to Excel file
> >
> >
> > > What would you say is the best way of creating an Excel
> > file from query
> > > data?
> > > I don't need to know how to create a .csv file.
> > >
> > > I've seen solutions through ADO objects, ODBC dsn, custom
> > tags, etc.
> > >
> > > But surely there must be something quick and easy.
> > >
> > > Cheers
> > >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > ~~~~~~~~|
> > Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
> > Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
> > Unsubscribe:
> >
> http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
> >
> > Signup for the Fusion Authority news alert and keep up with
> > the latest news in ColdFusion and related topics.
> > http://www.fusionauthority.com/signup.cfm
> >
> >
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~|
> Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
> Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
> Unsubscribe:
> http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
>
> This list and all House of Fusion resources hosted by
> CFHosting.com. The place for dependable ColdFusion Hosting.
> http://www.cfhosting.com
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
