The only 'correction' would be a reminder to use locks if you aren't using MX - and I think the guy here is using 4.5.
======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Candace Cottrell [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 9:12 AM > To: CF-Talk > Subject: Re: Personaliztion with Coldfusion ? > > > On your login page you'd set the session variable. > > If the login is successful..... > > <cfset session.views = "#queryName.Division#"> > > > > > Then you'd use the following on the page that displays the documents > > <CFQUERY name="docs" datasource="intranetv8"> > SELECT docid, doctitle, docsummary, docpath, docView_type > FROM itdocs > WHERE category2='#URL.category2#' > AND > views='#session.views#' > OR > views = 'all' > </CFQUERY> > > > Any of the "big dogs" please correct me if I'm wrong ;) > > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
