my $sth = $dbh->prepare('insert into test(field1) values(?)');
$sth->execute($text);