That would definitely cause a problem :) You are missing a quote at the end of your cffile tag after #results#
~Bobby ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Saturday, December 03, 2005 1:01 PM To: CF-Talk Subject: Re: Cffile Error \\SWPRINT\LAB_HEMA is a network printer. <cfexecute> works fine as long as there is a file. I think the issue is <Cffile action="write" file="D:\Inetpub\WWWROOT\BBDatabase\results.txt" output="#results#> doesn't generate a file. jl On 12/3/05, ColdFusion <[EMAIL PROTECTED]> wrote: > Does ColdFusion Service have access to the network drive? > \\SWPRINT\LAB_HEMA ??? > > > > -----Original Message----- > From: John Lucania [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 03, 2005 1:35 AM > To: CF-Talk > Subject: Cffile Error > > C:\CFusionMX\runtime\bin>copy > D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA The system > cannot find the file specified. > > <cfquery name="GetQryList" datasource="BloodBank"> select * from PTBB where > len(MRN) = 7 order by Lname </cfquery> <cfsavecontent variable="results"> > <table border="0" align="center"> > <tr> > <td colspan="6"> > <div align="center"><b>Auto-print Testing <cfoutput>at > #TimeFormat(CreateODBCTime(Now()), "HH:mm:ss tt")# on > #DateFormat(CreateODBCDate(Now()), "MM-DD-YYYY")#</cfoutput></b></div> > </td> > </tr> > <tr> > <td bgcolor="FFFFCC"> > <div align="center"><b>Name</b></div> > </td> > <td bgcolor="FFFFCC"> > <div align="center"><b>ABO</b></div> > </td> > <td bgcolor="FFFFCC"> > <div align="center"><b>RH</b></div> > </td> > <td bgcolor="FFFFCC"> > <div align="center"><b>Antigen</b></div> > </td> > <td bgcolor="FFFFCC"> > <div align="center"><b>Antibody</b></div> > </td> > </tr> > <cfoutput query="GetQryList"> > <tr> > <td bgcolor="CCCCFF">#LName#, #FName#</td> > <td bgcolor="CCCCFF">#ABO#</td> > <td bgcolor="CCCCFF">#RH#</td> > <td bgcolor="CCCCFF">#Antigen#</td> > <td bgcolor="CCCCFF">#Antibody#</td> > </tr> > </cfoutput> > </table> > <strong> > <div align="center"><cfoutput><font > color="990000">#GetQryList.RecordCount#</font></cfoutput><font > color="990000"> > Records Found</font></div> > </strong> > </cfsavecontent> > > <Cffile action="write" > file="D:\Inetpub\WWWROOT\BBDatabase\results.txt" output="#results#> > > <cfexecute name="c:\copy.bat" > arguments="D:\Inetpub\WWWROOT\BBDatabase\results.txt > \\SWPRINT\LAB_HEMA" outputfile="c:\BBBatch.txt"></cfexecute> > > How do you resolve this error? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226022 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
