-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Actually, per the definition of CFLOCK, DBs do benefit from this as
far as I can tell. CFLOCK in exclusive mode, single thread's the
piece of code you are trying to isolate. That piece of code cannot
be executed by another thread until it's done.
Aaron Johnson, MCSE, MCP+I
MINDSEYE, Inc.
<phn>617.350.0339
<fax>617.350.8884
<icq>66172567
[EMAIL PROTECTED]
___________________________________________
"Never forget that only dead fish swim with
the stream." -- Malcolm Muggeridge
___________________________________________
- -----Original Message-----
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 3:18 PM
To: CF-Talk
Subject: RE: cflock vs. cftransaction
no, CFLOCK is only for restricting access to a server side variable.
DBs
don't benefit from this.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
- -----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 12:41 PM
To: CF-Talk
Subject: cflock vs. cftransaction
Hi all. When advancing the ID in a database by pulling up the max(id)
as maxid then <cfset newid = query.maxid + 1> and inserting the new
record, I've always used cftransaction around the queries. This gives
an error in MySQL that transactions aren't supported. Will using
cflock do the same thing?
<cflock name="cust#attributes.dsn#" timeout = "10">
queries
here
</cflock>
Thanks.
- --
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
