Yes, this is the error I would expect you to get. And the Error is
telling you what the problem is. The CFX_EXCEL tag does not overwrite
existing files. You need to pass it a file name that is guaranteed to
not exist.
So either use CFFILE to delete the previous one if it exists, or
use a random file name to pass to CFX_EXCEL.
Steve
At 02:12 PM 3/25/2000 -0000, Paul's Mail wrote:
>Hi,
> here is the link:-
>http://www.wheretoflyfish.com
>Any problems, let me know.
>Kind regards
>Paul Burgess
>
>> -----Original Message-----
>> From: cftalk [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, March 25, 2000 1:13 PM
>> To: [EMAIL PROTECTED]
>> Subject: Problems with CFX_EXCEL
>>
>>
>> I am using CFX-Excel.
>> For some reason CF is telling me, that the file
>> TOPInfo_Excel.XLS
>>
>> already exists.
>>
>>
>> Error Diagnostic Information
>>
>> Error in CFX_Excel Tag
>>
>> C:\cfusion\database\TOPInfo_Excel.XLS already exists.
>>
>> The error occurred while processing an element with a general
>> identifier of
>> (CFX_EXCEL), occupying document position (13:1) to
>> (18:19).
>>
>>
>> I am using the same name in file, workbook and worksheet.
>> Is this a problem ?
>>
>> <CFX_Excel Query="CollectDataTopInfo"
>> File="C:\cfusion\database\TOPInfo_Excel.XLS"
>> Workbook="C:\cfusion\database\TOPInfo_Excel.XLS"
>> Worksheet="TOPInfo_Excel"
>> Row="2"
>> Col="1">
>>
>> Best Uwe
>>
>>
>> SD Solutions
>> Uwe Degenhardt
>> Fon: 08122/903791
>> Fax: 08122/903792
>> Net: www.sdsolutions.de
>> Mail: [EMAIL PROTECTED]
>>
>>
>> ------------------------------------------------------------------
>> ------------
>> 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.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
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.
