sub Get_House_Security_Status { my ($self)= @_; $self->{House_Security_Status} = $self->Sql_Query("select * from pluto_security.ModeChange order by psc_mod DESC limit 0,1",'EK_HouseMode'); return $self->{House_Security_Status}; } sub Get_House_Security_Status1 { my ($self)= @_; $self->{House_Security_Status} = $self->Sql_Query_New("select EK_HouseMode from pluto_security.ModeChange order by psc_mod DESC limit 0,1"); } sub Sql_Query { my ($self, $sql_statement, $sql_field)= @_; my $statement = $self->{SQL_Connector}->prepare($sql_statement); $statement->execute(); return $statement->fetchrow_hashref()->{$sql_field}; } sub Sql_Query_New { my ($self, $sql_statement)= @_; my $statement = $self->{SQL_Connector}->prepare($sql_statement); $statement->execute(); return $statement->fetchrow_hashref(); } my $Security_Status = $LMCE->Get_House_Security_Status(); my $Security_Status1 = $LMCE->Get_House_Security_Status1(); DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0x84195cc)' at line 1 at LMCE_Connector.pm line 218.