House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Talk (CF-Talk)

query2excel

Author:
Josh Nathanson
04/15/2008 08:18 PM

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


Search cf-talk

April 24, 2014

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30       

Designer, Developer and mobile workflow conference