Hello
I have the following situation: I have a dbjoin element that when selected shows certain information on another calc element (based on the selection of the dbjoin element). So far no problems there, but what if i need to modify the information of that calc element only in that record? (which exists in another table and is where the calc element gets the information, i would be need to with a dropdown select another option).
I was thinking on using another dbjoin element to do the calculation that my calc element does but its not working i have enabled eval and set the same code on the default field of the dbjoin:
But its not working, any help is appreciated. Regards
I have the following situation: I have a dbjoin element that when selected shows certain information on another calc element (based on the selection of the dbjoin element). So far no problems there, but what if i need to modify the information of that calc element only in that record? (which exists in another table and is where the calc element gets the information, i would be need to with a dropdown select another option).
I was thinking on using another dbjoin element to do the calculation that my calc element does but its not working i have enabled eval and set the same code on the default field of the dbjoin:
Code:
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery
->select('vehiculo_conductor')
->from('mant_trabajadores')
->where('nombre_trabajador =' . $myDb->quote('{ots___conductor_ot}'));
$myDb->setQuery($myQuery);
$patente = $myDb->loadResult();
return $patente;
But its not working, any help is appreciated. Regards