Personally I never use SESSION vars for the exact issue you seem to be experiencing...loss of sticky sessions across servers. It used to be an issue in CF up to and including CF 5 if memory serves. Apparently it's been fixed in MX.
I use a system very similar to yours, but I use a cookie to store a Session_ID (unique key in my session table which relates a session to a user_ID). That's a tad more secure than storing actual user_IDs ina cookie as you are doing (in case someone can gain access to the cookie (pretty unlikely as I use non-persistent cookies....stored in memory until browser is closed). I re-run my user related query with each request (based on value in cookie) and it has never dragged down the system. All the user specific vars are in the REQUEST scope. This way no matter what happens, the user's session will move between servers with NO PROBLEMS ;-) You could even reboot the server and the user will maintain their session!! Hope that helps Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com54 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182636 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
