This question about Using an extension: Asked
How to pass a '%' through params?
--
MatthiasFoerster - 23 Apr 2014
I want to use a SQL statement using LIKE:
<!--
* Set v1 = %URLPARAM{"p1" default="E-0001" encode="off"}%
-->
%SQL{database="TEILE" id="viewall"
"SELECT ... FROM ... WHERE TEIL LIKE ?"
params="%v1%"
}%
All worked fine but looking at the results one can find, that all '%' in the value of %v1% must have been replaced by '_'. So calling my topic using "...?p1=E%" does exactly the same job as "...?p1=E_".
Is there a way to use the '%' inside
params
?