CALC - SQL pull a date from another table based on dB join

[grossr]

Almost embarrased to ask this as it's a noon question, but I am a noob


Trying to pull a date from "acquisitions" list into "flock_manager" list using a calc element. (so I can perform some date and other calculations. I'm sure it's a syntax issue. Any help will be appreciated.

From a calc element in the glock_manager table:

$mdate='{flock_manager___acquisition_lookup_raw}';
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery="SELECT hatch_date FROM acquisitions WHERE id = '$mdate'";
$myDb->setQuery($myQuery);
return $myDb;

I receive http 500 error on list when this element is published.

 

[lousyfool]

The culprit is probably your last line: return $myDb;
Here's how to do it, including a more secure query syntax: https://docs.joomla.org/Selecting_data_using_JDatabase

 

[troester]

See also http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#select