Added text field to database. New entries not equal to "" ???

  • Thread starter Thread starter Noozer
  • Start date Start date
N

Noozer

Hi!

I'm accessing an MS Access database from an ASP server.

I just added a new text column (field) to one of my tables. I have not added
any data to this new field in any of the rows.

I read the field in and compare it to "" and it's coming up as false.

How do identify the empty fields?

'ASP code - Never produces "Blank"
if rsSet("region") = "" then response.write "Blank" else response.write
rsSet("region")
 
Try

If IsNull (rsSet("region")) Then Response.Write "Null" Else Response.Write
rsSet("region")

Alan
 
And there are sometimes occasions when it could be a Null, or it could be a
blank. If you want to check for both at once, use:

If Len(rsSet("region") & "") = 0 Then Response.Write "Nothing" Else
Response.Write rsSet("region")
 
Back
Top