全站信息BaiDu地图列表标签
作者:佚名
来源:本站原创
点击数: 次
发布时间:2010年11月28日
问题:.NET版系统自带的“全站信息BaiDu地图列表标签”生成的XML文件,生成的文件中
2、将标签代码的
<text /> <image /> <keywords /> <source />都是空的,如下图
原因:“全站信息BaiDu地图列表”标签的查询语句没有查询到这几个字段,这时候我们需要重新写一个标签。
解决方法:1、把原来的标签的查询语句修
SELECT TOP @pagesize C.* FROM PE_CommonModel C WHERE (C.Status = 99) AND (C.SigninType < 2) AND C.GeneralID NOT IN(SELECT TOP @startrow IC.GeneralID FROM PE_CommonModel IC WHERE (IC.Status = 99) AND (IC.SigninType < 2) ORDER BY IC.UpdateTime DESC) ORDER BY C.UpdateTime DESC
改成
SELECT TOP @pagesize * FROM PE_CommonModel Left JOIN PE_U_Article ON PE_CommonModel.GeneralID = PE_U_Article.ID
WHERE PE_CommonModel.Status=99 AND PE_CommonModel.SigninType < 2 AND PE_CommonModel.GeneralID NOT IN
(SELECT TOP @startrow PE_CommonModel.GeneralID FROM PE_CommonModel Left JOIN PE_U_Article ON PE_CommonModel.GeneralID = PE_U_Article.ID
WHERE PE_CommonModel.Status=99 AND PE_CommonModel.SigninType < 2
ORDER BY PE_CommonModel.UpdateTime DESC) ORDER BY PE_CommonModel.UpdateTime DESC
原因:“全站信息BaiDu地图列表”标签的查询语句没有查询到这几个字段,这时候我们需要重新写一个标签。
解决方法:1、把原来的标签的查询语句修
SELECT TOP @pagesize C.* FROM PE_CommonModel C WHERE (C.Status = 99) AND (C.SigninType < 2) AND C.GeneralID NOT IN(SELECT TOP @startrow IC.GeneralID FROM PE_CommonModel IC WHERE (IC.Status = 99) AND (IC.SigninType < 2) ORDER BY IC.UpdateTime DESC) ORDER BY C.UpdateTime DESC
改成
SELECT TOP @pagesize * FROM PE_CommonModel Left JOIN PE_U_Article ON PE_CommonModel.GeneralID = PE_U_Article.ID
WHERE PE_CommonModel.Status=99 AND PE_CommonModel.SigninType < 2 AND PE_CommonModel.GeneralID NOT IN
(SELECT TOP @startrow PE_CommonModel.GeneralID FROM PE_CommonModel Left JOIN PE_U_Article ON PE_CommonModel.GeneralID = PE_U_Article.ID
WHERE PE_CommonModel.Status=99 AND PE_CommonModel.SigninType < 2
ORDER BY PE_CommonModel.UpdateTime DESC) ORDER BY PE_CommonModel.UpdateTime DESC
2、将标签代码的