Im also curious for the answer why. We got a similar issue. Seems like those values are cached somehow so clear cache all made the values visible that are in the database. Cck seems to turn 0 into null even for integers. We did not search to much further on it because clearing the cache solved the issue. Hans www.koba.be 2010/1/3, VJ <vijaiprao@gmail.com>:
Hi, I have updated a field in a cck table (content_type_resource) using sql. The update executed successfully. However, upon accessing the node via a web browser, the updated values seem to get replaced by NULL. Anyone notice this behavior in Drupal 6 before?
-v
-- Hans Rossel KOBA Webdesign bvba Beukenlaan 56 9051 Gent (Sint-Denijs-Westrem) Belgium BTW 0817.931.516 +32.9.334.52.60 +32.472.79.32.16 www.koba.be info@koba.be