Checking for Empty vs. Checking for Null
Written by Eric Smith, Northstar Computer Systems LLC
Depending on the database you're using, checking a field value may involve checking it against an empty string (two double quote characters together) or against Null using the IsNull function. For numeric values, you almost always need to check them against Null and not an empty string or zero. An easy way to test if a value is Null is to just print the value of the IsNull function in the page (or a comment). That way you can tell very quickly what is going on in your application.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 5/1/2000
|