Calc element returns raw data from dropdown instead label

[Raindog]

Hi!

Then I use in calc element something like:

return '{tablename__dropdownname}';

I get data from {tablename__dropdownname_raw}

 

[felixkat]

Yes because dropdownname is only storing the value and not the actual label data.

You will need to do a subquery

$db =& JFactory::getDBO();
$db->setQuery("SELECT labelname FROM labeltable WHERE id = '{tablename__dropdownname_raw}'");
return $db->loadResult();

Something like that. Let us know how you get on.

 

[Raindog]

Found similar thread: Bug : calc element to return dropdown labels

Calculating "on save" works for me!

 

[cheesegrits]

Yup, I'm working on this one. Trying to find a workable solution to a Catch 22 situation.

-- hugh

 

[felixkat]

All that talk of pigs and eggs!!!

ahh dropdowns.... I'm in dbjoin mode... not sure if that makes any difference though.

Never mind it's working for you and thats the main thing.... maybe I'll have some kip!

 

[Raindog]

Yes, if dropdown from dbjoin ? all working, problem with dropdown element.