Query from an external database based on a fabrik element

[lucfit]

Hi,

I created a query that takes data from an external database based on a element inside a fabrik form:

$myDb = FabrikWorker::getDbo(false, 2);
$myQuery = $myDb->getQuery(true);
$myQuery
->select('rowid')
->from('myexternaldatabase')
->where('myexternaldatabasefield = ' . $myDb->quote('{myfabrikform___myelement}'));
$myDb->setQuery($myQuery);
$fieldA = $myDb->loadResult();
return $fieldA;

The query was tested and worked fine on another site but on my new site it doesn't work and gives me the following error:

Call to a member function getQuery() on null

Can anyone kindly tell me what I'm doing wrong?

Thanks!

 

[achartier]

Why not just use the JFactory::getDbo() instead of FabrikWorker.

 

[lucfit]

Hi, thank you for your reply,

the database from which I want to get the data is not under Joomla but it is external

 

[lucfit]

Hi, sorry, now it works. It was another error into the e.mail plugin.

Thank you for your help!