Hi Marc,
> I'm using Roxen 5.0.0
>
> I might have found a bug in the emit sql plugin.
>
> I use the folloming query:
>
> <emit source="sql" query="SELECT replace(name,' ',' ') as name
> from
> iitems;
> " >
> &_.name;
> </emit>
>
>
> The database gets!:
>
> SELECT replace(name,' ',' ') as name from iitems;
How do you determine that the database gets that query?
> How is this possible?
As far as I can tell the is transmitted as a non-breaking space
(ASCII 160) in the query and the resulting variable seems to contain a
non-breaking space as well. Try this and you should see that it is in
fact correct:
<emit source="sql" query="SELECT REPLACE(name, ' ', ' ') AS
name FROM ..." host="...">
<p><replace from=" " to="#">&_.name;</replace></p>
</emit>
Cheers,
-- Jonas Walldén
<jonasw[at]roxen.com>
|