<cfset session.views = "#queryName.Division#">
would be:
<cflock scope="session" type="exclusive" timeout=3>
<cfset session.views = "#queryName.Division#">
</cflock>
<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>
would be:
<CFQUERY name="docs" datasource="intranetv8">
SELECT docid, doctitle, docsummary, docpath, docView_type
FROM itdocs
WHERE category2='#URL.category2#'
AND
<cflock scope="session" type="readOnly" timeout=3>
views='#session.views#'
</cflock>
OR
views = 'all'
</CFQUERY>
=======================================================================
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:36 AM
> To: CF-Talk
> Subject: RE: Personaliztion with Coldfusion ?
>
>
> Can you show me where I'd use the locks?
>
> Candace K. Cottrell, Web Developer
> The Children's Medical Center
> One Children's Plaza
> Dayton, OH 45404
> 937-641-4293
> http://www.childrensdayton.org
>
>
> [EMAIL PROTECTED]
>
> >>> [EMAIL PROTECTED] 12/3/2002 10:25:15 AM >>>
> 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
