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 earlier this month:
<cfquery datasource="your_datasource" name="lockThreads">
LOCK TABLES yourTableName WRITE
</cfquery>
<cfquery datasource="your_datasource">
INSERT INTO yourTable (yourFields)
VALUES (yourValues)
</cfquery>
<cfquery datasource="your_datasource" name="lastMID">
SELECT LAST_INSERT_ID() AS msgID
FROM yourTable
</cfquery>
<cfquery datasource="pheads_User" name="unlockThreads">
UNLOCK TABLES
</cfquery>
HTH,
Evan
--
-=-=-=-=-=-=-=-=-=-
Evan Lavidor
Circle.com Boston
Tel: 617-585-3107
Fax: 617-585-3091
-=-=-=-=-=-=-=-=-=-
> > -----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
