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
>
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
