Difference between revisions of "FormatSQL"
From Sega Retro
m (Text replacement - "Category:Sega Retro templates" to "Category:Templates") |
|||
| 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 it to ":qm" before storing, with the view of using [[:Template:UnformatSQL]] after querying. | + | The cargo extension has some trouble with the " character. Rather than fight it, this template converts it to ":qm:" before storing, with the view of using [[:Template:UnformatSQL]] after querying. |
e.g. | e.g. | ||
<pre>{{FormatSQL|James "Buster" Douglas Knockout Boxing}}</pre> | <pre>{{FormatSQL|James "Buster" Douglas Knockout Boxing}}</pre> | ||
{{FormatSQL|James "Buster" Douglas Knockout Boxing}} | {{FormatSQL|James "Buster" Douglas Knockout Boxing}} | ||
| + | |||
| + | <pre>{{FormatSQL|L'essential des Achats pour Consoles}}</pre> | ||
| + | {{FormatSQL|L'essential des Achats pour Consoles}} | ||
[[Category:Templates]]</noinclude> | [[Category:Templates]]</noinclude> | ||
Latest revision as of 16:06, 10 May 2022
The cargo extension has some trouble with the " character. Rather than fight it, this template converts it to ":qm:" before storing, with the view of using Template:UnformatSQL after querying.
e.g.
{{FormatSQL|James "Buster" Douglas Knockout Boxing}}
James :qm:Buster:qm: Douglas Knockout Boxing
{{FormatSQL|L'essential des Achats pour Consoles}}
L:sqm:essential des Achats pour Consoles