Use getDataObjectSettings() more than 1 times

[Szdnez]

Hello,

is it possible to use method getDataObjectSettings() more than 1 times for the same data object? For example

Code: Select all

$this->getDataObjectSettings( 'issue_settings', 'issue_id', $row['issue_id'], $myData );
$this->getDataObjectSettings( 'article_settings', 'article_id', $row['article_id'], $myData );

The problem is, that both use title in setting_name -> second call of getDataObjectSettings() overrides the data from the first call. Or must I do it by "hand"?

Thanks

[Szdnez]

I wrote a method like this (nearly the same as original one, only one parameter more):

Code: Select all

function getDataObjectSettings( $pTableName, $pIdFieldName, $pIdFieldValue, &$pDataObject, $pSuffixFieldName )
{
   if ( $pIdFieldName !== null )
   {
      $sql = "SELECT * FROM $pTableName WHERE $pIdFieldName = ?";
      $params = array( $pIdFieldValue );
   }
   else
   {
      $sql = "SELECT * FROM $pTableName";
      $params = false;
   }
   $result =& $this->retrieve( $sql, $params );
   
   $suffix = '';
   if ( $pSuffixFieldName !== null )
   {
      $suffix = $pSuffixFieldName . '_';
   }

   while ( !$result->EOF )
   {
      $row = &$result->getRowAssoc( false );
      $pDataObject->setData( $suffix . $row['setting_name'], $this->convertFromDB( $row['setting_value'], $row['setting_type'] ), $row['locale'] );
      unset( $row );
      $result->MoveNext();
   }

   $result->Close();
   unset( $result );
}