my $cmd = "insert into latlong (post_id,some_text,geom) VALUES (?, ?, ?);" my $query_handle = $dbh->prepare($cmd); $query_handle->execute($post_id, $some_text, "ST_GeomFromText('POINT($LongDEC $LatDEC)', 4326)");