Hi Ian,
> The article was good but it didn't mention what the best practice is for
> locking during database writes. Does anybody have something official about
> that?
>
Unofficially, assign your application/session variables to variable scope
variables and use these instead in your database read/writes.
This way your lock is only for a fraction of a section while you temporarily
reassign your variables and not for the entire time that your query is
talking to the webserver and database server...
Someone correct me if I'm wrong, but don't forget to duplicate() any
structures, otherwise if you do :
<cfset variables.mystruct = session.mysessionstruct>
all you do is create a pointer to your session structure and not a second
copy of the structure. If you're only creating a pointer then you when you
access that pointer you will also access the session or application
variable....
Well hope that helps...
Regards
Stephen
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
