I think neither - #foo# is like #variables.foo# so it won't look in the url or the session scope, and if foo is not defined in the variables scope anywhere it will fail with "Variable foo is not defined".
At least that's how I think it SHOULD work. Could be wrong though. -- Josh ----- Original Message ----- From: "Greg Morphis" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Friday, February 09, 2007 10:53 AM Subject: what scope type takes precedence? > I'm supporting some CF code and need to check something.. > if you have 2 variables > session.foo > and url.foo > > and in a query you have > select #foo# from table > where blah = 1 > > which scope takes precedence? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4