<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>
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
