<!--
$trigger_1
$trigger_2
- //-->
+ //-->
</script>
|;
my ($self, $dbh, $id) = @_;
my $query = qq|SELECT c.*
- FROM contacts c
+ FROM contacts c
WHERE cp_id=$id|;
$sth = $dbh->prepare($query);
$sth->execute || $self->dberror($query);
my ($self, $dbh, $id) = @_;
- my $query = qq|SELECT c.cp_id, c.cp_cv_id, c.cp_name, c.cp_givenname
- FROM contacts c
+ my $query = qq|SELECT c.cp_id, c.cp_cv_id, c.cp_name, c.cp_givenname
+ FROM contacts c
WHERE cp_cv_id=$id|;
my $sth = $dbh->prepare($query);
$sth->execute || $self->dberror($query);
$where = "quotation = '1'";
}
- my $query = qq|SELECT id FROM $arap
+ my $query = qq|SELECT id FROM $arap
WHERE id IN (SELECT MAX(id) FROM $arap
WHERE $where
AND ${table}_id > 0)|;
}
1;
-