Hi Spock,

You code looks pretty good, but there are a couple of problems I can see:

1 - your last line will create a PHP error because you missed the final " character.

You need:

    return "Orange";

2 - as you already know, $mySobi will not be populated at this stage of the page loading process. So you need to get the ID value from another source - probably the URL.

You could try:

$mysobiID = JRequest::getVar("sobi2Id");
if ( $mysobiID != "") {
  // ... the rest of your code here...
}

3 - is the name of your template folder definitely "Orange"? Check the actual name of the folder that your template is in. It may be "orange" instead of "Orange". Joomla template names are case sensitive.

4 - to test the template name thing, try using the following rule (just this single line) in MetaTemplate. If this successfully changes the template, then the name is correct :-)

return "Orange";


Hope that helps,
Stephen

Hi Spock,

I don't know why the data access thing is not working. One thing might be the table prefix... in the recipes above, it's "jos_". However, if your site uses a different prefix, then you'll need to change that. Could that be the reason?

Also, try running this, which might give you some idea of the error that is occurring in the database (if that's what the problem is):

$db =& JFactory::getDBO();
$mysobiID ="1";
$myfieldID = "46"; // id type of field predefined value
$query = "SELECT data_txt FROM #__sobi2_fields_data WHERE itemid = $mysobiID AND fieldid = $myfieldID'";
$db->setQuery($query); 
$template = $db->loadResult();
echo "Template is $template<br>";
echo "database is:<br><pre>" . print_r($db, true) . "</pre>";

This should print out lots of diagnostic info from the database at the top of the page. This will probably completely mess up the formatting of your page, and may even cause page errors depending on your template. But if you're lucky you'll get some diagnostic text.

Regarding SEF URLs: it's a miracle, but the JRequest methods still work with SEF turned on! So my suggestion earlier will definitely still work with SEF turned on.

Cheers,
Stephen