Difference between revisions of "VbzCart/procs/Upd Titles fr TitleIttyps"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | procs
Jump to navigation Jump to search
(created in db)
(changed source to eliminate recursive loop)
Line 7: Line 7:
 
*** Added DROP PROCEDURE for easier maintenance.
 
*** Added DROP PROCEDURE for easier maintenance.
 
*** Created in database (procs were not ported from L48 to Rizzo).
 
*** Created in database (procs were not ported from L48 to Rizzo).
 +
** '''2011-12-24''' this was in a recursive loop: this&rarr;{{vbzcart|table|_titles}}&rarr;{{vbzcart|proc|Upd_TitleIttyps_fr_Titles}}&rarr;{{vbzcart|table|_title_ittyps}}&rarr;this, so changed source from {{vbzcart|table|_title_ittyps}} to {{vbzcart/query|qryCat_Titles_Item_stats}}.
 
==SQL==
 
==SQL==
 
<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps;
 
<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps;
Line 15: Line 16:
 
       SUM(ti.cntForSale) AS cntForSale,
 
       SUM(ti.cntForSale) AS cntForSale,
 
       SUM(ti.cntInPrint) AS cntInPrint,
 
       SUM(ti.cntInPrint) AS cntInPrint,
−
       SUM(ti.qtyInStock) AS qtyInStock
+
       SUM(ti.qtyForSale) AS qtyInStock
−
     FROM _title_ittyps AS ti GROUP BY ID_Title
+
     FROM qryCat_Titles_Item_stats AS ti GROUP BY ID_Title
 
     ) AS ti ON ti.ID_Title=t.ID
 
     ) AS ti ON ti.ID_Title=t.ID
 
     SET
 
     SET

Revision as of 21:14, 24 December 2011

About

  1. REDIRECT Template:l/vc/query.

SQL

<mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps; CREATE PROCEDURE Upd_Titles_fr_TitleIttyps() 

 UPDATE _titles AS t LEFT JOIN (
   SELECT
     ID_Title,
     SUM(ti.cntForSale) AS cntForSale,
     SUM(ti.cntInPrint) AS cntInPrint,
     SUM(ti.qtyForSale) AS qtyInStock
    FROM qryCat_Titles_Item_stats AS ti GROUP BY ID_Title
   ) AS ti ON ti.ID_Title=t.ID
   SET
     t.cntForSale = ti.cntForSale,
     t.cntInPrint = ti.cntInPrint,
     t.qtyInStock = ti.qtyInStock;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/procs/Upd_Titles_fr_TitleIttyps&oldid=16538"