Query in coldfusion report builder

how to write two query in coldfusion report builder?

Page 1 of 1

0 Replies - 2608 Views - Last Post: 31 January 2008 - 12:26 AM Rate Topic: -----

#1 eera  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 07-January 08

Query in coldfusion report builder

Posted 31 January 2008 - 12:26 AM

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?

Is This A Good Question/Topic? 0
  • +

Page 1 of 1