#1051 SQL wiki-plugin error

Unknown
closed-out-of-date
nobody
2
2004-08-26
2003-11-21
Anonymous
No

The SQL wikiplugin always returns a DB sytax error when
trying to perform a select with certain date functions.
Using Mysql 4.0.15, perl-DBD-MySQL-2.1017-3,
perl-5.8.0-88.3, perl-DBI-1.30-1

sample query that will fail:

{SQL(db=>dbDSN)}
select DATE_FORMAT(CURDATE(),'%M %y');
{SQL}

It is the DATE_FORMAT function that causes the syntax error

Discussion

  • Philippe Cloutier

    • priority: 5 --> 2
     
  • Damian Parker

    Damian Parker - 2004-08-26
    • status: open --> closed-out-of-date
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks