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: Chuck Hill <email@hidden>
- Date: Wed, 21 Feb 2007 15:08:59 -0800
Just a guess from long years of bitter experience: it probably
changed the time zone.
Chuck
On Feb 21, 2007, at 3:07 PM, James Cicenia wrote:
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:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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