RE: Using a value from one insert for another insert

[Dave Watts]

> But it shows that I might just be done by now if I had just done
> multiple queries to accomplish the task. I guess I could do a cflock
> around them to group'em.

If you want to ensure that all the queries run as a single transaction, use
CFTRANSACTION, not CFLOCK.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---