[interchange] Fix nonstandard SQL
Jon Jensen <[email protected]> Tue, 18 Sep 2018 20:08:56 +0000
| Newsgroups | gmane.comp.web.interchange.cvs |
|---|---|
| Message-ID | <[email protected]> |
commit 091cce433f930d805b6235e9f5b787265024cbe4 Author: Jon Jensen <[email protected]> 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"]