Re: count row function
From: Frank <frankbo_at_interaccess.nl>
Date: Tue, 5 Sep 2000 16:00:41 +0200
Message-ID: <8p2uas$gh$1_at_porthos.nl.uu.net>
Date: Tue, 5 Sep 2000 16:00:41 +0200
Message-ID: <8p2uas$gh$1_at_porthos.nl.uu.net>
No pun taken where none intended.
-- Frank Conan as-if.com> <conan_at_<no-spam> schreef in berichtnieuws bd3t5.21070$r4.11120_at_news.indigo.ie...Received on Tue Sep 05 2000 - 16:00:41 CEST
> Hi Frank,
>
> Although I agree with you in relation to the efficency of the code. In
> my original post I was trying to answer the problem Sandy raised I.E. what
> count(*) will return when no rows are matched.
>
> Conan
>
> PS
> Hope this is read in the spirit it was written, my self-defense rather
than
> to have a go at Frank
>
> Frank wrote in message <8p2dk7$j1l$1_at_porthos.nl.uu.net>...
> >Hmmm.
> >
> >Typical inefficient code...
> >The question you are answering is "how many clients", not
> >"Does this one exist"... Credit due to Steven Feuerstein.
> >
> >define a cursor, open it, select.
> >if NO_DATA_FOUND is raised, return 0, else 1
> >
> >Will use (primary key?) index (if available).
> >--
>
>
>