Null values in database numerical fields

  • Thread starter Thread starter Trevor Williams
  • Start date Start date
T

Trevor Williams

I have an Access database containing number fields with default values
set to null. There is no data in those fields when uploaded to my
website.

When I use the Database Editor on the website, those fields are
displayed as empty, as expected. When the record is edited all those
fields fill with zeroes even when I have not changed them during the
editing session, i.e. each default null value is automatically
overwritten with zero.

For the application I am using, sports scores, zero and null are not
the same! Zero is "no score" and null is "not yet played".

Working around this by using text fields instead of number fields
gives complications with calculations further down the line.

All suggstions appreciated.

Trevor
 
Hi Trevor.....

Your are doing this in asp or php?????

If so you can use one of the language functions to check for the type of the
data or variable. Using an "If" control structure you can then "force" the
proper entry into the field.

Best to you.....
Tom Gahagan
 
Back
Top