Woozle: /* SQL */ +isActive; created About section

2008-12-11T18:06:56Z

SQL: +isActive; created About section

← Older revision		Revision as of 18:06, 11 December 2008
Line 1:		Line 1:
			==About==
			* '''Requires''': {{vbzcart/table\|cat_depts}}, {{vbzcart/table\|cat_supp}}
			* '''History''':
			** '''2008-12-11''' Added isActive field (from {{vbzcart/table\|cat_depts}}) so that {{vbzcart/query\|qryCbx_Depts}} can show only active depts
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Depts AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Depts AS
Line 7:		Line 11:
	d.CatKey,		d.CatKey,
	UPPER(IFNULL(d.PageKey,d.CatKey)) AS CatKey_def,		UPPER(IFNULL(d.PageKey,d.CatKey)) AS CatKey_def,
			d.isActive,
	d.ID_Supplier,		d.ID_Supplier,
	UPPER(CONCAT_WS('-',s.CatKey,d.CatKey)) AS CatNum,		UPPER(CONCAT_WS('-',s.CatKey,d.CatKey)) AS CatNum,

Woozle: moved from single-page listing

2008-11-30T18:25:40Z

moved from single-page listing

New page

==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Depts AS
SELECT
d.ID,
d.Name,
d.Sort,
d.CatKey,
UPPER(IFNULL(d.PageKey,d.CatKey)) AS CatKey_def,
d.ID_Supplier,
UPPER(CONCAT_WS('-',s.CatKey,d.CatKey)) AS CatNum,
LOWER(CONCAT_WS("/",s.CatKey,IFNULL(d.PageKey,d.CatKey))) AS CatWeb_Dept,
LOWER(CONCAT_WS("/",s.CatKey,d.CatKey)) AS CatWeb_Title
FROM cat_depts AS d LEFT JOIN cat_supp AS s ON d.ID_Supplier=s.ID;</mysql>
<section end=sql />

VbzCart/queries/qryCat Depts - Revision history

Woozle: /* SQL */ +isActive; created About section

Woozle: moved from single-page listing