VbzCart/docs/queries/qryCat Titles web: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (moved from single-page listing) |
m (Woozle moved page VbzCart/VbzCart/queries/qryCat Titles web to VbzCart/docs/queries/qryCat Titles web without leaving a redirect: part 2) |
(No difference)
| |
Latest revision as of 01:55, 25 February 2024
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
<section begin=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> <section end=sql />