苗景云的博客

首先在科讯CMS后台创建SQL函数标签

标签名称:  栏目简介

查询语句: select id,foldername,mid(classbasicinfo,instr(classbasicinfo,"||||")+4) as s,mid(s,1,instr(s,"||||")-1) as 栏目介绍 from ks_class where classid={$Param(0)} order by folderorder

sucifer 的动态标签是通过给定 查询语句：select top 10 ClassID,ClassName from PE_Class where

ChannelID=1 order by ClassID asc 中ChannelID=1 的值来确定调用的频道,要调用多个频道有些不方便

.现我将它改成函数标签,通过给定参数实现任意频道一级栏目的调用.

查询语句：select top 10 ClassID,ClassName from PE_Class where ChannelID={input(0)} and