VbzCart/procs/Upd CatPages - Revision history

Woozle: _cat_pages -> qryCat_pages

2009-12-11T12:14:51Z

_cat_pages -> qryCat_pages

← Older revision		Revision as of 12:14, 11 December 2009
Line 1:		Line 1:
	==About==		==About==
	'''Updates''': {{vbzcart/query\|~~_cat_pages~~}} -> {{vbzcart\|table\|cat_pages}}		* '''Updates''': {{vbzcart/query\|qryCat_pages}} -> {{vbzcart\|table\|cat_pages}}
			* '''History''':
			** '''2009-12-11''' Revised to use qryCat_pages instead of _cat_pages, which had not been documented
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()		<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()
	REPLACE INTO cat_pages		REPLACE INTO cat_pages
	SELECT * FROM ~~_cat_pages~~		SELECT * FROM qryCat_pages
	ORDER BY Path;</mysql>		ORDER BY Path;</mysql>
	<section end=sql />		<section end=sql />

Woozle: link to _cat_pages at its new address

2009-03-08T18:33:26Z

link to _cat_pages at its new address

← Older revision		Revision as of 18:33, 8 March 2009
Line 1:		Line 1:
	==About==		==About==
	'''Updates''': _cat_pages -> {{vbzcart\|table\|cat_pages}}		'''Updates''': {{vbzcart/query\|_cat_pages}} -> {{vbzcart\|table\|cat_pages}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()		<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()

Woozle: New page: ==About== '''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}} ==SQL==
CREATE PROCEDURE Upd_CatPages() REPLACE INTO cat_pages SELECT * FROM _cat_pages ...

2009-03-08T18:08:07Z

New page: ==About== '''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}} ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages() REPLACE INTO cat_pages SELECT * FROM _cat_pages ...

New page

==About==
'''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}}
==SQL==
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()
REPLACE INTO cat_pages
SELECT * FROM _cat_pages
ORDER BY Path;</mysql>
<section end=sql />

VbzCart/procs/Upd CatPages - Revision history

Woozle: _cat_pages -> qryCat_pages

Woozle: link to _cat_pages at its new address

Woozle: New page: ==About== '''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}} ==SQL== CREATE PROCEDURE Upd_CatPages() REPLACE INTO cat_pages SELECT * FROM _cat_pages ...

Woozle: New page: ==About== '''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}} ==SQL==
CREATE PROCEDURE Upd_CatPages() REPLACE INTO cat_pages SELECT * FROM _cat_pages ...