VbzCart/queries/qryCustAddrs

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

Details

  • Requires:
  1. 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>