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

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

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