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.
