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:303527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
