- } else {
- $sth=$dbh->prepare("insert into z3950servers (host,port,db,userid,password,name,checked,rank,syntax) values (?, ?, ?, ?, ?, ?, ?, ?,?)");
- $sth->execute($input->param('host'),
- $input->param('port'),
- $input->param('db'),
- $input->param('userid'),
- $input->param('password'),
- $input->param('searchfield'),
- $input->param('checked'),
- $input->param('rank'),
- $input->param('syntax'),
- );
+ }
+ else {
+ $sth=$dbh->prepare(
+ "INSERT INTO z3950servers " .
+ "(host,port,db,userid,password,name,checked,rank,syntax,encoding,timeout) " .
+ "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" );
+ $sth->execute(
+ $input->param( 'host' ),
+ $input->param( 'port' ),
+ $input->param( 'db' ),
+ $input->param( 'userid' ),
+ $input->param( 'password' ),
+ $input->param( 'searchfield' ),
+ $checked,
+ $input->param( 'rank' ),
+ $input->param( 'syntax' ),
+ $input->param( 'timeout' ),
+ $input->param( 'encoding' ) );