[Zope] Re: Odd problem updating a PostgreSQL DB

Evan Simpson evan@4-am.com
Fri, 13 Sep 2002 16:08:00 -0500


Tim Wilson wrote:
> When I attempt to update an event score, it works perfectly unless one
> of the scores is 0. The SQL update completely ignores the zero value and
> leaves it as NULL. If I go back and enter two non-zero numbers, things
> work fine. If I then go back and change one of the scores to a 0, that
> change is ignored and the old non-zero score remains.

My first reaction to these symptoms is that you've got a Z SQL Method 
with roughly the following in it somewhere:

<dtml-if score>
UPDATE ....
</dtml-if>

Hard to tell without more info, tho.

Cheers,

Evan @ 4-am