Difference between revisions of "Tricks and tips"

Jump to: navigation, search
(→‎Permut two rows according to their id)
Line 2: Line 2:
 
==Permut two rows according to their id==
 
==Permut two rows according to their id==
 
Goal: permut two rows with id=a and id=b using only one query
 
Goal: permut two rows with id=a and id=b using only one query
−
  UPDATE some_table SET id = a + ABS(id - b) WHERE order_num in (a , b)
+
  <sql>UPDATE some_table SET id = a + ABS(id - b) WHERE order_num in (a , b)</sql>
 +
=XSLT=
 +
==Permit php function call==
 +
<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>
 +
then:
 +
<xml><xsl:value-of select="php:functionString('_tr8', //something/forexample)"/></xml>

Revision as of 17:15, 4 April 2007

SQL

Permut two rows according to their id

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

UPDATE some_table SET id = a + ABS(id - b) WHERE order_num in (a , b)

XSLT

Permit php function call

 
<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">
 

then: 

<xsl:value-of select="php:functionString('_tr8', //something/forexample)"/>