On 13 May, 08:23, Willem Bogaerts <w.bogae...@kratz.nl> wrote:
> Captain Paralytic wrote:
> > On 9 May, 14:35, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> >> The following from the manual works fine:
> >> SELECT MAKEDATE(2001,365), MAKEDATE(2004,365);
>
> >> However:
> >> SELECT MAKEDATE(2001,365), MAKEDATE(2004,365) FROM A;
>
> >> Gives the error:
> >> #1064 - You have an error in your SQL syntax; check the manual that
> >> corresponds to your MySQL server version for the right syntax to use
> >> near '( 2001 , 365 ) , MAKEDATE ( 2004 , 365 ) FROM A LIMIT 0, 30'
> >> at line 1
>
> >> This is on 4.1.22
>
> >> What am I doing wrong?
>
> > Must be a version bug, works fine in v5
>
> No, it is a server "mode" setting. Note that there is a space character
> between the function name and the opening parenthesis.
>
> So, to the Original Poster: do not use whitespace between the function
> names and their parameter list.
>
> Best regards,
> --
> Willem Bogaerts
>
> Application smith
> Kratz B.V.http://www.kratz.nl/

Note to Willem. You are wrong. The error message is displayed with a
space, but the query (as pasted at the top of the post) has NO space.