摘要:
最近用科讯CMS要查找父栏目,搜索了很久,结果都不甚满意,遂自己写了一个。。栏目:select top 1 * from KS_Class where TS=(select left(TS,len(TS)-15) from KS_Class where ClassID= {ReqNum(id) })内容:select * from KS_Class where TS=(select left(TS,len(TS)-15) from KS_Class where ID=(select top 1 tid from KS_U_zs where id={ReqNum(d) ) )如果要找上2级的,把 阅读全文