al 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 technolog
of theese
querrys and then wrap all three querries within a single
cftransaction/cftransaction tag.
Greg
- Original Message -
From: "Bud" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 12:41 PM
Subject: cflock vs. cftransaction
Hi all. W
:[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
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
: cflock vs. cftransaction
cftransaction is supposed to wrap a group of querries that form a process.
Such as if someone was purchasing a product and three querries are used, one
to check the user/update user information, pull information from a shopping
cart, and submit the purchase data. you would
Yes, but like he said .. transactions aren't supported my MySQL.
Todd Ashworth
- Original Message -
From: "Greg Wolfinger" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 1:29 PM
Subject: Re: cflock vs. cftransaction
| cftra
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
no, CFLOCK is only for restricting access to a server side
variable. DBs
don't benefit from this.
No, CFLOCK restricts access to a chunk of code. The CFLOCK you suggested
should work, but won't you need to wrap READONLY CFLOCKs around every other
query for the database?
On 12/13/00, Evan Lavidor penned:
CFLOCK doesn't provide the same effect as cftransaction. In MySQL you can
lock your tables, though. It's a little cumbersome. It basically means
that MySQl is only handling one request at a time... Here's some code that
Tage Widsell posted to this listserv
9 matches
Mail list logo