Help for this page

Select Code to Download


  1. or download this
    my $colnum = 21;
    my $sql_placeholders = '(?' . ',?' x $colnum . ')';
    ...
    # generate comma-separated column names and values
    <...>
    $sql_insert_handle->execute($columns,$values);
    
  2. or download this
    DBD::Pg::st execute failed: called with 2 bind variables when 44 are n
    +eeded at C:/Users/user/eclipse-workspace/project1/pgdb.pl line 134.
     at C:/Users/user/eclipse-workspace/project1/pgdb.pl line 134.
        main::ingest_file(undef) called at C:/user/user/eclipse-workspace/
    +project1/pgdb.pl line 76