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 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>
Will that work in Access and SQL Server though? basically, I'd like
to eventually make my shopping cart available for Linux and/or mySQL.
The only real problem I've seen so far is whenever I hit a
cftransaction block.
--
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
