C:\gystdoit\JPG\Family_images_linked_to_portrait.htm

Friday July 1st, 2016 9:23 AM

SQL Query Output to HTML

Objective:

Conclusion:

Albanoski_7061 ">Albanoski_7061	Albanoski_706 ">Albanoski_706	Bingham_15 ">Bingham_15	Bingham_30 ">Bingham_30	Bingham_60 ">Bingham_60	Blackiston_3091 ">Blackiston_3091
Brock_20812 ">Brock_20812	Cavanaugh_4031 ">Cavanaugh_4031	Cavanaugh_403 ">Cavanaugh_403	Charney_7083 ">Charney_7083	Charney_708 ">Charney_708	Davis_2081 ">Davis_2081
Douglas_7034 ">Douglas_7034	Dunn_12 ">Dunn_12	Dunn_3041 ">Dunn_3041	Dunn_3043 ">Dunn_3043	Dunn_304 ">Dunn_304	Dunn_3071 ">Dunn_3071
Dunn_3072 ">Dunn_3072	Dunn_307 ">Dunn_307	Dunn_3 ">Dunn_3	Dunn_607 ">Dunn_607	Dunn_6 ">Dunn_6	Finnerty_2091 ">Finnerty_2091
Finnerty_2092 ">Finnerty_2092	Finnerty_209 ">Finnerty_209	Fitzgerald_4032 ">Fitzgerald_4032	Foley_405 ">Foley_405	Gaffey_1012 ">Gaffey_1012	Gaffey_101 ">Gaffey_101
Gaffey_103 ">Gaffey_103	Gaffey_1041 ">Gaffey_1041	Gaffey_1043 ">Gaffey_1043	Gaffey_1044 ">Gaffey_1044	Gaffey_104 ">Gaffey_104	Gaffey_105 ">Gaffey_105
Gaffey_1 ">Gaffey_1	Gaffey_206 ">Gaffey_206	Gaffey_20821 ">Gaffey_20821	Gaffey_2082 ">Gaffey_2082	Gaffey_208 ">Gaffey_208	Gaffey_2 ">Gaffey_2
Gaffey_4 ">Gaffey_4	Gaffey_8 ">Gaffey_8	Gardener_3081 ">Gardener_3081	Grant_40322 ">Grant_40322	Grant_4043 ">Grant_4043	Haley_14 ">Haley_14
Haley_28 ">Haley_28	Haley_7021 ">Haley_7021	Haley_70231 ">Haley_70231	Haley_7023 ">Haley_7023	Haley_702 ">Haley_702	Haley_7031 ">Haley_7031
Haley_703 ">Haley_703	Haley_704 ">Haley_704	Haley_70511 ">Haley_70511	Haley_70512 ">Haley_70512	Haley_7051 ">Haley_7051	Haley_705 ">Haley_705
Haley_710 ">Haley_710	Haley_7 ">Haley_7	Hall_1022 ">Hall_1022	Hall_102 ">Hall_102	King_207 ">King_207	King_71011 ">King_71011
Lanigan_6011 ">Lanigan_6011	Lanigan_601 ">Lanigan_601	Leach_2051 ">Leach_2051	Leach_205 ">Leach_205	Lindsey_2031 ">Lindsey_2031	Lindsey_203 ">Lindsey_203
Link_1011 ">Link_1011	Long_606 ">Long_606	Mack_30441 ">Mack_30441	Mack_3044 ">Mack_3044	Mccoy_3092 ">Mccoy_3092	Mccoy_309 ">Mccoy_309
Mclearn_20813 ">Mclearn_20813	Mike_70233 ">Mike_70233	Milliman_1021 ">Milliman_1021	Moore_3045 ">Moore_3045	Mulvaney_202 ">Mulvaney_202	Mulvaney_5 ">Mulvaney_5
Perkins_2071 ">Perkins_2071	Pickard_70423 ">Pickard_70423	Pickard_7042 ">Pickard_7042	Richards_61 ">Richards_61	Salisbury_3042 ">Salisbury_3042	Schafer_4042 ">Schafer_4042
Schafer_404 ">Schafer_404	Sean_70232 ">Sean_70232	Sharpe_7101 ">Sharpe_7101	Simpson_70811 ">Simpson_70811	Simpson_7081 ">Simpson_7081	Spring_308 ">Spring_308
Sturtevant_608 ">Sturtevant_608	Taylor_70741 ">Taylor_70741	Taylor_7074 ">Taylor_7074	Testa_3073 ">Testa_3073	Updyke_2083 ">Updyke_2083	Wagner_20811 ">Wagner_20811
Washburn_7071 ">Washburn_7071	Washburn_7072 ">Washburn_7072	Washburn_7073 ">Washburn_7073	Washburn_707 ">Washburn_707	Wells_13 ">Wells_13

Albanoski_7061">

SELECT '<a href="'+ALLTRIM(padr(FAMFILEID(DI.FAM_ID),50,' '))+'_portrait.svg">'+ALLTRIM(padr(FAMFILEID(DI.FAM_ID),50,' '))+'</a>' , THUMBNAIL(DI.FILE_NAME) FROM C:\JPG\DIRFAM.DBF DI, C:\JPG\FAMILY.DBF FAM where DI.FILE_EXT='jpg' AND ! DI.FAM_ID=0 AND DI.FAM_ID=FAM.FAM_ID ORDER BY 1

SOURCE
URL:	,
Organization:
Date Acquired:	Friday July 1st, 2016 9:23 AM
Prepared By:	John Gaffey
Last Updated:	Friday July 1st, 2016 9:23 AM