Re: What is the trick to debug SQL?
Re: What is the trick to debug SQL?
- Subject: Re: What is the trick to debug SQL?
- From: James Cicenia <email@hidden>
- Date: Wed, 21 Feb 2007 17:07:18 -0600
It was my DATETIME column.
Evidently a user with Navicat exported and re-imported the data. This
somehow affected the datetime column
and from that point onward it would not update. Even after rebooting
etc.
Have no clue why that caused it but it did.
- James
On Feb 21, 2007, at 12:35 PM, Art Isbell wrote:
On Feb 21, 2007, at 8:02 AM, James Cicenia wrote:
This is me testing and it happens? I don't have anyone else in the
system to
lock the record....
If any of the attributes that you are using for locking is a
floating point or timestamp data type, rounding errors could result
in the fetched value not matching the local value. Also, if any of
the string attributes used for locking might have trailing space
characters, these could be stripped somewhere along the line which
would also cause a mismatch. You might need to eliminate floating
point and timestamp locking attributes or you might need to
explicitly strip trailing space characters from all string
attribute values.
Aloha,
Art
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40jimijon.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden