Hi,
Just noticed a problem when Modifying links on on the user side. I've been using INT and Decimal for numeric fields for some time. Now I'm getting the following error message when INT/Decimal fields are left blank by users making mods....
Field Name can not contain the value ''
These numeric fields are set to "NULL" in the admin and I Re-Sync with changes. I found that when the original records were created in those fields different values were stored. Using MySQLMan I can see that my INT/Decimal fields that were left blank are now saved as "0" instead of NULL. No Default values used either. The error arises when trying to modify a link on the user side. It doesn't seem to want to save an empty field with "0" there and spits out that error message. The only way I've been able to get around this is switch the numeric fields to VARCHAR. I tried the different numeric file types with the same problem. Is there another column type I could use so users can modify input prices, ratings, ect so I still search on them???
Anyone else notice this? Why would new INT types save blank fields as NULL and new fields as "0"
Why would some INT fields save "0" and other save NULL?
Hopefully that make since and someone may know this issue I'm referring to.
Just noticed a problem when Modifying links on on the user side. I've been using INT and Decimal for numeric fields for some time. Now I'm getting the following error message when INT/Decimal fields are left blank by users making mods....
Field Name can not contain the value ''
These numeric fields are set to "NULL" in the admin and I Re-Sync with changes. I found that when the original records were created in those fields different values were stored. Using MySQLMan I can see that my INT/Decimal fields that were left blank are now saved as "0" instead of NULL. No Default values used either. The error arises when trying to modify a link on the user side. It doesn't seem to want to save an empty field with "0" there and spits out that error message. The only way I've been able to get around this is switch the numeric fields to VARCHAR. I tried the different numeric file types with the same problem. Is there another column type I could use so users can modify input prices, ratings, ect so I still search on them???
Anyone else notice this? Why would new INT types save blank fields as NULL and new fields as "0"
Why would some INT fields save "0" and other save NULL?
Hopefully that make since and someone may know this issue I'm referring to.