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
| <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 lock each one 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. 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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
