lucfit
New Member
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!
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!