select p.product, p.shortdesc, p.longdesc, case when img.ContentPath is null then 755 else p.imgId end as imgId, img.ContentPath, i.filewidth FROM tbl_PRD_Products p LEFT OUTER JOIN tbl_IMG_Images i ON i.imgid = p.imgid LEFT OUTER JOIN qryContentFullPathLookup img on img.contentId = i.contentId WHERE p.ProdID = AND p.OwnerID = AND p.FSL_TableCode = AND #CreateODBCDate(Now())# >= p.PublishDate AND p.UnpublishDate >= #CreateODBCDate(Now())# caller.variables.product = "#trim(qmd_dispFormula.product)#"; caller.variables.shortdesc = "#trim(qmd_dispFormula.shortdesc)#"; caller.variables.longdesc = "#trim(qmd_dispFormula.longdesc)#"; caller.variables.imgID = #qmd_dispFormula.imgID#; caller.variables.recordcount = 1; caller.variables.product = ""; caller.variables.shortdesc = ""; caller.variables.longdesc = ""; caller.variables.imgID = 755; caller.variables.imgPath = ""; caller.variables.recordcount = 0; Evaluate( "caller.#attributes.queryName# = qmd_dispFormula" );