#4 % in SQL statement errors the renderer

open
nobody
None
5
2007-01-17
2007-01-17
Anonymous
No

i installed myodbc so i can connect to a mysql database. It works great for everything but wildcards.

my line in start.xml

<querysource>
<name>test</name>
<sql>SELECT * FROM devices WHERE type NOT LIKE "%7960%"</sql>
</querysource>

causes the renderer to error, and not create the report. If i take out the % (wildcard) the report runs.

Discussion