- } else {
- $sth=$dbh->prepare("insert into z3950servers (host,port,db,userid,password,name,checked,rank,opacshow,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')?1:0, $input->param('rank'),
- $input->param('opacshow')?1:0,$input->param('syntax') );
+ }
+ else {
+ $sth=$dbh->prepare(
+ "INSERT INTO z3950servers " .
+ "(host,port,db,userid,password,name,checked,rank,syntax,encoding) " .
+ "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' ),
+ $input->param( 'encoding' ) );