[eera]

Hi,

I have a problem, on how to write two query in coldfusion and how to call in cfreport tag?For example:


<cfquery name="sop_tm" datasource="jol">
select initcap(a.name) as name, initcap(a.phone_owner) as phone_owner, initcap(b.addr_1) as addr_1,initcap(b.addr_2) as addr_2, initcap(b.addr_3) as addr_3,
b.postcode,initcap(b.town) as town,a.phone_no as phone_no, c.coverage as coverage
from jar_adsl_master a, jar_customer b, jar_adsl_booking c
where a.cust_id = b.cust_id
and a.book_id = c.book_id
and a.batch_no = #batch_no#
</cfquery>

<cfquery name="holiday" datasource="jol">
select holiday_date, holiday_range from tholiday
</cfquery>

<CFREPORT format="pdf" permissions="allowmodifycontents" template="SOP_FORM.cfr"
query="#sop_tm#" />


-->The problem is how can i call query "holiday" in cfreport tag above?