gusty Posted April 24, 2006 Share Posted April 24, 2006 Hi,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.Thanks,Gusty. Quote Link to comment Share on other sites More sharing options...
wisewood Posted April 24, 2006 Share Posted April 24, 2006 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. Quote Link to comment Share on other sites More sharing options...
gusty Posted April 24, 2006 Author Share Posted April 24, 2006 That's it. Thanks man. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.