This is a database-issue, not an ASP-one. NULL-values in a database (even in text-fields) are not the same as empty strings! In MS Access, I think there is an option of allowing a text-field to contain empty values (e.g. ""). But its always a good idea to check for NULL. In VBScript: if IsNull(q1) then, in JScript as you did, I think (never used JScript in ASP myself).

This is a database-issue, not an ASP-one. NULL-values in a database (even in text-fields) are not the same as empty strings! In MS Access, I think there is an option of allowing a text-field to contain empty values (e.g. ""). But its always a good idea to check for NULL. In VBScript: if IsNull(q1) then, in JScript as you did, I think (never used JScript in ASP myself).

I'm not positive what your trying to do here but it seems that if you have a chance of a data being an empty string. And this is valid for your application then you should allow zero length fields in your database. Good Luck!!

I'm not positive what your trying to do here but it seems that if you have a chance of a data being an empty string. And this is valid for your application then you should allow zero length fields in your database. Good Luck!!