in reply to Managing Dynamic SQL

if( $time ) { $sql.= ' AND time = ?'; push @args, $time; } if( $date ) { $sql.= ' AND date = ?'; push @args, $date; } $sth->execute( @args );