VbzCart/queries/qryCat Titles web

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 18:47, 30 November 2008 by Woozle (talk | contribs) (moved from single-page listing)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

  • Requires: qryCat_Titles_Item_stats
  • Used by: as of 2008-05-23, used only for generating old-style titles.lst file, but it may eventually be used by active code in the rewrite.

SQL

<mysql>CREATE OR REPLACE VIEW qryCat_Titles_web AS SELECT

 *,
 CAST(CONCAT("“",Name,"“: ",currMinSell,IF(currMinSell=currMaxSell,"",CONCAT(" – ",currMaxSell))) AS CHAR) AS ImgText

FROM qryCat_Titles_Item_stats;</mysql>