Thanks, Pascal...
Rick
> -Original Message-
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 11:05 AM
> To: CF-Talk
> Subject: RE: query output to Excel file
>
>
> If you do the sam
If you do the same for word, it will work with Word 2000+
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: donderdag 11 september 2003 16:59
To: CF-Talk
Subject: RE: query output to Excel file
Thanks, David...
Rick
Anything similar to save data/HTML to Word
Thank, Pascal...
Rick
> -Original Message-
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 10:16 AM
> To: CF-Talk
> Subject: RE: query outpu
eToWrite#" nameconflict="OVERWRITE">
>
>
> HTH
>
> DavidB
>
>
> -----Original Message-----
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 10:05 AM
>
The
-Original Message-
From: Pascal Peters
Sent: donderdag 11 september 2003 16:16
To: CF-Talk
Subject: RE: query output to Excel file
Organisation
Name OCP
Activity
Type
Geoscope
Regiser date
#qORG.ORG_NAME
#
#qOrg.ORG_REGISTER_DATE#
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: donderdag 11 september 2003 16:05
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&
, 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
ptember 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&
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
-Talk
Subject: RE: query output to Excel file
Tony,
Alternatively, just append the data to a variable as you are looping
through with commas as delimiters etc. and then write the variable to
the file when you are done.
André
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 11:13 AM
To: CF-Talk
Subject: RE: query output to Excel file
trouble is, I cant do it all in 1 query, I have cf logic that HAS to be
there, and it is then emailed to a client :( so, is there a way to
Its a procedure which is internal to SQL Server. It can be kicked off from
CF.
-Original Message-
From: Petr Kysela [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 16:33
To: CF-Talk
Subject: query output to Excel file
What is a DTS export?
Is it something that can be kicked off by cf,
Subject: RE: query output to Excel file
but I could in the same light, write the data as comma delimited inside
a cfsavecontent?
and then from there...dump the data in the cfsavecontent into the
cffile, as one file system hit?
tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED
to do.
-d
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 10:55 AM
Subject: RE: query output to Excel file
> but I could in the same light, write the data as comma delimited inside
>
fax 410.860.2337
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 11:34 AM
To: CF-Talk
Subject: Re: query output to Excel file
Tony,
You can do anything you need to do in the cf template, writing it out as
you would normal html
you would first create it in the sql server,
then you can actually kickstart it using that weird string it creates to
reference itself...
the one that looks like this...
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
A173BEC9-1178-4B2D-91A4-5ED8B2DCB2B8 -To "Admin EMail" -VrfyBackup
-BkUpMedia DISK -B
bject: RE: query output to Excel file
STORED PROCEDURE
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 16:13
To: CF-Talk
Subject: RE: query output to Excel file
trouble is, I cant do it all in 1 query, I have cf logic that HAS to be
there, and it is
dley [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2003 10:53 AM
> To: CF-Talk
> Subject: RE: query output to Excel file
>
>
> Youre using SQL server yes?
>
> So DTS would be the best option for that amount of data, Jon Hall posted
> all about it a few months ba
The problem you will have about the excel file is that it usually writes to
the SQL server local dir.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 16:09
To: CF-Talk
Subject: RE: query output to Excel file
interesting... may have to try that as an
inal Message-
>From: Tony Weeg [mailto:[EMAIL PROTECTED]
>Sent: 04 September 2003 16:09
>To: CF-Talk
>Subject: RE: query output to Excel file
>
>
>interesting... may have to try that as an avenue ;) thanks!
>
>tony weeg
>sr. web applications architect
>navtrak, inc
STORED PROCEDURE
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 16:13
To: CF-Talk
Subject: RE: query output to Excel file
trouble is, I cant do it all in 1 query, I have cf logic that HAS to be
there, and it is then emailed to a client :( so, is
10:59 AM
To: CF-Talk
Subject: Re: query output to Excel file
Assuming SQL Server, the easiest way would be to do a DTS export
directly an excel file.
If you are not using SQL Server, then there really isn't an easy way.
0.548.2337
fax 410.860.2337
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 10:53 AM
To: CF-Talk
Subject: RE: query output to Excel file
Youre using SQL server yes?
So DTS would be the best option for that amount of data, Jon Hall
-Talk
Subject: RE: query output to Excel file
neil.
what do you put in the cfsavecontent? the query object or some sort of
outputted formatted data?
tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original
architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 10:53 AM
To: CF-Talk
Subject: RE: query output to Excel file
Youre using SQL server yes?
So
Assuming SQL Server, the easiest way would be to do a DTS export
directly an excel file.
If you are not using SQL Server, then there really isn't an easy way.
Clint
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Youre using SQL server yes?
So DTS would be the best option for that amount of data, Jon Hall posted
all about it a few months back, check the archives.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 15:54
To: CF-Talk
Subject: RE: query output to
)
[mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 10:53 AM
To: CF-Talk
Subject: RE: query output to Excel file
We simply use cfsavecontent as HTML and let Excel convert it.
-Original Message-
From: Petr Kysela [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 15:45
To: CF-Talk
You can just save it in csv format but with a .xls extension, it works,
Excel opens them up np.
-Original Message-
From: Petr Kysela [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 15:45
To: CF-Talk
Subject: query output to Excel file
What would you say is the best way of creating an
We simply use cfsavecontent as HTML and let Excel convert it.
-Original Message-
From: Petr Kysela [mailto:[EMAIL PROTECTED]
Sent: 04 September 2003 15:45
To: CF-Talk
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
id love to know myself, I have a query that returns an assload of data,
that I have to write
to csv, and now it takes 45 minutes to complete...there has to be a
better way!
tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
31 matches
Mail list logo
