my @states = map {$_->{state}} @$citydata;
.
.
exec_select(sql, @states);