VbzCart/queries/qryCustAddrs
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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>