Bryan,

Thanks for your response.

Would this prevent other queries from running on my ColdFusion Server at the same time?
How does <cftransaction> control this?
Is it better to use <cftransaction> over a stored procedure?

Thanks,
Troy

Bryan Love wrote:

> CFTRANSACTION
>
> do this:
>
> <cftransaction>
>         INSERT query
>
>         SELECT sequence.currVal query
> </cftransaction>
>
> The transaction tags force both queries to run as a single transaction which
> means it's not possible for any other inserts to happen between them - or
> even at the same time.
>
> +
> 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to