<Cfoutput query="queryName" groupBy="lender_margin">
Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. <http://www.aegeon.com.au> www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 22 June 2007 12:22 PM To: cfaussie@googlegroups.com Subject: [cfaussie] CF Query Question Hi, have the following query select loanno, LoanProgram, BorrowerName, LoanFacility, BorRate, InvstLoanRate, SettlementDate, FeeFreeRate, OtherFeeRate, PenaltyRate, BorRate-InvstLoanRate as lender_margin from trails I am wondering is there is a way that i can sort the output based on the value of "lender_margin" given its value is created from two other columns in the table, whilst lender_margin is not a physical column in the table Regards Claude <BR --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
