/** * 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()); }