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?

 

QuestionForm edit

Subject Using an extension
Extension SqlPlugin
Version Foswiki 1.1.8
Status Asked
Related Topics
Topic revision: r1 - 23 Apr 2014, MatthiasFoerster
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy