Using XSL shortcode

Victor,

I have discovered your SQL Shortcode plugin. It is a very useful plugin. Thank you.

I am attempting to duplicate the USER table example that you supplied.

The USER table is returned correctly with the [SQL] shortcode.

[sql]
SELECT ID, display_name, user_login, user_registered, “*******@*******.com” as user_email FROM wp_users
[/sql]

—————————————————

However, I cannot format the table using the [xsl] shortcode as shown in your example.

Instead of the formatted USER table, I end up with the result:

=====================================================================
<table> <xsl:copy-of select=”/table/tr[1]” /> <xsl:for-each select=”/table/tr[position() != 1]”> <tr> <xsl:for-each select=”td”> <xsl:choose> <xsl:when test=”position() = 5?> <td><xsl:value-of select=”.” /></td> </xsl:when> <xsl:otherwise> <xsl:copy-of select=”.” /> </xsl:otherwise> </xsl:choose> </xsl:for-each> </tr> </xsl:for-each> </table>
======================================================================

I wish to be able to return a table with a column containing links to lookup items in another table.

I would appreciate it if you could assist.

Richard Harding

https://ww.wp.xz.cn/plugins/sql-shortcode/