Hi Fred,
I think we have solved the problem. First, I put the tag in a CFLOCK to prevent
attempts at multi-threading. Then, there was
another problem. I was not aware that our SysAdmin had made the https directory a
little different structure than the http
directory. There were some added characters in the path so here is what was
happening. Excel was generating the spreadsheet (Sheet
1), but because it could not find the directory, it kept sitting there with the
message "Do you want to save Sheet 1?". These were
stacking up and I think this was what was really causing the problem.
As for the CFX_Excel, I can't imagine that you've used the tag if you suggested I
first save the file as HTML and doing all that
formatting. CFX_Excel makes it SOOOOooooooo much simpler.
Dave
=================================
"Technology" is stuff that was invented after
you were born.
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
----- Original Message -----
From: Fred Sanders <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 06, 2000 2:57 PM
Subject: Re: Using CFX_Excel
Why bother with the tag. If your wanting to output nice looking
spreadsheets and don't mind having to make painful amount nested tables you
can have professional looking Excel97/2K spreadsheets by creating them as
HTML files and saving them with an .xls extension before allowing the user
to download them. I don't think it will work with anything below Excel 97
though, but the results in the end are worth the trouble your going to go
through getting the layout perfect.
Fred Sanders
Galveston, TX
Having a bad day?
Imagine this...
You are in total seclusion from that hectic place called "The World".
The soothing sound of a gentle waterfall fills the air with a cascading
serenity.
The water is clear.
You can easily make out the face of the person you are holding underwater.
Feeling better?
----- Original Message -----
From: "Dave Hannum" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Thursday, April 06, 2000 11:11 AM
Subject: Using CFX_Excel
> Anybody got a clue on this??? 8-)
>
>
> +++++ Original Message Sent 7:47am ET +++++
>
> Good Morning,
>
> Are there any known issues surrounding the use of the CFX_Excel tags? I'm
using it for several applications now, and I was
> wondering if there are any issues to be aware of - like, how many
concurrent calls to Excel can it handle? The reason I've asked is
> that two days in a row, Excel on our server caused a "kernel32.dll" error
and locked the server. Now, assuming that nothing is
> hosed up in Windows NT (we all know that never happens) and the Excel
install is A-OK (which it seems to have been to the point the
> problems started) - what are the possibilities? I'm wondering if too much
traffic on the tag/application combo might be the
> culprit? Also, can you do a CFLOCK to avoid this problem? Any thoughts?
>
> Thanks,
> Dave
>
>
> =================================
> "Technology" is stuff that was invented after
> you were born.
>
> David Hannum
> Web Analyst/Programmer
> Ohio University
> [EMAIL PROTECTED]
> (740) 597-2524
>
>
>
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> 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.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
