Mailing List Archive

[interchange] Fix nonstandard SQL
commit 091cce433f930d805b6235e9f5b787265024cbe4
Author: Jon Jensen <jon@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"]

_______________________________________________
interchange-cvs mailing list
interchange-cvs@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-cvs