select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, doc.docTitle from tbl_doc_documents doc with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = doc.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where doc.docid = and doc.ownerid = and doc.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, img.imgTitle docTitle from tbl_img_images img with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = img.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where img.imgid = and img.ownerid = and img.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, img.imgTitle docTitle from tbl_img_images img with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = img.HighResCntID inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where img.imgid = and img.ownerid = and img.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, rep.docTitle from tbl_#listgetat(form.emlSubjectType,2,"|")#_repository rep with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = rep.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where rep.ownerid = and rep.ownertype = and rep.fileid = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, doc.docTitle from tbl_doc_documents doc with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = doc.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where doc.docid = and doc.ownerid = and doc.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, img.imgTitle docTitle from tbl_img_images img with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = img.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where img.imgid = and img.ownerid = and img.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, img.imgTitle docTitle from tbl_img_images img with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = img.HighResCntID inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where img.imgid = and img.ownerid = and img.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, coalesce(nullif(i.comment,''),'Product Photo') as docTitle from tbl_PRD_Images i with (nolock) with (nolock) inner join tbl_FSC_Content fsc with (nolock) on fsc.contentId = i.contentId inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where i.ownerId = and i.ownerType = and i.contentId = #trim(replace(form.emlMessage,chr(13),"
","all"))#

Low Res Download: #htmleditformat(qryFileInfo.docTitle)#

High Res Download: #htmleditformat(qryFileInfoHires.docTitle)# Download: #htmleditformat(qryFileInfo.docTitle)# Download: #htmleditformat(qryFileInfo.docTitle)#