Talk:VbzCart/pieces/catalog/building
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
A disused query from doCtgUpdate(): <mysql>UPDATE cat_items AS i LEFT JOIN qryCtg_Upd_join AS u ON i.ID=u.ID_Item
SET i.CatNum = u.CatNum, i.isForSale = TRUE, i.isInPrint = NOT u.isCloseOut, i.isCloseOut = u.isCloseOut, i.isPulled = FALSE, i.isDumped = FALSE, i.ID_ItTyp = u.ID_ItTyp, i.ID_ItOpt = u.ID_ItOpt, i.ItOpt_Descr = IFNULL(u.ItOpt_Descr,i.ItOpt_Descr), /* kluge */ i.ItOpt_Sort = u.ItOpt_Sort, i.ID_ShipCost = u.ID_ShipCost, i.PriceBuy = u.PriceBuy, i.PriceSell = u.PriceSell, i.PriceList = u.PriceList, i.GrpCode = u.GrpCode, i.GrpDescr = u.GrpDescr, i.GrpSort = u.GrpSort, i.CatSfx = u.CatSfx WHERE u.IDS_Item IS NOT NULL;</mysql>
This might be useful later if we try to set things up so we don't have to use the nonstandard REPLACE INTO syntax. More likely, everything will change before that and I'll just have to rewrite it from scratch. --Woozle 09:04, 20 March 2008 (EDT)
Start a discussion about VbzCart/pieces/catalog/building
Talk pages are where people discuss how to make content on HTYP the best that it can be. You can use this page to start a discussion with others about how to improve VbzCart/pieces/catalog/building.
