/**
* Load a RoleModuleAuthorization from PK Info
* @param integer $intRoleModuleAuthorizationId
* @return RoleModuleAuthorization
*/
public static function LoadByRoleModuleIdAuthorizationId($intRoleModuleId, $intAuthorizationId)
{
// Call to ArrayQueryHelper to Get Database Object and Get SQL Clauses
RoleModuleAuthorization::QueryHelper($objDatabase);
// Properly Escape All Input Parameters using Database->SqlVariable()
$intRoleModuleId = $objDatabase->SqlVariable($intRoleModuleId);
$intAuthorizationId = $objDatabase->SqlVariable($intAuthorizationId);
// Setup the SQL Query
$strQuery = sprintf('
SELECT
`role_module_authorization_id`,
`role_module_id`,
`authorization_id`,
`authorization_level_id`,
`created_by`,
`creation_date`,
`modified_by`,
`modified_date`
FROM
`role_module_authorization`
WHERE
`role_module_id` = %s
AND `authorization_id` = %s', $intRoleModuleId, $intAuthorizationId);
// Perform the Query and Instantiate the Row
$objDbResult = $objDatabase->Query($strQuery);
return RoleModuleAuthorization::InstantiateDbRow($objDbResult->GetNextRow());
}
