Hi, i downloaded a cfx called query2excel and just wondering if either anyone
else has used it and has come up with the same error, or whether i am doing
something fundamentally wrong in coldfusion to get the following error:
the code i am using is as follows:
<cfx_query2excel
query="finalQuery"
templateFile="#expandPath('.')#\template_query_results.xls"
outputFile="#expandPath('.')#\Excel_Downloads\#filePath#"
startRow=1
maxRows=#finalQuery.recordcount+1#
columnHeaderRow=1
appendOverwrites="true">
the error is on the maxrows attribute, it tells me that it must be numeric
(maxRows=#finalQuery.recordcount+1#) however if i take out the +1 then it
accepts it fine.
i have even tried to setting variable to the recordcount + 1 then using that
variable. it essentially works fine until i try to add 1 to it, no matter what
way i try to add the 1.
am i missing something simple or is there a bug with this cfx?
thanks very much
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303407
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
