VbzCart/queries/qryCustAddrs
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Details
- Requires: cust_addrs
- 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 />
