You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by "Jeremy Quinn (JIRA)" <ji...@apache.org> on 2005/11/03 13:10:00 UTC

[jira] Closed: (COCOON-1594) SQLTransformer swallowing whitespace on substitute-value

     [ http://issues.apache.org/jira/browse/COCOON-1594?page=all ]
     
Jeremy Quinn closed COCOON-1594:
--------------------------------

    Resolution: Fixed

updated SQLTransformer and TextRecorder to not strip spaces from the SQL Query

> SQLTransformer swallowing whitespace on substitute-value
> --------------------------------------------------------
>
>          Key: COCOON-1594
>          URL: http://issues.apache.org/jira/browse/COCOON-1594
>      Project: Cocoon
>         Type: Bug
>   Components: Blocks: Databases
>     Versions: 2.1.8-dev (Current SVN)
>  Environment: Operating System: other
> Platform: Macintosh
>     Reporter: andrew
>     Assignee: Cocoon Developers Team
>      Fix For: 2.1.8-dev (Current SVN)
>  Attachments: example.xmap, param-bug.xml
>
> The following code will fail:
> <sql:query>
>   SELECT id, name, description from department
>   LIMIT <substitute-value sql:name="start"/>,<substitute-value sql:name="count"/>
> </sql:query>
> After the values are substituted, the output is:
>   SELECT id, name, description from department
>   LIMITn,m
> ... instead of 
>   SELECT id, name, description from department
>   LIMIT n,m

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


Re: [jira] Closed: (COCOON-1594) SQLTransformer swallowing whitespace on substitute-value

Posted by Vadim Gritsenko <va...@reverycodes.com>.
Jeremy Quinn (JIRA) wrote:
>      [ http://issues.apache.org/jira/browse/COCOON-1594?page=all ]
>      
> Jeremy Quinn closed COCOON-1594:
> --------------------------------
> 
>     Resolution: Fixed
> 
> updated SQLTransformer and TextRecorder to not strip spaces from the SQL Query

Is there a sample in databases block to verify the fix? It would be good to have 
one if it's not there...

Vadim