problem trying to change approved field

hello there!
i seem to have a problem when trying to change the approved field in #_profiler from 1 to 0..

my code looks like that:
******************************************************
$zero=0;

$query="UPDATE #_comprofiler SET approved ='$zero' WHERE id='$userId'";

$database->setQuery($query);
$result=$database->query();
*****************************************************
(aprroved field is tinyINT(4))
the query raises an ERROR for some reason.. does anyone have a clue WHY? thanx in advance!

[mod note: moved out of CBSubs area as this has nothing to do with CBSubs]

Can't really debug your script, but it appears that the #_ needs to be #__ (2 underscores).