Solved

Add Values to Coldfusion Query

Posted on 2010-08-17
2
248 Views
Last Modified: 2012-05-10
I have a CF query that returns a paired value:  
CompanyName, Value
CompanyName, Value
CompanyName, Value

I need to be able to add the Average Value into the list and then sort it so that the average is in the appropriate spot.   That entry would be AVERAGE, Value.    I can't just sort both columns since that won't keep the pairs together...

I feel like this should be easy and I just missing something obvious.   Any ideas?
0
Comment
Question by:digitalwise
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
Plucka earned 500 total points
ID: 33459788
Add a column with queryAddColumn

then loop over the query and set the column with querySetCell

Then use query of query to sort it again.
0
 

Author Comment

by:digitalwise
ID: 33460270
I needed to do queryAddRow but thank you for the reminder on how to do this - I knew I was forgetting something!
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question