[daisy] [JIRA] Updated: (DSY-354) Several SQL statements in Daisy contain quotes which confuse DB2

[Aaron Digulla (JIRA)]

     [ http://issues.cocoondev.org//browse/DSY-354?page=all ]

Aaron Digulla updated DSY-354:
------------------------------

    Attachment: sql-quotes.patch

Please apply the attached patch to trunk and 1.5. It should work with both.

> Several SQL statements in Daisy contain quotes which confuse DB2
> ----------------------------------------------------------------
>
>          Key: DSY-354
>          URL: http://issues.cocoondev.org//browse/DSY-354
>      Project: Daisy
>         Type: Bug
>   Components: Database support
>     Reporter: Aaron Digulla
>     Priority: Minor
>  Attachments: sql-quotes.patch
>
> There are many SQL statements in the code which look like this:
>     select id from field_types where "name" = ?
> It seems they were introduces to fix a problem with Oracle but don't seem to work. Furthermore, they confuse other databases.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira