Forgot to add: Server: Win 2003 server with IIS 6 Workstation: XP Pro CFMX 6.1
-----Original Message----- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 03 May 2006 08:32 To: CF-Talk Subject: RE: Printing from CF Unfortunately it doesn't look like cf_avery is going to do what I need. (Thanks for the info, Adrian.) So I thought about doing it by outputing the data to be printed to a file and have a .bat send the content to lpt1: The batch file just contains: type 1.txt >lpt1: Sadly, I'm seeing nothing hit the printer. Does anyone have any idea what the issue is here please? Thanks, Jenny <cfquery name="jobs" datasource="#application.dsn#"> SELECT top 1 * FROM List_jobs_full ORDER BY List_jobs_full.jobID desc </cfquery> <cfsavecontent variable="print"> <cfoutput> <cfloop from="1" to="#jobs.items#" index="i"> <table width="600" border="0" cellspacing="0" cellpadding="3"> <tr> <td>Item: #i# of #jobs.items#</td> <td> </td> </tr> <tr> <td width="50%"><strong>DELIVER TO:<br> #jobs.name#<br> #jobs.depart#<br> #jobs.org#<br> #jobs.bname#<br> #jobs.address#<br> #jobs.town#<br> #jobs.phone# <br> #jobs.postcode#</strong></td> <td width="50%">SENDER:<br> #jobs.Company#<br> #jobs.Add1#<br> #jobs.Add2#<br> #jobs.City#<br> #jobs.County#<br> #jobs.Country#<br> #jobs.CustPcode#<br> #jobs.Telephone#</td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td colspan="2">#jobs.special#</td> </tr> </table> </cfloop> </cfoutput> </cfsavecontent> <Cffile action="write" file="C:\inetpub\lbcouriers.fasttrackonline.co.uk\management\jobs\print\1.txt" output="#print#" addnewline="no"> <cfexecute name="C:\inetpub\lbcouriers.fasttrackonline.co.uk\management\jobs\print\print.bat"></cfexecute> -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.5.2/329 - Release Date: 02/05/2006 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239361 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
