RE: Detecting data collisions (was Re: Preventing data collisions)

2003-11-18 Thread John A. Sullivan III
oid unexpected dropped > connections (I think it defaults to 8 hours). > > -JF > > > -Original Message- > > From: John A. Sullivan III [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, November 18, 2003 12:54 PM > > To: Brian Reichert; [EMAIL PROTECTED] > &

Detecting data collisions (was Re: Preventing data collisions)

2003-11-18 Thread John A. Sullivan III
>> How do I prevent data collision in the following scenario: >> User A and User B are examining the same data (say a customer's >name and address). User A modifies something (say the customer's >phone number) and saves the transaction. User B modifies something >different at the same time. How

Re: Preventing data collisions

2003-11-17 Thread Brian Reichert
On Mon, Nov 17, 2003 at 11:06:39PM -0600, David Dice wrote: > I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find > an answer. > > How do I prevent data collision in the following scenario: > User A and User B are examining the same data (say a customer's name and

Preventing data collisions

2003-11-17 Thread David Dice
I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find an answer. How do I prevent data collision in the following scenario: User A and User B are examining the same data (say a customer's name and address). User A modifies something (say the customer's phone number