FWIW -- you can do some calculations within pound signs -- something like #myquery.recordcount+1# should work I think, as long as myquery exists as a query. If the query doesn't exist it will error of course. So, it's possible that the OP's actual problem was that the query wasn't defined.
<cfset myvar = 2> <cfoutput>#myvar + 1#</cfoutput> This will output 3. -- Josh ----- Original Message ----- From: "Eric Roberts" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, April 15, 2008 5:00 PM Subject: RE: query2excel > You have the "#" signs around the entire statement. That will produce an > error as "(finalQuery.recordcount+1" does not exist as a variable. Type > maxRows=#finalQuery.recordcount#+1 > > Eric > > /*-----Original Message----- > /*From: Richard White [mailto:[EMAIL PROTECTED] > /*Sent: Tuesday, April 15, 2008 3:08 PM > /*To: CF-Talk > /*Subject: Re: query2excel > /* > /*Hi Daniel, just tried this to no success :( thanks though > /* > /* > /* > /*>Have you tried putting the calculation in brackets first so that it > /*>calculates and then inserts the sum? > /*> > /*>maxRows=#(finalQuery.recordcount+1)# > /*> > /*> > /*>-- > /*> > /*>Daniel Kessler > /*> > /*>University of Maryland College Park > /*>School of Public Health > /*>3302E HHP Building > /*>College Park, MD 20742-2611 > /*>Phone: 301-405-2545 > /*>http://sph.umd.edu > /* > /* > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:303533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
