ID1 > 66
ID2 < 7
ID3 between 6 10
####
while ($line=){
@params = split(/\s/,$line);
$id = shift @params;
$op = shift @params;
$parameters.= $id."|";
$operators .= $op."|";
if ($op eq 'between'){
$v = shift @params;
$values1 .= $v.'|';
if ($.>1){
$v2 = shift @params;
$values2 .= '|'.$v2;
}elsif($.==1){
$v2 = shift @params;
$values2 .= $v2.'|';
}
$values2 .='|';
$between = 1;
}
foreach $value (@params){
$values .= $value."|";
}
unless ($between){
for (@params){
$v2.='|';
}
}
}
####
$parameters = ID1|ID2|ID3
$operators = >|<|between
$values1 = 66|7|10
$values2 = 10|