Re: testing an overloaded function

My fault for leaving out critical detail. Both functions end up calling a third function that uses the customer id to give a result....When first_name = 'A' and last_name = 'B' are used to come up with the id, two customer id's can show up if 'A' and 'B' are two different customers with the same name.

 Which customer id does the third function use to generate the result? wouldn't this cause a problem?...

"DStevens" <dstevens_at_navidec.com> wrote in message news:3C0FD226.CC0F0EB2_at_navidec.com...
> If you are using a count(*) with first and last name in the where clause
... and
> no group by, you won't get too_many_rows. You will get 1 row.
>
> select count(*) from customers where first_name = 'A' and last_name = 'B';
>
> Will return 0, 1, ... n
>
> I wouldn't return a null, I would always return the count -- the caller
can
> compare = 1, 0, else...
>
> bullseye wrote:
>
> >
>
Received on Thu Dec 06 2001 - 16:48:43 CST