Have you tried Ben Nadel's CreateXlsFromQuery? It creates a true Excel file
which should be able to be opened in 2013. We are still on 2010 so I have not
been able to test it but it's worth a try.
The original code can be found at:
http://www.bennadel.com/blog/469-creating-microsoft-excel
You might also try saving the output as CSV and opening it in excel that way.
Its an annoying workaround but may work.
AS for CF8, ask about Railo then - its FOSS, and is faster than ACF.
So what is the specific error? Is it in CF or Excel. If Excel are
you getting this message?
Excel
So what is the specific error? Is it in CF or Excel. If Excel are you getting
this message?
The file you are trying to open, '[filename]', is in a different format than
specified by the file extension. Verify that the file is not corrupted and is
from a trusted source before opening the file
So what is the specific error? Is it in CF or Excel. If Excel are you getting
this message?
Excel actually opens. So, it's an Excel error. However, it just says
There's an error with no further information. I *wish* it was the
error below, because then I'd have something to go
:
I've got an application running on CF8 that's been successfully
generating Excel reports for a good amount of time.
Recently, the user upgraded Office (using 2013 now) - and now it no
longer functions for them.
Pretty simple stuff:
cfsetting enablecfoutputonly=Yes
cfheader name=Content
I've got an application running on CF8 that's been successfully
generating Excel reports for a good amount of time.
Recently, the user upgraded Office (using 2013 now) - and now it no
longer functions for them.
Pretty simple stuff:
cfsetting enablecfoutputonly=Yes
cfheader name=Content
I've got an app that's been generating Excel without any problems for a
number of years (pre cfspreadsheet tags)
Hosting recently migrated the site to a new server, and suddenly the
client can no longer open the Excel files on their end.
They're using Excel 2010, and have been before
Hi,
I am working on exporting data to excel with multiple sheets. The sheets
are dynamic and may range from 2 to more than 5. What is the best way to
handle this?
1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation of
sheets? I have tried with cfspreadsheet but only the last
You really ought to be looking outside of CF for transfers of large
datasets, especially into Excel. Have you tried using SSIS (SQL Server
Integration Services) for this? It's really not that difficult to do and
it'll handle millions of rows easily...
--
Jeff
Original Message
, funand learning funandlrnn...@gmail.com wrote:
Hi,
I am working on exporting data to excel with multiple sheets. The sheets
are dynamic and may range from 2 to more than 5. What is the best way to
handle this?
1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation of
sheets
, 2014, at 10:03 AM, funand learning funandlrnn...@gmail.com
wrote:
Hi,
I am working on exporting data to excel with multiple sheets. The sheets
are dynamic and may range from 2 to more than 5. What is the best way to
handle this?
1) Use cfspreadsheet or APACHE POI? Do these support
, funand learning funandlrnn...@gmail.com
wrote:
Hi,
I am working on exporting data to excel with multiple sheets. The sheets
are dynamic and may range from 2 to more than 5. What is the best way to
handle this?
1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation
Dear Friends,
Is there anyway we can restrict the user from editing the excel sheet
exported using cfcontent tag.
Your time help is really appreciated.
ThanksRegards,
Sathya
~|
Order the Adobe Coldfusion Anthology now
Sathya -
I'm no expert on CFContent but you might be able to extend the concept
presented in
http://www.bennadel.com/blog/461-creating-microsoft-excel-documents-with-coldfusion-and-xml.htm
which uses a CFSaveContent to create an XML definition of a spreadsheet and
then CFContent to save the file
but you might be able to extend the concept
presented in
http://www.bennadel.com/blog/461-creating-microsoft-excel-documents-with-coldfusion-and-xml.htm
which uses a CFSaveContent to create an XML definition of a spreadsheet and
then CFContent to save the file.
Digging further, there is also
An Ajax loader / spinner should solve your problem just fine.
http://www.jquery4u.com/tools/online-loading-ajax-spinner-generators/
-Cameron
On Tue, May 13, 2014 at 4:43 PM, funand learning wrote:
All -
I have a following link
a href=javascript:callExcel()Generate excel/a
the function
All -
I have a following link
a href=javascript:callExcel()Generate excel/a
the function callExcel() just uses
document.form.action='excel.cfm?requesttimeout=1500';
When the 'Generate excel' link is clicked, the user stays on current page,
and the excel file is generated. The user never sees
link
a href=javascript:callExcel()Generate excel/a
the function callExcel() just uses
document.form.action='excel.cfm?requesttimeout=1500';
When the 'Generate excel' link is clicked, the user stays on current page,
and the excel file is generated. The user never sees the actual 'excel.cfm
Yes, although the problem i am experiecing is this...
I read the spreadsheet With cfspreadsheet which puts it into a query but at
this point it has lost all the formatting (bold, font size, colours, images
etc) so if I try to use cfspreadsheet to update or write to a spreadsheet all
that
Hi,
does anyone have any feedback on whether its possible to open, modify and close
excel spreadsheets with CF tags/functions, or would i need to use the
underlying POI?
thanks
~|
Order the Adobe Coldfusion Anthology now
Have you looked at cfspreadsheet?
Sent from my Samsung Galaxy SII
On Jun 8, 2012 2:43 AM, Richard White rich...@re-base.net wrote:
Hi,
does anyone have any feedback on whether its possible to open, modify and
close excel spreadsheets with CF tags/functions, or would i need to use
Hi,
I have a feeling I am missing something simple!
I have an excel spreadsheet template that includes images, cell formatting
etc...
I need to open the spreadsheet, insert the data where required, save and
close the document.
Do i need to use POI for this? I was trying to read
Hi all,
I'm working with Excel using the Spreadsheet functions in CF 9. I have some
weird behavior going on with formulas, and I have a workaround, but I don't
like it, so I'm looking for some direction.
I have an Excel 2007 spreadsheet. The spreadsheet has simple formulas on it
that sum
Our community has already tested it :)
http://robertdudley.wordpress.com/2010/05/07/upgrade-java-poi-for-better-excel-support-in-coldfusion-8/
Guess it's going to be safe, will report if I face any issues.
Thx rgds,
Pradeep Viswanathan R
-Original Message-
From: Leigh
-Original Message-
From: IT (Pradeep Viswanathan)
Sent: Wednesday, February 29, 2012 1:19 AM
To: cf-talk@houseoffusion.com
Subject: RE: Arabic / Other languages POI Excel Writing
I would not say it is the CFC, rather I would say it's POI or I should Unicode
the data before sending
I used the same source with CF 8 and 9 and it works properly in CF 9.
Good to hear! I guess some of the changes between poi v2.5 (CF8) and v3.5
(CF9) must have involved unicode :)
Guess updating few with the new versions will solve the issue.
If they are compatible with CF8, yes. (I do
Are you sure it is a problem with the cfc? The first thing to check is whether
your data is stored properly as unicode. If you output the characters on
screen, do they display properly?
I have never used cfHSSF, but all three (cfHSSF, POUtitlity and cfspreadsheet)
use POI internally. So the
I would not say it is the CFC, rather I would say it's POI or I should Unicode
the data before sending it to POI.
I am using CF8 , will test it out on different version and get back. Also
noticed that this issue also exists if use a cfheader with excel, will post
some samples in the morning
Are you using POI directly or through some kind of wrapper (ie
cfspreadsheet, poiUtility.cfc, etcetera..)?
Can you post your code?
Leigh,
Thanks for the response. I am using cfHSSF from
http://www.1smartsolution.com/?action=downloads and i am using the function
easyQuery2Excel(). In
Are you using POI directly or through some kind of wrapper (ie cfspreadsheet,
poiUtility.cfc, etcetera..)?
Can you post your code?
~|
Order the Adobe Coldfusion Anthology now!
I have been trying to export data with Arabic characters into excel sheet using
POI, but just get junk characters as below.asd
#F' EF #-/ 9ED'! (FC 'D%E'1'* /(J 'DH7FJ H#1:( 'D'3*A3'1 9F 'D(7'BG 'D0G(JG
HE' GJ EEJ2'*G'
Google tells me that Arabic is supported by POI and I need to convert
Hi there - I'm using Ben Nadel's excellent POIUtility component to create
manipulate some complex Excel reports for my client. So far, so peachy!
This client now wants me to further customise their reports so that certain
sheets can be removed from their templates programatically
All you need is a reference to the POI workbook object. Just remember the sheet
index is zero based. ie 0 - first sheet, 1 - second sheet, etcetera.
cfset workbookObject.removeSheetAt( javacast(int, 0) )
~|
Order the Adobe
Many thanks Leigh - that looks like just the info I was looking for! B-
/cliff
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
On Wed, Jan 4, 2012 at 7:42 PM, Les Mizzell lesm...@bellsouth.net wrote:
I've not had a chance to work with cfspreadsheet yet.
Works OK reading different version Excel files?
What other experiences has everybody had?
If folks seem to think it works better than what I'm doing in CF8, I'll
Larger files (1000+ records) though - usually time out and the import
fails. Excel 2007 (.xlsx) and forward usually fails too.
A thousand records is not a huge amount, unless there are a large number of
columns involved. How many columns? What portion of the process consumes the
bulk
Is CF9 limited to the versions of Excel it will work with?
I've got an application running in CF8 to import email/name lists using
the POI Utility (thanks Ben Nadlel). When (and it's not often) the
client normalizes their data and removes all formatting, AND uses a pre
Excel 2007 file (.xls
Hey Everyone,
Anyone know a way to count the rows in an excel file without using
cfspreadsheet to read the entire file in first? That's what I am trying to
avoid..
Brook
~|
Order the Adobe Coldfusion Anthology now
Off the top of my head. If you set it up as a DSN you could (in theory)
query it using COUNT(SomeColumn) AS myRowCount. That assumes that a DSN
using Excel supports the COUNT() function.
HTH,
G
On Tue, Oct 11, 2011 at 4:26 PM, Brook Davies cft...@logiforms.com wrote:
Hey Everyone,
Anyone
Ad hoc SQL datasources may be an option if you have sufficient privleges on
a sql server and the account running sql has permissions to access the file.
On Tue, Oct 11, 2011 at 2:26 PM, Brook Davies cft...@logiforms.com wrote:
Hey Everyone,
Anyone know a way to count the rows in an excel
version of poi and can do more with newer versions, but I never
gave it to Ed to post up.
Steve
-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com]
Sent: Tuesday, August 16, 2011 9:50 PM
To: cf-talk
Subject: excel sheets poiutility.cfc
Hi All -
This is a third
Hi All -
This is a third version of generating to excel options that I am trying. I was
going through the examples. If I am using apache poi, should I always write to
excel, then read it and display it to the user? Is it possible to just read it
directly from the query and display
Hi All -
I am trying to generate excel using xml. I have a scenario where only 7 columns
will be static and other columns are dynamic and may range from 1 to as many as
300 columns. And number of rows would be around 1000. What is the best approach
for this situation. I tried new cf9
-
From: fun and learning [mailto:funandlrnn...@gmail.com]
Sent: Thursday, August 11, 2011 11:59 AM
To: cf-talk
Subject: quick excel question
Hi All -
I am trying to generate excel using xml. I have a scenario where only 7 columns
will be static and other columns are dynamic and may range
Hi All -
As suggested by a couple of coldfusion developers a weeks ago, I am using xml
to generate excel sheets from coldfusion. I am stuck with the following issue.
Style ss:ID=s71
Borders
Border ss:Position=Bottom ss:LineStyle=Continuous ss:Weight=1
ss:Color=#00/
Border
##,0 doesn't work?
-Original Message-
From: fun and learning funandlrnn...@gmail.com
Sent: Tuesday, August 09, 2011 3:18 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Using excel NumberFormat in coldfusion
Hi All -
As suggested by a couple of coldfusion developers a weeks ago
Double # for each # you want to use...
-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com]
Sent: Tuesday, August 09, 2011 2:19 PM
To: cf-talk
Subject: Using excel NumberFormat in coldfusion
Hi All -
As suggested by a couple of coldfusion developers a weeks ago
Thanks for the info, now that the project is not hold anymore, I will do this.
I've used the POIUtility long ago, I'll check it out again.
so I can't develop for 9 strictly yet.
As an alternative, try the POIUtility.cfc. Like cfspreadsheet it
generates a true Excel file. IIRC it should
has anyone figured out how to add comments to a cell? i cannot make
it work without breaking and causing a 500 server error.
ras
On Mon, Aug 1, 2011 at 3:44 PM, Captain Obvious mr.happ...@gmail.com wrote:
Tried that (specifying XML in filenme attribute of cfheader tag) but Excel
2010
Can you post a small example?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
#10;Testing 123/Font/ss:Data/Comment/Cell
-Original Message-
From: Ras Tafari [mailto:rastaf...@gmail.com]
Sent: Tuesday, August 02, 2011 11:08 AM
To: cf-talk
Subject: Re: cf9 multiple sheet excel
has anyone figured out how to add comments to a cell? i cannot make
it work without breaking
here is what im trying:
cfset spreadsheetSetCellComment(request.myDoc, This is a comment, 1, 1) /
:) sadly, its as simple as that, and not working.
rest of my code to create the spreadsheet is a-ok and working just
fine. just adding comments to a cell is breaking.
tw
On Tue, Aug 2, 2011 at
Comments should be a structure, not a string ;-)
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6733.html
~|
Order the Adobe Coldfusion Anthology now!
in other words RTFM :)
lol
thanks!
tony
On Tue, Aug 2, 2011 at 2:09 PM, Leigh cfsearch...@yahoo.com wrote:
Comments should be a structure, not a string ;-)
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6733.html
in other words RTFM :)
LOL. Well I try to be courteous, so there is a please in there too ;-)
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
true :)
either way, thanks for pointing out the obvious to me... it was late
when i was trying, and just missed the structure part!
On Tue, Aug 2, 2011 at 2:19 PM, Leigh cfsearch...@yahoo.com wrote:
in other words RTFM :)
LOL. Well I try to be courteous, so there is a please in there too
Hi All -
I am trying to generate a multiple tabs excel sheet. I have the following code.
The excel code is copied from coldfusionjedi.com
cfset q = queryNew(Name,Beers,Vegetables,Fruits,Meats,
cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer)
cfloop index=x
The way we have always handled excel spreadsheet generation (CF8), has been to
take a formatted spreadsheet, save it as and XML sheet, open that XML in
Notepad, copy the XML code and paste it inside a cfsavecontent
variable=strXmlData tag...then edit the code to make it dynamic (e.g. Rows
Me too. Have you figured a way to avoid Excel 2010 from producing the
message below when opening files generated in this manner?
The file you are trying to open is in a different format than specified by
the extension...
On Mon, Aug 1, 2011 at 1:07 PM, Bill Franklin bill.frank
]
Sent: Monday, August 01, 2011 12:58 PM
To: cf-talk
Subject: Re: cf9 multiple sheet excel
Me too. Have you figured a way to avoid Excel 2010 from producing the
message below when opening files generated in this manner?
The file you are trying to open is in a different format than specified
The file you are trying to open is in a different format
than specified by
the extension...
That is Excel's extension hardening. It can only be disabled on the client
computer.
http://support.microsoft.com/kb/948615
~|
Ah, thanks Leigh.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346435
Are you opening the file as *.xml, or *.xls? I open mine as *.xml...it knows
to open it as Excel.
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Monday, August 01, 2011 2:12 PM
To: cf-talk
Subject: RE: cf9 multiple sheet excel
The file you are trying to open
Tried that (specifying XML in filenme attribute of cfheader tag) but Excel
2010 appends .xls to the filename, which then results in the extension
prompt. No such problem prior to MS-Office 2007. But thanks Bill, appreciate
the input
Thanks Azadi, I know there are some additional features for the recent
versions. I am using CF9 on my Dev by still CF7 on Production, so I can't
develop for 9 strictly yet.
Thanks for your help
no, there isn't. cfcontent basically just tells the browser which mime
type the content being
so I can't develop for 9 strictly yet.
As an alternative, try the POIUtility.cfc. Like cfspreadsheet it generates a
true Excel file. IIRC it should work on MX7 too.
If you prefer to stick with pseudo-excel files (ie html) there are a lot of old
css tricks floating around. Do a search on mso
Hello,
I am using CFContent to create an excel spreadsheet. The type of data is
different, some are currency and some are integers, ...etc. Each of these
fields once put into Excel should be specified in order to properly format the
spreadsheet.
Is there a way to specify a data type
Nabulsi wrote:
Hello,
I am using CFContent to create an excel spreadsheet. The type of data is
different, some are currency and some are integers, ...etc. Each of these
fields once put into Excel should be specified in order to properly format
the spreadsheet.
Is there a way to specify a data
Is there a sample out there somewhere? I messed with it but couldn't get it to
work.
Is there a reason you cannot just read in the file as binary. Then
display it inline with cfcontent and correct mime header (assuming the
user's browser settings allow ...)?
Something like:
!--- make sure user is authenticated ---
!--- read in the file as binary. ---
cffile action=readbinary
file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')#
variable=myvar
!--- Then display it inline with cfcontent and correct mime header
(assuming
I'll take a whack at it, thanks much!
Something like:
!--- make sure user is authenticated ---
!--- read in the file as binary. ---
cffile action=readbinary
file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')#
variable=myvar
!--- Then display it inline
Well it appears that MX 6.1 doesn't support the variable attribute of
cfcontent.
I may have access to CF9 tomorrow, but in the meantime is there any way to get
this file delivered with MX 6.1?
~|
Order the Adobe Coldfusion
Try:
cfcontent
file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')#
type=application/msexcel
On Tue, May 3, 2011 at 12:32 PM, Liz Maher ohl...@gmail.com wrote:
Well it appears that MX 6.1 doesn't support the variable attribute of
cfcontent.
I may have access
Thanks!
I've got it prompted to download the file with:
cffile action=readbinary file=path-to-the-dir\deliveryschedule.xls
variable=myvar
cfheader name=Content-Disposition value=inline;
filename=deliveryschedule.xls
cfcontent type=application/vnd.ms-excel
file=path-to-the-dir
\deliveryschedule.xls
variable=myvar
cfheader name=Content-Disposition value=inline;
filename=deliveryschedule.xls
cfcontent type=application/vnd.ms-excel
file=path-to-the-dir\deliveryschedule.xls
...but it's still a no-go on displaying inline. Presumably the downloader
can still edit
Well it appears that MX 6.1 doesn't support the variable attribute of
cfcontent.
I may have access to CF9 tomorrow, but in the meantime is there any way to
get this file delivered with MX 6.1?
The VARIABLE attribute lets you point to a variable to get your
content. You don't really need
cffile action=readbinary
Put the file outside a web accessible directory and serve it up as binary using
cfcontent variable=#binaryData# not cfcontent file=...
...but it's still a no-go on displaying inline.
That is all controlled by user's browser settings. If the browser is configured
Well it appears that MX 6.1 doesn't support the
variable attribute of cfcontent.
Did not see the 6.1 requirement
!--- turn off whitespace, etc first ---
cfcontent
...cfoutput#yourVariable#/cfoutput
I could be wrong, but you might need to use ToString() as well:
cfcontent type=application/vnd.ms-excel
file=file-location\deliveryschedule.xls
(if i add the cfoutput code it does the same thing)
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp
Will this do something different than what i'm doing in 6.1 now? If so I'll
try it tomorrow when I'll hopefully access to CF9.
Put the file outside a web accessible directory and serve it up as
binary using cfcontent variable=#binaryData# not cfcontent file=..
.
I've been tearing my hair out all day with this.
I have an Excel file that will be uploaded each day by one user who logs in and
uploads it via a form. The Excel file has multiple worksheets. The names of
the worksheets and even the columns will change and I won't be privy to these
changes
As with soo many things on this forum... the answer is usually - Ben Nadel
Ben wrote a wrapper for a java package that interfaces with Excel, called
POI
http://www.bennadel.com/projects/poi-utility.htm
http://www.bennadel.com/projects/poi-utility.htmIt's pretty badass, point
it at an Excel
Thanks. I found that earlier today and actually tried it out but numerous
errors frustrated me. I'm dealing with MX 6.1 and even though I found and
applied a fix to the CFC for 6.1, I just got a different error down the line.
I am really hoping to just be able to display the Excel file within
I am really hoping to just be able to display the Excel
file within the page,
Is there a reason you cannot just read in the file as binary. Then display it
inline with cfcontent and correct mime header (assuming the user's browser
settings allow
I am trying to output the results of a query to Excel, but instead, it
opens CF Builder. Please advise. TNX.
cfquery name=gettemp datasource=#application.datasource#
select location,score from SPDOut
where SPDINput_id=#url.id#
order by location
/cfquery
cfsetting enablecfoutputonly=yes
delimitter, Excel will
open CSV files ---
!---
cfcontent type=application/msexcel
cfheader name=Content-Disposition value=attachment;
#url.id#-export.csv ---
cfset thefile=Location#chr(delim)#Score#chr(delim)#
cfset thefile= #thefile# #chr(13)#!--- line break after column
header ---
!--- Spill
delimitter, Excel will
open CSV files ---
!---
cfcontent type=application/msexcel
cfheader name=Content-Disposition value=attachment;
#url.id#-export.csv ---
cfset thefile=Location#chr(delim)#Score#chr(delim)#
cfset thefile= #thefile# #chr(13)#!--- line break after column
header ---
!--- Spill
Hi All -
I have been using cfcontent to generate excel files in coldfusion. The problem
is I need to write two different sets of HTMl code because the cfcontent does
not recognize .css files. So for cfcontent part I am using inline style for
each row and column.
There are lot of reports I
Hi all,
I've created a page that consumes an Excel spreadsheet, loops over the rows,
and dynamically creates a pre-populated form. The idea being that folks
inputting data have an intermediate step to clean up the data before inserting
it into the DB.
That all works just fine. When I POST
I doubt cfcontent is the issue. How are you including the css?
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
I doubt cfcontent is the issue. How are you including the css?
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
I am using it in
I am using it in Application.cfm as a cfinclude.
cfinclude template=style.css
Are the contents even being included in the output? Save your psuedo-excel file
to disk and open it with notepad.
No need
It might help to see some code.
-Leigh
Need Mail bonding?
Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=listsid=396546091
Leigh,
Thanks - uhhh...yes, overlooked that part didn't I?
Here's what I have so far - not all of my validation is place but I need to get
this to work first:
cfif IsDefined(#FORM.submitted#)
cfquery name=newStudentInsert datasource=abc
!--- START Looped insert of multiple
Are any of the queries executing? Where does CF report the error happens?
ORDER BY course_id DESC
LIMIT 1
As an aside, that is not a reliable way to retrieve the last id. Cfquery's
result attribute can return the last id created with simple INSERTs.
cfquery name=newStudentInsert datasource=abc
cfquery name=dupeCheck datasource=abc
Wait a second...
You have got a cfquery, nested within another cfquery. That is what is causing
the problem.
cfquery name=newStudentInsert datasource=abc
cfquery name=dupeCheck datasource=abc
Wait a second...
You have got a cfquery, nested within another cfquery. That is what is
causing the problem.
Thanks, Leigh. I knew I needed a second set of eyes. I was
Add the result attribute to your INSERT queries. CF8+ will return a structure
with the new record ID. The key name is determined by your database. (At least
in CF8.) Use that ID value in place of your existing LIMIT 1 queries.
http://livedocs.adobe.com/coldfusion/8/Tags_p-q_17.html
Hello All.
I am reading a text file and saving it in excel.
I am using the following code:
cfoutput
cfset filePath = #ExpandPath( \)#
cfheader name=Content-Disposition value=filename=agentDaily.xls
cfcontent type=application/vnd.ms-excel
file=#filePath#\user\dailyreports\agentDaily.txt
Try this instead:
cfheader name=Content-Disposition value=attachment;
filename=agentDaily.xls
On Wed, Jan 26, 2011 at 8:59 PM, Monique Boea moniqueb...@gmail.com wrote:
Hello All.
I am reading a text file and saving it in excel.
I am using the following code:
cfoutput
cfset
1 - 100 of 1524 matches
Mail list logo