C:\gystdoit\JPG\Family_images_Dadside

Friday July 1st, 2016 9:31 AM

SQL Query Output to HTML

Objective:

Conclusion:

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 FAMSIDE(DI.FAM_ID)='F' AND DI.FAM_ID=FAM.FAM_ID ORDER BY 1

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