Nice Chris, thanks, saves a lot of time !
-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED]
Sent: 25 July 2006 19:34
To: CF-Talk
Subject: Cool feature I didn't know about
Most of you probably know this, but I thought I would share because I
will use this all the time.
H
Yes, I know what you were showing and it makes perfect sense for that
example. I was just trying to show other ways to avoid the function that
might be the best option for different scenarios.
On 7/25/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> > That way will work 99% of the time, there i
thing on the CF side???
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 4:47 PM
To: CF-Talk
Subject: Re: Cool feature I didn't know about
Sounds right as he is using Hungarian notation to notify a Quer
-
From: Bryan Stevenson <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 22:03:02 2006
Subject: Re: Cool feature I didn't know about
Hey Ben,
I'm not entirely sure, but this:
qData.value is not an array and thus I suspect that's why it errors
Bryan Stevenson B.Co
ed by Reed Exhibitions."
Visit our website at http://www.reedexpo.com
-Original Message-
From: Ian Skinner <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 21:54:18 2006
Subject: RE: Cool feature I didn't know about
This is a pound: £
You yanks and your abuse of the Queen
Hey Ben,
I'm not entirely sure, but this:
qData.value is not an array and thus I suspect that's why it errors
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web:
This is a pound: £
You yanks and your abuse of the Queens English :-)
Now is that a pound as in a measure of weight (which is what we in the US mean
by #. As in I would like to buy a 5# pot roast for dinner.)
Or is it just the monetary pound you Brits supposedly don't use anymore, being
part
July 25, 2006 4:44 PM
To: CF-Talk
Subject: RE: Cool feature I didn't know about
.. But this Throws errors:
They appear to be the same thing, but throw error simply on syntax??
I do not know the underpinnings of ColdFusion to know for sure, but I would
guess it depends on the functio
Indeed, we had a discussion on this and I was for not using evaluate (others
were) - though I am not 100% against it, I have never seen bad performance with
it all in all.
I believe back in the pre-Java/MX days there was more of a performance hit with
evaluate when under heavy load. I've heard
our website at http://www.reedexpo.com
-Original Message-
From: Aaron Rouse <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 21:12:56 2006
Subject: Re: Cool feature I didn't know about
I have not messed with GetMetaDAta much but I'd imagine
GetMetaData(Instance[Arguments.
te at http://www.reedexpo.com
-Original Message-
From: Ian Skinner <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 21:38:51 2006
Subject: RE: Cool feature I didn't know about
Ultimately the point is #Form["blah_#i#"]# replaces Evaluate()
And #form["blah_&qu
. But this Throws errors:
They appear to be the same thing, but throw error simply on syntax??
I do not know the underpinnings of ColdFusion to know for sure, but I would
guess it depends on the functions. These are functions after all, and
functions except certain kinds of parameter
those expressed by Reed Exhibitions."
Visit our website at http://www.reedexpo.com
-Original Message-
From: Aaron Rouse <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 21:12:56 2006
Subject: Re: Cool feature I didn't know about
I have not messed with GetMetaDAta much but I&
Ultimately the point is #Form["blah_#i#"]# replaces Evaluate()
And #form["blah_" & i]# cleans up the extra pound signs. :-)
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Soduko
| | |
-
"C code. C c
ailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 4:18 PM
To: CF-Talk
Subject: Re: Cool feature I didn't know about
Ben...you can go as far as referencing a column in a specific row of a query
using the array notation
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electri
> That way will work 99% of the time, there is almost always a way to avoid
> using Evaluate() and SetVariable(). You can also do things like
> #Form["blah_#i#"]# only point that out since the prior
> example might imply you would have to first do something like "Blah_#I#" /> and then #Form[foo]#
Well all I can say is I no longer use Evaluate() ...there may be some
circumstances where it fails...but I haven't found it yet
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL
Ben...you can go as far as referencing a column in a specific row of a query
using the array notation
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electr
n it to the sender or
> call
> our switchboard on +44 (0) 20 89107910. The opinions expressed within
> this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Aaron Ro
One example I think I have is
GetMetaData(evaluate('instance.' & arguments.methodName))
Or
evaluate('attributesStruct.#attributeName#')
I would guess, but have not tested, that something like these would maybe
equivalent.
GetMetaData(instance[arguments.methodName])
attributesStruct[attribute
quot;
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Aaron Rouse <[EMAIL PROTECTED]>
> To: CF-Talk
> Sent: Tue Jul 25 20:50:39 2006
> Subject: Re: Cool feature I didn't know about
>
> Any examples of where you could not s
This will not work all the time though will it? You will never get rid of
evaluate altogether?
Not altogether, but it is used much more often then necessary. The only
occurrence I have not been able to eliminate it from is something like this.
You can also do #attributesStruct[attributeName]# in a lot of cases.
> -Original Message-
> From: Robertson-Ravo, Neil (RX)
> Sent: Tuesday, July 25, 2006 1:43 PM
>
> Will have to dig in my code - I suppose the question to the
> gurus etc is
> can you 100% dispose of using evaluate?
>
hboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions."
Visit our website at http://www.reedexpo.com
-Original Message-
From: Aaron Rouse <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 20:50:39
. The opinions expressed within
> this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Bryan Stevenson <[EMAIL PROTECTED]>
> To: CF-Talk
> Sent: Tue Jul 25
Any examples of where you could not see a way around it?
That is a neat trick with the ArraySum although I'd guess the number would
be all out of whack if you are doing grouped(CF not SQL) output.
On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Examples? Sometimes I hate us
edexpo.com
-Original Message-
From: Bryan Stevenson <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 20:06:58 2006
Subject: Re: Cool feature I didn't know about
> Examples? Sometimes I hate using evaluate but I sometimes cannot see a way
> around it!
Bryan Stevenson B.Comm.
e opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions."
Visit our website at http://www.reedexpo.com
-Original Message-
From: Josh Nathanson <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 20:09:22 2006
Subject: Re: Cool feature I
Chris,
That is a wicked cool feature and I just did some experimenting with it:
http://bennadel.com/index.cfm?dax=blog:167.view
Do you have any idea why the "[...]" notation is required? I get errors when
I do QUERY.Column. I draw a comparison to ValueList() which can take
QUERY.Column ,but NOT
eed to use GROUP BY
on a column if you are using an aggregate function such as SUM.
-- Josh
- Original Message -
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, July 25, 2006 11:36 AM
Subject: Re: Cool feature I didn't
> Examples? Sometimes I hate using evaluate but I sometimes cannot see a way
> around it!
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesy
Word up, I didn't know that. That is a hi-quality tip :)
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 2:34 PM
To: CF-Talk
Subject: Cool feature I didn't know about
Most of you probably
n-Ravo, Neil (RX) [mailto:Neil.Robertson-
> [EMAIL PROTECTED]
> Sent: Tuesday, July 25, 2006 2:37 PM
> To: CF-Talk
> Subject: Re: Cool feature I didn't know about
>
> Not true all the time, it can however have overhead in SQL, a SUM function
> at the DB, on a
> You probably do one of 2 things: 1) Increment a variable while
> outputting your query, or b) perform a query of queries.
>
> Just do this: #arraySum(getData['rev'])# You can use any array
Awesome tip, Chris- thanks for sharing. Already started replacing QofQs I
had with SELECT sum(). De
Visit our website at http://www.reedexpo.com
-Original Message-
From: Josh Nathanson <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 19:53:23 2006
Subject: Re: Cool feature I didn't know about
Also, it's nifty to do this in your SQL query and avoid the overhead in CF
entir
--Original Message-
From: Bryan Stevenson <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 19:45:33 2006
Subject: Re: Cool feature I didn't know about
Good tip Chrisand using array notation you can avoid Evaluate() and ait
makes assigning values to dynamically named variables much n
Also, it's nifty to do this in your SQL query and avoid the overhead in CF
entirely, so long as your query is returning the desired rows. In MySQL it
would be something like
SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin,
othercolumns FROM table WHERE whereclause
Then on
Good tip Chrisand using array notation you can avoid Evaluate() and ait
makes assigning values to dynamically named variables much nicer
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-
38 matches
Mail list logo
