The error message tells you what is wrong. >"This expression must have a constant value."
i.e. This expression must NOT be a variable. Unfortunately, CF cannot point precisely at the expression - it can only tell you that it is within the cffunction tag - which it does by highlighting the last line of that tag. However, there are only two variables within the tag - argumentCollection and dsn - so either/both of these are the culprit that the error is referring to. However, neither of these belong in a cffunction tag - they should be passed in as an argument when you call the function! Also, the last few lines of your code show that you are not var scoping your variables! That needs to be fixed or it risks causing you big headaches. You can find unscoped variables using varScoper - http://varscoper.riaforge.org/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-talk/message.cfm/messageid:320172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
