Re: How to check an empty recordset?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 07:31:57 -0400

"Sebastian Hort" <Sebastian.Hort@de.bosch.com> wrote in message news:clt9h4$2f1$1@ns2.fe.internet.bosch.com...
> If the database returns an NULLvalue, how can i check this?
>
> I tried to check at objfield="" or NULL but it doesn`t work.
>
> Any hints? thx
>
>

Try the IsNull() Function.

If you know the field is a string type, you can simply append an empty string to the field value => rs(0).Value & "" 

-- 
Al Reid
How will I know when I get there...
If I don't know where I'm going?

Relevant Pages

  • Re: Stupid question
    ... thx in advance. ... #1: There is some sort of an obfuscated 'C' contest, ... Tks for the hints. ...
    (comp.lang.c)
  • Re: Looking for an executable or script to pipe syslog message to sendmail
    ... Thx for the hints ... ... sendmail ...
    (comp.unix.bsd.freebsd.misc)
  • RE: Drwtsn32.exe and drwtsn.exe
    ... > Any hints will be appreciated ... >> It seems that it crashed the icq, and then I need to reboot. ... >> Thx! ...
    (microsoft.public.windowsupdate)
  • Re: Inline IF statement
    ... Works a treat Al. Thx very much. ... You're a very clever, helpful man. ... "Al Reid" wrote: ... > "It ain't what you don't know that gets you into trouble. ...
    (microsoft.public.vb.database.ado)
  • Re: Inline IF statement
    ... I wasn't sure if it was supported in SQL7. ... > Works a treat Al. Thx very much. ... > "Al Reid" wrote: ... >> "It ain't what you don't know that gets you into trouble. ...
    (microsoft.public.vb.database.ado)