VbzCart/docs/queries/qryCustAddrs: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==Details== * '''Requires''': {{vbzcart/table|cust_addrs}} * '''Used by''': * '''Notes''': Any basic simple calculations not involving other tables can be added to this query as needed. ==...) |
m (Woozle moved page VbzCart/VbzCart/queries/qryCustAddrs to VbzCart/docs/queries/qryCustAddrs without leaving a redirect: part 2) |
(No difference)
| |
Latest revision as of 01:55, 25 February 2024
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 />