Your right I haven't used the tag. Depending on how you want the layout to
look though, what can be easier or have less overhead than having CF output
query results to an HTML file and simply saving it with *.xls on the end
instead of *.htm or *.html You obviously didn't try it, either. :)
Do whatever works for you and gets the job done the way you want it.
Fred Sanders
Galveston, Texas
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]>
Sent: Friday, April 07, 2000 8:05 AM
Subject: Re: Using CFX_Excel
> 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.
------------------------------------------------------------------------------
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.
