VbzCart/queries/qryCtg Titles active - Revision history

Woozle at 22:39, 2 March 2016

2016-03-02T22:39:50Z

← Older revision		Revision as of 22:39, 2 March 2016
Line 4:		Line 4:
	* '''History''':		* '''History''':
	** '''2009-05-03''' Added to main server database (no change in design)		** '''2009-05-03''' Added to main server database (no change in design)
			** '''2016-03-02''' This query no longer works, and (coincidentally) should no longer be needed.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS		<mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS
	SELECT		SELECT
	*		*
Line 17:		Line 18:
	)		)
	);</mysql>		);</mysql>
	~~<section end=sql />~~

Woozle: added to main server database

2009-05-03T21:39:37Z

added to main server database

← Older revision		Revision as of 21:39, 3 May 2009
Line 1:		Line 1:
	==Details==		==Details==
	* '''Purpose''': Brings up ''only'' ~~[[../../tables/ctg_titles~~\|ctg_titles]] records which are active, making it impossible for an inactive catalog to make an active title look inactive.		* '''Purpose''': Brings up ''only'' {{vbzcart\|table\|ctg_titles}} records which are active, making it impossible for an inactive catalog to make an active title look inactive.
	* '''Requires''': ~~[[../../tables/ctg_titles~~\|ctg_titles]]		* '''Requires''': {{vbzcart\|table\|ctg_titles}}
			* '''History''':
			** '''2009-05-03''' Added to main server database (no change in design)
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS

Woozle: moved from single-page listing

2008-11-30T19:55:42Z

moved from single-page listing

New page

==Details==
* '''Purpose''': Brings up ''only'' [[../../tables/ctg_titles|ctg_titles]] records which are active, making it impossible for an inactive catalog to make an active title look inactive.
* '''Requires''': [[../../tables/ctg_titles|ctg_titles]]
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS
SELECT
*
FROM ctg_titles AS tgt
WHERE
tgt.isActive
AND
( ( tgt.WhenDiscont Is Null
) Or (
tgt.WhenDiscont>Now()
)
);</mysql>
<section end=sql />