Fix nonstandard SQL

interchange · Sep 18, 2018 · 091cce4 · 091cce4
1 parent d5455ab
commit 091cce4
Showing 1 changed file with 4 additions and 4 deletions.
diff --git a/dist/strap/templates/components/promo b/dist/strap/templates/components/promo
@@ -36,10 +36,10 @@ banner:
 	FROM [either]__UI_MERCH_TABLE__[or]merchandising[/either]
 	WHERE featured = '[control promo_type specials]'
 	AND (
-		timed_promotion <> 1 OR (
-			timed_promotion = 1 AND
-			start_date < "[scratch now]" AND
-			finish_date > "[scratch now]" )
+		timed_promotion <> '1' OR (
+			timed_promotion = '1' AND
+			start_date < '[scratch now]' AND
+			finish_date > '[scratch now]' )
 		)
 	LIMIT [control matches 4]
 | prefix="loop"]