public static function LoadByPartialNameForClass($strName, $intClassId)
{
$strQuery = sprintf('
SELECT
class_variable.*
FROM
class_variable,
variable
WHERE
class_variable.variable_id = variable.id AND
class_variable.qcodo_class_id = %s AND
SUBSTR(variable.name, 4) = %s
', ClassVariable::GetDatabase()->SqlVariable($intClassId), ClassVariable::GetDatabase()->SqlVariable($strName));
$objResult = ClassVariable::GetDatabase()->Query($strQuery);
if ($objRow = $objResult->GetNextRow()) {
return ClassVariable::InstantiateDbRow($objRow);
}
}
/**
* Deletes all associated ClassProperties
* @return void
*/
public function DeleteAllClassProperties()
{
if (is_null($this->intId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateClassProperty on this unsaved ClassVariable.');
}
// Get the Database Object for this Class
$objDatabase = ClassVariable::GetDatabase();
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`class_property`
WHERE
`class_variable_id` = ' . $objDatabase->SqlVariable($this->intId) . '
');
}