VbzCart/docs/queries/qryCustAddrs
Jump to navigation
Jump to search
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 />