Difference between revisions of "VbzCart/queries/qryCustAddrs"
Jump to navigation
Jump to search
(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. ==...) |
(No difference)
|
Latest revision as of 21:34, 3 December 2008
Details
- Requires:
- REDIRECT Template:l/vc/table
- Used by:
- Notes: Any basic simple calculations not involving other tables can be added to this query as needed.
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>