Re: Problem assigning value to empty string

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

If your res_id equals NULL, then the COUNT function simply skips this row. With so little info you provided, I can only drive you to check the ISNULL function if it can be helpful for you.

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx

"Ryan" <Ryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1DA2FA2C-A892-4E04-9D04-90926726B4D7@xxxxxxxxxxxxxxxx
How can I assign the value of zero '0' to the 'empty string' result of the
count() function? Currently I can only count the res.id's that exist, but I
want the count to equal 0, for the one's that don't exist.

Heres a segment of the code I have so far, and it's not working.
...
CASE count(r.res_id)
WHEN '' THEN 0
ELSE count(r.res_id)
END
...

Thank you in advance.

.

Relevant Pages

  • Re: Indexing properties that belong to types
    ... Ryan wrote: ... FROM trades t ... Equals I could understand ... ... But like without wildcard characters? ...
    (comp.databases.oracle.misc)
  • Re: =?iso-8859-1?B?RnJhbudvaXMgVmnodGU=?=
    ... >published the following diagram. ... >The line segment OR is the radius of a circle, ... >figure whose length equals the value of the function at theta. ...
    (sci.math)
  • Re: infinity
    ... > Daryl McCullough said: ... forall A, if A is an initial segment, and A has a size, then ... > If, for all initial segments, the set size equals the largest ... According to Peano, for every member there is always a larger one, so ...
    (sci.math)
  • Re: Who is able to answer these simple questions in ZF-set theory coherently? Not WM!
    ... initial segment of natural numbers that contains x. ... thus: the set N equals the union of all its FIS, ... _infinite_ union of all its FIS's, as the set of all FIS's of N is ...
    (sci.math)