Tricks and tips

From OpenFlyers Documentation
Revision as of 18:53, 12 August 2024 by imported>Claratte (Text replacement - "<xml>" to "<syntaxhighlight lang="xml">")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

SQL

Permut two rows according to their id

Goal: permut two rows with id=a and id=b using only one query

<syntaxhighlight lang="sql">UPDATE some_table SET id = a + ABS(id - b) WHERE order_num in (a , b)</sql>

XSLT

Permit php function call

<syntaxhighlight lang="xml"> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

 xmlns:xhtml="http://www.w3.org/1999/xhtml"
 version="1.0" 
 xmlns:php="http://php.net/xsl"
 exclude-result-prefixes="xhtml php">

</xml>

Do not forget exclude-result-prefixes="php" otherwise you will have xmlns:php attribute in your root tag!

then:

<syntaxhighlight lang="xml"><xsl:value-of select="php:functionString('phpFunctionName', //something/forexample)"/></xml>