Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#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

    • priority: 5 --> 2
     
  • Damian Parker
    Damian Parker
    2004-08-26

    • status: open --> closed-out-of-date