select doc.DocTitle title, doc.FileSize, doc.FileExt from tbl_doc_documents doc where doc.ownerid = and doc.fsl_tablecode = and doc.docid = select img.imgTitle title, img.FileSize, img.FileExt from tbl_img_images img where img.ownerid = and img.fsl_tablecode = and img.imgid = select rep.docTitle title, rep.FileSize, rep.FileExt, docURL.ContentPath DocPath, rep.DocDescription description from tbl_#listgetat(url.docType,2,"|")#_repository rep inner join qryContentFullPathLookup docURL on rep.ContentID = docURL.ContentID where rep.ownerid = and rep.ownertype = and rep.fileid = select doc.DocTitle title, doc.FileSize, doc.FileExt from tbl_doc_documents doc where doc.ownerid = and doc.fsl_tablecode = and doc.docid = select img.imgTitle title, img.FileSize, img.FileExt, docURL.ContentPath DocPath, ImgDescription description from tbl_img_images img inner join qryContentFullPathLookup docURL on img.ContentID = docURL.ContentID where img.ownerid = and img.fsl_tablecode = and img.imgid = select coalesce(nullif(i.comment,''),'Product Photo') as title, 0 as FileSize, '' as fileext, 'http://doclibrary.com/' + c.mainFolder + '/' + c.subFolder + '/' + c.fileName as DocPath, '' as description from tbl_PRD_Images i with (nolock) inner join tbl_FSC_Content c with (nolock) on c.contentId = i.contentId where i.ownerId = and i.ownerType = and i.contentId =

Submit

Cancel