[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