Father's / Mother's / Descendents

Family of William F Gaffey & Joanne Dunn

Image Files

William F Gaffey

Joanne Dunn

Descendents

http://www.computerhope.com/msdos.htm#02

http://www.gystdoit.com/famed/listbranch.php?member=3
C:\gystdoit\jpg\family_report.htm

C:\gystdoit\jpg\member_report.htm

SELECT fam_id,surname,father_id, father,mother_id,mother,wed_date,photo from family WHERE fam_id =1;

SELECT fam_id , ind_id , given , married , born, died, male , photo , obit FROM fam_member WHERE ind_id='103.20';

update family set photo=' ' where fam_id = " ";

update fam_member set photo=' ' where ind_id = " ";

update fam_member set married=' ' where ind_id = " ";

update fam_member set obit=' ' where ind_id = " ";

move 'c:\gystdoit\jpg\ ' 'c:\gystdoit\jpg\ '

Putty build_find

Build Unix Find File
Start in - Current Directory Root Named Directory
Files named like
File was created or last modified	more than Days Old less than Days Old	File size in kilobytes	over KB less than KB

Overwrite

William F Gaffey & Joanne Dunn Family Tree

Famiy Tree Member File ID Picklists

putty.exe	Load and Open the Dream Host connection
Server:	ps104003.dreamhostps.com
Port:	22
johgaf1	5XAHH9JY
Hostname:	cd gystdoit.com/famed
Hostname:	mysql.gystdoit.com
Database Name:	familygps
UserName:	gaff
PW:	John_1-30
Login	mysql -u gaff -p -h mysql.gystdoit.com familygps

source

Log into server through putty
putty.exe

Load and Open the Dream Host connection

defined as

Server: ps104003.dreamhostps.com
Port: 22

johgaf1

5XAHH9JY

cd gystdoit.com/famed

mysql -u gaff -p -h mysql.gystdoit.com familygps

prompt

Change to directory where I keep MySQL scripts

cd gystdoit.com/scripts

Log into mySQL database

mysql -u gaff -p -h mysql.gystdoit.com familygps

Run a query

mysql> select count(*) from fam_member;

Run a SQL script

Valid

mysql> source select_family_rowcount.sql;

Family_Member-PickLists.htm

Thursday February 23rd, 2017

Family_Member-PickLists

Objective:

Provide simple means to look up famiy members listed in the William F Gaffey & Joanne Dunn Family Tree by name

Provide access to collection of family image files

Conclusion:

See above.

For errors or additions, contact me This document can simplify assigning GAF compliant filenames to image files and documents associated with a given relative.