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

[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")

[Alan Howard]

Try

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

Alan

"Noozer" <dont.spam@me.here> wrote in message
news:IVmAc.755870$Pk3.730376@pd7tw1no...

> 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")
>
>

[Noozer]

Thanks!

"Alan Howard" <Xalan.howardX@Xparadise.net.nzX> wrote in message
news:ONCUTnKVEHA.2928@tk2msftngp13.phx.gbl...

> Try
>
> If IsNull (rsSet("region")) Then Response.Write "Null" Else Response.Write
> rsSet("region")
>
> Alan
>
> "Noozer" <dont.spam@me.here> wrote in message
> news:IVmAc.755870$Pk3.730376@pd7tw1no...

> > 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")
> >
> >

>
>

[Douglas J. Steele]

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")

--
Doug Steele, Microsoft Access MVP
[url]http://I.Am/DougSteele[/url]
(no e-mails, please!)


"Noozer" <dont.spam@me.here> wrote in message
news:4MnAc.791748$oR5.380643@pd7tw3no...

> Thanks!
>
> "Alan Howard" <Xalan.howardX@Xparadise.net.nzX> wrote in message
> news:ONCUTnKVEHA.2928@tk2msftngp13.phx.gbl...

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

Response.Write

> > rsSet("region")
> >
> > Alan
> >
> > "Noozer" <dont.spam@me.here> wrote in message
> > news:IVmAc.755870$Pk3.730376@pd7tw1no...

> > > 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")
> > >
> > >

> >
> >

>
>