Jump to content


This topic is now archived and is closed to further replies.


Updating Field to Null

Recommended Posts


I'm trying to change a field in my sql table back to NULL. (default). It's if the user enters info to the wrong row and wants to change back to NULL. The code I use changes the field to 0 when executed. I've searched for this here and online and I'm not sure what's happening. I could use 0 but curious to what's happening. Here's my code.

$delSQL = sprintf("UPDATE table SET field1='NULL' WHERE field2=%s",
GetSQLValueString($vr, "text"));

I would appreciate any pointers you can give me.

Share this post

Link to post
Share on other sites
is the field that you're trying to reset to "NULL" a numeric field such as an integer? If it expects an integer, and you tell it to use NULL, it will use 0 instead.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.