However the " leads me to belive that there is a double quote in $var. Try printing $query to see what's in it.

If that's the case, do something like this before the my $query... thing.

$var = $dbh->quote($var);
[download]