Hi,

Im using a lookup function to get a relevant object by ID like;

$val=(search string as integer);

$sqlQuery = new SQLQuery("COUNT(myObject.ID)","myObject","ID=".intval($val));
if($sqlQuery->execute()->value()){
return DataObject::get_by_id('myObject', intval($val));
}else{
Director::redirect('/myObjectSearchPage/');
}

but instead of being redirected the function is returning null and I get;

[Notice] Trying to get property of non-object

Any ideas?

EDIT: misread the question, let me try again:

Why are you running an SQL Count query? The following makes a lot more sense:

if($object = DataObject::get_by_id('myObject', intval($val)))
	return $object;
else
	Director::redirect('/myObjectSearchPage/'); 

The error is probably being caused in whatever method is calling the above code. It should check that a valid object is returned. Note that Director::redirect doesn't halt execution - so you still need to check if the method has returned a valid object before doing something with it.