ah, maybe you have to change your function...
Code:
my $dmn_egw = @$dmn_data[21];
here you already have your yes/no, so you don't need the new sql... just continue with:
Code:
if ($dmn_egw eq 'yes') {
mkdir ('/tmp/egw_ctrl1',0777) ;
} elsif ($dmn_egw eq 'no') {
mkdir ('/tmp/egw_ctrl2', 0777) ;
}
if this still does nothing you rather make
Code:
...
my $sql = "select domain_egw from domain where domain_name = $dmn_name";
($rs, $rdata) = doSQL($sql);
if ($rdata[0][0] eq 'yes') {
mkdir ('/tmp/egw_ctrl1',0777) ;
} elsif ($rdata[0][0] eq 'no') {
mkdir ('/tmp/egw_ctrl2', 0777) ;
}
$sql will never be 'yes' or 'no' because it's "SELECT..."....
the result $rdata is a array[row][col] each starting at 0...
/J