sub insertsql { my ($dbh,$table,$data) = @_; my @qm; my @keys; my @values; my $i = -1; foreach my $k (keys %$data) { if (defined($data->{$k})) { $i++; $keys[$i] = $k; $values[$i] = $data->{$k}; $qm[$i] = '?'; } } my $keylist = join(",",@keys); my $qlist = join(",",@qm); my $sqlstatement = "insert into $table ($keylist) values ($qlist) returning id"; my $sth = $dbh->prepare($sqlstatement); $sth->execute(@values) || die $sth->errstr; $sth->finish(); return; } #### insert into crowdtangle (postUrl,crowdtangle_id,statistics,account,dewindowfy_content,expandedLinks,score,description,message,posted,media,subscriberCount,updated,platform,type) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) returning id #### DBD::Pg::st execute failed: ERROR: column "posturl" of relation "crowdtangle" does not exist LINE 1: insert into crowdtangle (postUrl,crowdtangle_id,statistics,a... ^ at c:/perlmodules/SqlSupport.pm line 70.