In my query I want to request some data from a mysql-database.
The Query is something like the following:
select field1, field2
from table
where field3 = :name
The actual query is more complex but that won't change anything for this example.
My Problem is that the name I am search for consits of characters like &,...
When I add the macro (with active debug) to the page and use 'test1 & test2' as Value for name, the debug information shows that the vaule is cut at the special char.
Debug information.
Query: test
Query parameters: [name=test ]
Query execution time: 49 ms
Template parameters: []
How to handle this?
