[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]Ninja[/eluser]
I cant seem to get not or '!=" to work everything works fine for including but never for excluding
here are two diff attempts at a foreach loop that is populated from the database but needs to populate excluding companies that are already clients. Please help.

Code:

$client = new Client();
            $client->get('id');    
                
            foreach ($client->all as $entry)
            {
                $clientID = $entry->company_id;
                
                $comp = new Company();
                
                $comp->where_not_in('id', $clientID)->get();
                foreach($comp->all as $entry)
                {
                $data['comp'][$entry->id] = $entry->companyname;
                }
            }

I tried the same thing using '!='

Code:

$comp->where('id !=', $clientID)->get();

When i remove the not or the != it selects all existing clients but why cant i exclude all existing clients? I dont understand.