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? The actual error is [quote] Query Of Queries syntax error.</b><br> Encountered "update" at line 0, column 0. [/quote] Am i understanding this correctly or is there another problem? You can only use SELECT on a QofQ? If so, what's the best way to change some of the values on the query temporarily without altering the data in the database? -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --- 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/
