Help for this page

Select Code to Download


  1. or download this
    # flakey
    my $sth = $dbh->prepare_cached(<<SQL);
    ...
    SQL
    $sth->bind_param(1, $q->param('id'), SQL_INTEGER);
    $sth->execute;
    
  2. or download this
    # functional
    my $sth = $dbh->prepare_cached(<<SQL);
    ...
        WHERE id = ?
    SQL
    $sth->execute( $q->param('id') );