Right on the backs of that last one...
I would be replacing queries that have lines like this "UCB.FirstName + ' ' + UCB.LastName AS CreatedBy,"
I saw the setFieldExpression() method, but upon investigation it turns out to only work on an existing field.
I propose a method of addFieldExpression().
A call could look something like:
queryObj.addFieldExpression('CreatedBy_User','CreatedBy',"FirstName + ' ' + LastName",'
cf_sql_varchar')
Let me know what you think.--
Chris Phillips
www.dealerpeak.com
Senior Application Developer -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
