VbzCart/procs/Upd CatPages: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
m link to _cat_pages at its new address |
_cat_pages -> qryCat_pages |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
'''Updates''': {{vbzcart/query| | * '''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 | SELECT * FROM qryCat_pages | ||
ORDER BY Path;</mysql> | ORDER BY Path;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Latest revision as of 12:14, 11 December 2009
About
- Updates: qryCat_pages -> cat_pages
- History:
- 2009-12-11 Revised to use qryCat_pages instead of _cat_pages, which had not been documented
SQL
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()
REPLACE INTO cat_pages SELECT * FROM qryCat_pages ORDER BY Path;</mysql>
<section end=sql />
