If you just run a query that says select max, does it die? If not, you could try using select max as max_allowed then use getEvents.max_allowed
On Tue, Mar 31, 2009 at 7:55 AM, Adam Parker <[email protected]> wrote: > >>Max is a function. Don't use it as a column name. > > Hi Maureen - > > Thank you for the reply. This column name has been in place for a while and > would be very difficult to change as it would affect many applications. > Would alias work for renaming the "max" column to something like > "maximumAllowed?" Does aliasing work for function names? > > Thanks, > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4492 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
