query2excel

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 > 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----- > /* > /*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 > /* > /* > >