Detecting empty or null value?

[jodleren]

Hello all

I tryid to find anything here, but not exactly what I need. My
solution as of now is:

sMine=rsjob.fields(0).value
if sMine & ""="" then sMine="undefined"

Just how should it be properly done?

if smine="" or smine=NULL then ?
The =null does not work :)

What is the right thing then?

WBR
Sonnich

[Bob Barrows]

jodleren wrote:
> Hello all
>
> I tryid to find anything here, but not exactly what I need. My
> solution as of now is:
>
> sMine=rsjob.fields(0).value
> if sMine & ""="" then sMine="undefined"

Nothing is wrong with that. Is it giving you the wrong answer?

>
> Just how should it be properly done?
>
> if smine="" or smine=NULL then ?
> The =null does not work :)
>

vbscript has two ways of testing for null:

if sMine Is Null then

or

if IsNull(sMine) then

Either works.

--
HTH,
Bob Barrows

[rob^_^]

Hi,

Just append a zero length string to convert nulls to zero length strings.
sMine=rsjob.fields(0).value & ""

for string fields. For numeric fields, make sure they do not allow nulls and
that the default binding value is valid.

This also works for asp query parameters and makes coding in asp.net easier.

sValue = request("sValue") & ""

I/O

if not request("sValue") is nothing then
....etc.

Regards.

"jodleren" <son...@hot.ee> wrote in message
news:a5d4bd44-f60b-4817...@z3g2000prd.googlegroups.com...