Item14215: Update the example in the text of Extensions.DBCacheContrib

pencil
Priority: Low
Current State: Closed
Released In: n/a
Target Release:
Applies To: Extension
Component: DBCacheContrib, DBCachePlugin
Branches:
Reported By: BramVanOosterhout
Waiting For:
Last Change By: MichaelDaum
The documentation of DBCacheContrib DBQueryis clear about the need for boolean and other operator that are text based to be written in UPPERCASE.

This is supported by the Search.pm script lines:
     70 "AND\\b|OR\\b|!=|=~?|~|<=?|>=?|LATER_THAN\\b|EARLIER_THAN\\b|LATER_THAN_OR_ON\\b|EARLIER_THAN_OR_ON\\b|WITHIN_DAYS\\b|IS_DATE\\b";
     71 my $uopRE = "!|[lu]c\\b|d2n|length|defined";
and matches are not qualified by /i.

However, in the Examples in the topic it reads:
%DBQUERY{"lc(text) =~ 'random' and topic != 'DBCachePlugin'"}%

The example should be updated to
%DBQUERY{"lc(text) =~ 'random' AND topic != 'DBCachePlugin'"}%
capitalising: and.

-- BramVanOosterhout - 09 Nov 2016

Patches welcome.

-- MichaelDaum - 02 Dec 2016

Fixed in latest release

-- MichaelDaum - 16 Jan 2017
 
Topic revision: r4 - 16 Jan 2017, MichaelDaum
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy