string SelectString = "SELECT Web_Article.ID, Web_SubWebInfo.SubWebName, Web_Space.Name, Web_Article.Title, Web_Article.Remark, CASE Web_Article.IsIndex WHEN '1' THEN '是' WHEN '0' THEN '否' END AS IsIndex, CASE Web_Article.Passed WHEN '1' THEN '是' WHEN '0' THEN '否' END AS Passed, Web_Article.PublicTime FROM Web_Article CROSS JOIN Web_Space INNER JOIN Web_SubWebInfo ON Web_Article.SubWebID = Web_SubWebInfo.ID AND Web_Article.SpaceID = Web_Space.ID WHERE Web_Article.SpaceID = 13 AND Web_Article.SubWebID <= 2 ORDER BY Web_Article.ID";
布尔字段的显示
最新推荐文章于 2014-10-07 18:00:41 发布