[interchange] Fix nonstandard SQL

Jon Jensen interchange-cvs at icdevgroup.org
Tue Sep 18 20:08:56 UTC 2018


commit 091cce433f930d805b6235e9f5b787265024cbe4
Author: Jon Jensen <jon at endpoint.com>
Date:   Tue Sep 18 12:02:42 2018 -0600

    Fix nonstandard SQL

 dist/strap/templates/components/promo |    8 ++++----
 1 files changed, 4 insertions(+), 4 deletions(-)
---
diff --git a/dist/strap/templates/components/promo b/dist/strap/templates/components/promo
index 18a7b38..2e03912 100644
--- 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"]



More information about the interchange-cvs mailing list