MySQL supports table level locking
I think the syntax is
lock tables table_name [,table_name]...
unlock tables
A lingering question about how CF handles database connection pools:
Does CF guarantee that all the queries from one page request (including
cfincludes and customtags) go through the same database connection with no
intervening requests from other pages? Kind of a dumb question because there
is no good reason why it should do otherwise, but there is always that
lingering doubt.
----- Original Message -----
From: "Bud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 13, 2000 12:12 AM
Subject: Alternative to cftransaction
> Howdy all.
>
> I'm trying to port my cf_ezcart over to Linux and MySql. All's going
> well so far. One problem though. I get an error that MySql is not
> transactional so I can't use the ctransaction tag to lock the
> database while I write a record then do a query get the
> max(customer_id) record written. Can I just use a cflock like this?
>
> <cflock name="cust#attributes.dsn#" timeout="30" type="exclusive">
>
> Will that basically do the same thing? If not, any hints? And if so,
> will that work on 4.51 without the scope parameter?
>
> Thanks.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
