/**
 *
 * This function checks if a value exsists for a cck field
 *
 * @param string $content_type_name         machine readable name of the content type
 *
 * @param string $field_name                machine readable name of field
 *
 * @param mixed $field_value                value that needs to be checked
 *
 * @return boolean                          true if present, else false
 *
 */
function is_cck_field_value_present($content_type_name, $field_name, $field_value) {

  // first lets get field details
$qs =<<<EOD
SELECT *
FROM {node_field}
WHERE field_name = '%s'
EOD;

 $result = db_query($qs, "field_{$field_name}");

 while($row = db_fetch_object($result)) {
   $field_type = $row->type;         // we need the type to determine the mysql type
   $inline_value = $row->db_storage; // inline values are those which are stored in the content type table
 }

 // the where param type for mysql comparisions
 $where_param_type = "";
 switch($field_type) {
 case "text":
   $where_param_type = "'%s'";
   break;
 case "number_integer":
   $where_param_type = "%d";
   break;
 case "number_decimal":
   $where_param_type = "%f";
   break;
 }


 if ($inline_value) {
$qs =<<<EOD
SELECT count(*)
FROM {content_type_{$content_type_name}}
WHERE field_{$field_name}_value = {$where_param_type}
EOD;
 }
 else {
$qs =<<<EOD
SELECT count(*)
FROM {node} n, {content_field_{$field_name}} cf
WHERE n.nid = cf.nid AND n.vid = cf.vid AND cf.field_{$field_name}_value = {$where_param_type} AND n.type = '%s'
EOD;
 }

 $result = db_result(db_query($qs, $field_value, $content_type_name));
 return ($result ? true:false);

} // end of function is_cck_field_value_present