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]

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.

 

[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.