jluis.rodriguez.movistar wrote: i have an xmltype field in mysql, and I'd like to show it with tags. That is, <tag1>Hello </tag1> <tag2>Hello 2 </tag2> and not Hello Hello 2
There is no such field type like XML for mysql.
If you want the browser to show XML-Tags you have 3 possibilities.
1: Install yourself a code highlighter plugin or enable geshi if you don't have joomla 3.3
/extensions/core-enhancements/coding-a-scripts-integration/code-display
Now you need to change the template and put your field inside a <pre> tag like this:
<pre xml:lang="XML">{joodb field|MYXMLTEXTFIELD}</pre>
2: If you have a pro version write yourself a plugin like this.
/components/com_joodb/plugins/printxml.php<?php
defined('_JEXEC') or die('Restricted access');
$output .= htmlentities($item->{$part->parameter[0]});
?>
{joodb printxml|MYXMLTEXTFIELD}
3: Output your XML-File inside a textarea tag<textarea>{joodb field|MYXMLTEXTFIELD}</textarea>