select 'DOC' as type, DocID, DocTitle, DocDescription, FileSize, FileExt, DocPath, 0 as ContentId from qryDocuments where upper(DocPath) not like '%CLEARPIXEL%' union select 'IMG' as type, ImgID as DocID, ImgTitle as DocTitle, ImgDescription as DocDescription, FileSize, FileExt, ContentPath as DocPath, ContentID from qryImages where upper(contentpath) not like '%CLEARPIXEL%' order by doctitle

no items found

#numberformat(_totalOriginalRecords,"9,999")# Documents Found

#htmleditformat(DocTitle)#

#ucase(fileext)# image file #htmleditformat(DocDescription)#

#_lowerPagerDisplay#