Hello Pedro,
>MySQL version is 5.0.19. Runs in Win. XP pack 2. I put sql in command line
and i
> try using jdbc.
>The code:
>SELECT mfn,COALESCE (user_id,0)
> FROM hits WHERE mfn =1;
Although it sounds silly, remove the space between COALESCE and the "("
That should do the trick.
Martijn T
>
> -Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, 24 April 2006 7:47 PM
> To: mysql@lists.mysql.com
> Subject: problem with coalesce function
>
> When I use coalesce function
, 24 April 2006 7:47 PM
To: mysql@lists.mysql.com
Subject: problem with coalesce function
When I use coalesce function I receive this error:
"FUNCTION sirius.coalesce does not exist". sirius is the name of db. Can someone
help me with t
>When I use coalesce function I receive this error:
>
>"FUNCTION sirius.coalesce does not exist". sirius is the name of db. Can
someone
>help me with this error
Sure: use functions that exist.
Now, if you want a better answer, try asking a better question.
Showing us the code, for example, wou
When I use coalesce function I receive this error:
"FUNCTION sirius.coalesce does not exist". sirius is the name of db. Can someone
help me with this error
Thanks,
Pedro
___
O SAPO já está livre de vírus com a Panda Software, fique