https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fprocs%2Fupdate_cat_items_fr_qryCtg_buildVbzCart/procs/update cat items fr qryCtg build - Revision history2026-07-06T13:43:32ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/procs/update_cat_items_fr_qryCtg_build&diff=14418&oldid=prevWoozle: rescued from database, and dropped2010-11-10T02:00:58Z<p>rescued from database, and dropped</p>
<p><b>New page</b></p><div>==About==<br />
* '''Status''': Apparently disused.<br />
* '''Requires''': {{vbzcart|table|cat_items}}, {{vbzcart/query|qryCtg_build}}<br />
* '''History''':<br />
** '''2010-11-09''' Found this procedure in the database, but could not identify where it was being used. As there was no documentation of it either, I am documenting it here and removing it from the database.<br />
==SQL==<br />
<mysql><br />
DROP PROCEDURE IF EXISTS `update_cat_items_fr_qryCtg_build`;<br />
CREATE PROCEDURE `update_cat_items_fr_qryCtg_build`()<br />
UPDATE qryCtg_build AS r LEFT JOIN cat_items AS i ON r.ID_Item=i.ID<br />
SET<br />
i.CatNum = r.CatNum,<br />
i.isForSale = r.isForSale,<br />
i.isInPrint = r.isInPrint,<br />
i.isCloseOut = r.isCloseOut,<br />
i.isPulled = FALSE,<br />
i.isDumped = FALSE,<br />
i.ID_ItTyp = r.ID_ItTyp,<br />
i.ID_ItOpt = r.ID_ItOpt,<br />
i.ItOpt_Descr = IFNULL(r.ItOpt_Descr,i.ItOpt_Descr),<br />
i.ItOpt_Sort = r.ItOpt_Sort,<br />
i.ID_ShipCost = r.ID_ShipCost,<br />
i.PriceBuy = r.PriceBuy,<br />
i.PriceSell = r.PriceSell,<br />
i.PriceList = r.PriceList,<br />
i.GrpCode = r.GrpCode,<br />
i.GrpDescr = r.GrpDescr,<br />
i.GrpSort = r.GrpSort,<br />
i.CatSfx = r.CatSfx<br />
WHERE r.ID_Item IS NOT NULL;</mysql></div>Woozle