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 - This page was cached on 18 Oct 2018 - 05:55.

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