SELECT i.RecipeID, i.RecipeName, i.RecipeDesc, i.RecipeYield, i.Servings, i.ServingsDesc, i.RecipeImage, img.ImgPath, img.ImgName, img.ImgExt FROM tbl_REC_Items i, qryImageLookup img WHERE i.MFR_ID = AND i.RecipeID = AND #CreateODBCDate(Now())# >= i.PublishDate AND i.UnpublishDate >= #CreateODBCDate(Now())# AND i.RecipeImage = img.ImageID caller.variables.RecipeName = "#trim(qmd_dispRecipe.RecipeName)#"; caller.variables.RecipeDesc = "#trim(qmd_dispRecipe.RecipeDesc)#"; caller.variables.RecipeYield = "#trim(qmd_dispRecipe.RecipeYield)#"; caller.variables.Servings = #qmd_dispRecipe.Servings#; caller.variables.ServingsDesc = "#trim(qmd_dispRecipe.ServingsDesc)#"; caller.variables.RecipeImage = #qmd_dispRecipe.RecipeImage#; caller.variables.Image = "#trim(qmd_dispRecipe.ImgPath)##trim(qmd_dispRecipe.ImgName)#_200#trim(qmd_dispRecipe.ImgExt)#"; caller.variables.recordcount = 1; SELECT IngredientQuantity, IngredientMeasurement, measureType, IngredientDescription FROM tbl_REC_Ingredients WHERE RecipeID = ORDER BY IngredientRank SELECT InstructionStep, InstructionText FROM tbl_REC_Instructions WHERE RecipeID = ORDER BY InstructionStep caller.variables.RecipeName = ""; caller.variables.RecipeDesc = ""; caller.variables.RecipeYield = ""; caller.variables.Servings = 0; caller.variables.ServingsDesc = ""; caller.variables.RecipeImage = 0; caller.variables.Image = ""; caller.variables.recordcount = 0;