Yes, that's a read.
---------- Original Message ----------------------------------
from: "Mark Leder" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 6 May 2002 11:08:45 -0400
>Would locking include such things as checking if statements, ie:
>
> <CFIF NOT IsDefined ("SESSION.var")>
> Run some code
> </CFIF>
>
>Thanks,
>Mark
>
>
>-----Original Message-----
>From: Chris Norloff [mailto:[EMAIL PROTECTED]]
>Sent: Monday, May 06, 2002 11:01 AM
>To: CF-Talk
>Subject: Re: Do I need to lock around queries?
>
>
>If the name of the query is application.queryname (for example), then
>yes, it must be locked.
>
>But rather than locking the entire query - to save time name the query
>request.queryname (for example) then after the query move the var into
>the application scope.
>
>Anytime an application, server, or session variable is in code it's
>either a read or a write, and must be locked.
>
>Chris Norloff
>
>
>---------- Original Message ----------------------------------
>from: "Andy Ousterhout" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>date: Sun, 5 May 2002 14:20:09 -0500
>
>>Should I put named locks around database queries or should the database
>
>>engine (Access2000)? I have heard the Access sometimes has indexing
>>issues and I was curious if anyone out their had experience with locks
>>reducing the likelihood of an indexing issue.
>>
>>Thanks,
>>Andy
>>
>>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
