Prev: Extending Session Timeouts
Next: jquery Flot and a Database
From: rob^_^ on 12 Dec 2009 13:53
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" <sonnich(a)hot.ee> wrote in message
news:a5d4bd44-f60b-4817-82bf-3509c8b69d52(a)z3g2000prd.googlegroups.com...
> 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
>
 | 
Pages: 1
Prev: Extending Session Timeouts
Next: jquery Flot and a Database