-----Original Message-----

From: George Wu [mailto:GeorgeW@j...]

Sent: 31 May 2000 16:40

To: Rowena

Subject: RE: a question about your book "ASP databases"---one more

question





I am using Access as my back-end database for my application. I often

got frustrated with "Null values" and "zero-length strings". I don't have

problems with understanding their difference. But they often don't work as 

I

expected. For example, suppose I set both the "Required" and

"AllowZeroLength" properties to no and I leave a field blank, then in my 

ASP

file I have a statement like " if

objRS("field1") is null then.....". I got an error like "object needed". 



In addition, when I set the "Required" property to yes and 

"AllowZeroLength"

properties to no, I am supposed not to allow a field to be left blank.

However, I can still leave that field blank.



Do you know why I got above problems? Your help would be greatly

appreciated.



George