On Tue, Jan 11, 2005 at 10:31:26AM +1100, Mike Kear wrote: > I have a need to temporarily alter the values of a query for display. > I dont want to change the values in the database, so I thought I'd > run a QofQ and update. > > But i'm getting a syntax error, that i suspect is telling me I can't > use Update in a Query of a Query. Is this right?
Possibly. I couldn't get it to work and moved on to: <cfset temp = QuerySetCell(MyQofQ, "FieldName", "#whatever#", RowVal)> This works nicely if you change: <cfoutput query="MyQofQ"> to <cfloop from="1" to="#val(MyQofQ.recordcount)#" index="RowVal"> and make sure you change references to fields from: MyQofQ.FieldName to: MyQofQ.FieldName[RowVal] I suspect that if I resorted to chicken entrails it might be possible to get QofQ working the way I want it to, but it seems determined to make *me* work the way *it* wants to. Hopefully Blackstone will address some of that. Cheers Paul Haddon Technical Services Manager Formstar Print Technologies --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
