VbzCart/queries/qryCat Titles web
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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>