hi all,
Is it the proper use of custom tag <cf_excel> ? i want to take the
resultset which is on the browser to excel sheet
with the same result set appearing in the sheet. but with this tag i
managed to pass the link to webpage to
excel sheet. but there i could able to see the same code instead of result
set.
in the first file i given link to xls file like this
<a href="filename.xls">Go to Excel</a>
in filename.xls i wrote following customtag code
<cfset a=#session.cID#>
<cfset b=#dateformat(session.sdate,"mm/dd/yy")#>
<cfset c=#dateformat(session.edate,"mm/dd/yy")#>
<cfoutput>
<cf_excel
Datasource="dsnname"
Tableheadings = "Bank,Branch,Name,Account,Amount"
DataFields="bank,brn,name,Acno,visitamt"
SQLCommand="select cc.bank,cc.name,cc.BRN,cc.ACNo,visit.visitamt from
cc,visit where cc.cID=#a# and visit.eom=1 and visit.cid= cc.cid and
visitdate between #b# and #c# order by cc.cID">
</cfoutput>
so, in the excel sheet i'm getting same code in cfoutput tag not the
records.
thankx in advance
nagesh
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.