Editing Queies

[ChinoTrixter]

Hi,

Was wondering if there's a way to edit a table after you've created a query.
Say you have something like

<CFQUERY name="Test" DATASOURCE="#....#" username="#....#"
password="#....#">
SELECT aaaa, bbbb, cccc....
FROM ....
WHERE ....
ORDER BY ....
</CFQUERY>

But now say I want to go through every record in "Test" and modify the aaaa's
by performing some kind of function, like (aaaa + 5). And wherever I use this
"Test", I will be using the new modified values. How do i do this? Can I use
a <CFLOOP> and how do I set them, with a <CFSET>? Thank You.

Chino

[aapacleb]

<CFQUERY ...>
UPDATE table_name
SET aaaa=aaaa+5
</CFQUERY>

[The ScareCrow]

I don't think Chino wants to update the table, just the display

<cfoutput query="Test">
<cfset newValue = Test.aaaaa + 5>
#newValue#
</cfoutput>

Ken

[ChinoTrixter]

Yes I do want it for the display, but I was wondering if I can change all the
aaaa values from "Test" at one go and have it stored in "Test" itself so that I
dont have to modify the aaaa's wherever I have the <cfoutputs>.
So I just want

<cfoutput query="Test">
#Test.aaaa#
</cfoutput>

but all the aaaa's have already been modified. Thank you.

[mxstu]

Did you try something like this...

<cfloop query="Test">
<cfset Test["aaaa"][currentRow] = aaaa + 5>
</cfloop>

<cfdump var="#Test#">