Hi,
Actually what is being described in the link is my problem.
Yes, I am using breezingforms integrated with content builder. Yes, only the select list populated from the database is not being saved. Below is the php code piece i have on the Before Form advance setting of the form for populating the select list from the database.
$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object
//set the sql query string
$sqlStr = "select concat(rs1.value,' *** ',rs2.value) value, rs1.record id from
(select record,value from z25yx_facileforms_subrecords WHERE element='308') rs1
left outer join
(select record,value from z25yx_facileforms_subrecords WHERE element='309') rs2
on rs1.record = rs2.record";
$db->setQuery($sqlStr);
$rowlist = $db->loadRowList(); //load the result from the query
$selectStr .= "1;--- Choose Job --- ;\n";
//populate the select string
for ($row = 0; $row < count($rowlist ); $row++)
{
$selectStr .= "0;".$rowlist[$row][0].";".$rowlist[$row][1]."\n";
}
function ff_setSelectList($name, $value)
{
global $ff_processor;
for ($r = 0; $r < $ff_processor->rowcount; $r++)
{
$row =& $ff_processor->rows[$r];
if ($row->name==$name)
$row->data2 = $value;
unset($row);
} // for
} // ff_setSelectList
ff_setSelectList('job', $selectStr);