Just put <CFLOCK TIMEOUT=30 (or however many seconds you want)> </CFLOCK> around your
call to the CFX_Excel tag.
Check the documentation in the CFML Language Reference for CFLOCK.
Dave
=================================
"Always Drink Upstream From The Herd!"
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
----- Original Message -----
From: Robert Everland <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 7:47 AM
Subject: RE: cfx_excel
What kind of lock should we use. Could you show us a snippet of what you
did?
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 8:07 AM
To: [EMAIL PROTECTED]
Subject: Re: cfx_excel
You have to have Microsoft Excel on the server. The tag actually uses MS
Excel. Make sure you do a LOCK on the call to the tag
because Excel does not handle mulit-threading very well.
Dave
(Who has learned this the hard way)
=================================
"Always Drink Upstream From The Herd!"
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
----- Original Message -----
From: Nagesh Kumar Deva <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 5:52 AM
Subject: cfx_excel
hi all,
i'm using cfx_excel tag. i donno is this the way to use that tag, if i run
this i am getting following error.
any ideas,
thankx in advance
nagesh
<cfquery name="test" datasource="aptitude2">
select * from clinic
</cfquery>
<CFX_Excel Query="Test"
File="C:\XLS\OUTPUT3.XLS">
<cfcontent type="application/msexcel"
file="C:\XLS\OUTPUT3.XLS">
<cflocation url="index.cfm">
Error Occurred While Processing Request
Error Diagnostic Information Error in CFX_Excel Tag Can't start Excel The
error occurred while processing an element with a general identifier of
(CFX_EXCEL), occupying document position (5:1) to (6:37). Date/Time:
05/09/00 18:44:01 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT;
DigExt) Remote Address: 10.0.0.240
----------------------------------------------------------------------------
--
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.
