I am trying to use a WHERE .. IN selector in a read data set-up so:-
with this function
I can't work out where this error arises.
Is that
Regards
Nick
<?php
$whereConditions= getSelectedReceipts($this->data['loader']);
return $whereConditions;
?>
with this function
function getSelectedReceipts($thisDataRead) {
foreach ($thisDataRead as $aReceipt) {
if (!isset($receiptSelector)) {
$receiptSelector = $aReceipt['mdlPrgReceipts']['idReceipt'];
} else {
$receiptSelector .= ',' . $aReceipt['mdlPrgReceipts']['idReceipt'];
}
}
$receiptSelector='7695,7684'; // This just for test purposes
$selector=['mdlPrgReceipts.idReceipt', "$receiptSelector", 'IN'];
return $selector;
}
I can't work out where this error arises.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B> ' Illegal string offset \'mdlPrgReceipts\' in <b>/hsphere/local/home/pmhu3ad' at line 1
Is that
$selector=['mdlPrgReceipts.idReceipt', "$receiptSelector", 'IN'];
correctt?
Regards
Nick