Difference between revisions of "UnformatSQL"

From Sega Retro

 
Line 1: Line 1:
{{#replace:{{{1|}}}|:qm:|"}}<noinclude>
+
{{#replace:{{#replace:{{{1|}}}|:qm:|"}}|:sqm:|'}}<noinclude>
 
The cargo extension has some trouble with the " character. Rather than fight it, this template converts ":qm" into it after querying. [[:Template:FormatSQL]] handles storage..
 
The cargo extension has some trouble with the " character. Rather than fight it, this template converts ":qm" into it after querying. [[:Template:FormatSQL]] handles storage..
  
Line 5: Line 5:
 
<pre>{{UnformatSQL|James :qm:Buster:qm: Douglas Knockout Boxing}}</pre>
 
<pre>{{UnformatSQL|James :qm:Buster:qm: Douglas Knockout Boxing}}</pre>
 
{{UnformatSQL|James :qm:Buster:qm: Douglas Knockout Boxing}}
 
{{UnformatSQL|James :qm:Buster:qm: Douglas Knockout Boxing}}
 +
 +
<pre>{{UnformatSQL|L:sqm:essential des Achats pour Consoles}}</pre>
 +
{{UnformatSQL|L:sqm:essential des Achats pour Consoles}}
 
[[Category:Templates]]</noinclude>
 
[[Category:Templates]]</noinclude>

Latest revision as of 16:07, 10 May 2022

The cargo extension has some trouble with the " character. Rather than fight it, this template converts ":qm" into it after querying. Template:FormatSQL handles storage..

e.g.

{{UnformatSQL|James :qm:Buster:qm: Douglas Knockout Boxing}}

James "Buster" Douglas Knockout Boxing

{{UnformatSQL|L:sqm:essential des Achats pour Consoles}}

L'essential des Achats pour Consoles