Re: query2excel

2008-04-15 Thread Josh Nathanson
wasn't defined. #myvar + 1# This will output 3. -- Josh - Original Message - From: "Eric Roberts" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, April 15, 2008 5:00 PM Subject: RE: query2excel > You have the "#" signs ar

Re: query2excel

2008-04-15 Thread Richard White
* >/*Sent: Tuesday, April 15, 2008 3:14 PM >/*To: CF-Talk >/*Subject: Re: query2excel >/* >/*GOT IT!!! >/* >/*i managed to fool it seeing as the + 1 wasn't working >/* >/*i added an empty row into the query >/* >/*and it then had the same affect as finalQuery.recordco

Re: query2excel

2008-04-15 Thread Richard White
for a variable named >"query.recordcount+1" that doesn't exist. > >Eric > >/*-Original Message- >/* >/*Sent: Tuesday, April 15, 2008 3:14 PM >/*To: CF-Talk >/*Subject: Re: query2excel >/* >/*GOT IT!!! >/* >/*i managed to fool it seeing

RE: query2excel

2008-04-15 Thread Eric Roberts
ric /*-Original Message- /*From: Richard White [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, April 15, 2008 3:14 PM /*To: CF-Talk /*Subject: Re: query2excel /* /*GOT IT!!! /* /*i managed to fool it seeing as the + 1 wasn't working /* /*i added an empty row into the query /* /*and it th

RE: query2excel

2008-04-15 Thread Eric Roberts
sday, 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? /*> /*>ma

Re: query2excel

2008-04-15 Thread Richard White
GOT IT!!! i managed to fool it seeing as the + 1 wasn't working i added an empty row into the query and it then had the same affect as finalQuery.recordcount+1 and it went through fine :) thanks for all your help and suggestions, this must be a bug in this component and i will def look at th

Re: query2excel

2008-04-15 Thread Richard White
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 Healt

Re: query2excel

2008-04-15 Thread Richard White
hi dave, thanks yes i have tried this as well :( still no joy ~| 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:

RE: query2excel

2008-04-15 Thread Dave Francis
One last thing, then I'll shut up - have you tried taking the calculation outside? ie maxRows=x, (or maxRows="#x#") -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 12:58 PM To: CF-Talk Subject: Re: query2excel tanks

Re: query2excel

2008-04-15 Thread Richard White
tanks dave tried that but also unsuccessful, i think i will have to use the other component suggested here as this must be a bug in the cfx thanks >Shouldn't that be maxRows="#finalQuery.recordcount# + 1" > >Does it work without the hashes (they are unnecessary)? i.e. > >maxRows=finalQuery.recor

RE: query2excel

2008-04-15 Thread Eric Roberts
If you copied that exactly...you have the +1 inside the pound signs... /*-Original Message- /*From: Richard White [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, April 15, 2008 8:42 AM /*To: CF-Talk /*Subject: query2excel /* /*Hi, i downloaded a cfx called query2excel and just wondering if ei

RE: query2excel

2008-04-15 Thread Dave Francis
Shouldn't that be maxRows="#finalQuery.recordcount# + 1" -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 11:49 AM To: CF-Talk Subject: Re: query2excel Does it work without the hashes (they are unnecessary)

Re: query2excel

2008-04-15 Thread Richard White
hi dominic its really strange as maxRows=#finalQuery.recordcount# works but maxRows=#finalQuery.recordcount+1# doesnt work i have also tried it both ways as you suggested below but it keeps saying maxrows must be numeric thanks >Does it work without the hashes (they are unnecessary)? i.e. >

Re: query2excel

2008-04-15 Thread Richard White
thanks i will look into this as i do need more flexibility thanks ~| 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 Arch

Re: query2excel

2008-04-15 Thread Dominic Watson
Does it work without the hashes (they are unnecessary)? i.e. maxRows=finalQuery.recordcount+1 OR maxRows="#finalQuery.recordcount+1#" Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software

Re: query2excel

2008-04-15 Thread Alan Rother
Sorry, I can't help you with this particular bug, but if you cannot find a solution let me suggest using Ben Nadels POI CFC. it's an amazing interface into creating Excel files from darn near any CF object. http://www.bennadel.com/projects/poi-utility.htm http://www.bennadel.com/blog/469-Creating