/**
* Load a RoleModule from PK Info
* @param integer $intRoleId
* @param integer $intModuleId
* @return RoleModule
*/
public static function LoadByRoleIdModuleId($intRoleId, $intModuleId)
{
// Call to ArrayQueryHelper to Get Database Object and Get SQL Clauses
RoleModule::QueryHelper($objDatabase);
// Properly Escape All Input Parameters using Database->SqlVariable()
$intRoleId = $objDatabase->SqlVariable($intRoleId);
$intModuleId = $objDatabase->SqlVariable($intModuleId);
// Setup the SQL Query
$strQuery = sprintf('
SELECT
`role_module_id`,
`role_id`,
`module_id`,
`access_flag`,
`created_by`,
`creation_date`,
`modified_by`,
`modified_date`
FROM
`role_module`
WHERE
`role_id` = %s
AND module_id = %s', $intRoleId, $intModuleId);
// Perform the Query and Instantiate the Row
$objDbResult = $objDatabase->Query($strQuery);
return RoleModule::InstantiateDbRow($objDbResult->GetNextRow());
}
