VbzCart/docs/queries/qryCustAddrs

Details

• Requires: Template:Vbzcart/table
• Used by:
• Notes: Any basic simple calculations not involving other tables can be added to this query as needed.

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCustAddrs AS SELECT

 *,
 NOT ((IFNULL(WhenAct,Now()) > Now()) OR (IFNULL(WhenExp,Now()) < Now())) AS isActive
FROM cust_addrs;</mysql>

<section end=sql />