Table: episode_data_34
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date
production_code

Question: Name who wrote the episode directed by patrick duffy airing on november 7, 1997
SQL: SELECT "written_by" FROM episode_data_34 WHERE "directed_by" = 'Patrick Duffy' AND "original_air_date" = 'November 7, 1997'