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
*
>/*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
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
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
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
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
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
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:
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
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
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
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)
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.
>
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
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
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
16 matches
Mail list logo