send query results to printer automatically

[maryana]

Hello,

Please I want your helping in a big problem>>

I have a query that have many results(i.e retrieve many records) and i want to put the each result in table and print it automatically as a report.
and son on for each query result..

Example:
<cfquery datasource=&quot;db1&quot; name=&quot;PrintReports&quot;>
select * from bill where date=#22/11/2001#
</cfquery>
<cfoutput query=&quot;PrintReports&quot;>
<table>
<tr><td>#name#</td></tr>
<tr><td>#fee#</td></tr>
etc.
</table>
</cfoutput>
I want send each output to printer automatically

Is there a solution for this problem in coldfusion 5.0 ?
Please reply me..

Bye

 

[Silvano]

select * from bill where date=#22/11/2001#

22/11/2001 is not a variable!! you don't need # signs Sylvano
dsylvano@hotmail.com

 

[maryana]

The date is not the problem , the problem is how to print output for each query result>
thanks

 

[Silvano]

try this:

<table>
<cfoutput query=&quot;PrintReports&quot;>
<tr><td>#name#</td></tr>
<tr><td>#fee#</td></tr>
</cfoutput>
</table> Sylvano
dsylvano@hotmail.com