moon-hzq

> 贴下两张表的结构 CREATE TABLE `articles` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资讯ID', `author_id` int(11) NOT NULL DEFAULT '0' COMMENT '作者ID', `author_name` varchar(50) NOT NULL DEFAULT '' COMMENT '作者', `short_title`...

我的问题里面就是这样做的,但是显示不出来,,打印sql语句是这样的: {"statement": "select articles.`author_id`,articles.`author_name`,articles.`short_title`,articles.`title`,articles.`source`,articles.`pic_url`,articles.`pic_type`,articles.`status`,articles.`is_top`,articles.`sort_index`,articles.`id`,group_concat(articles_content.`content` separator 'Z5dDrivernSKR') as articles_content_goadmin_join_content from `articles` left join `articles_content` on articles_content.`article_id` = articles.`id` GROUP BY articles.`id` order by articles.`id` desc LIMIT ? OFFSET ?", "args": [10,0]}...

> 我的问题里面就是这样做的,但是显示不出来,,打印sql语句是这样的: > {"statement": "select articles.`author_id`,articles.`author_name`,articles.`short_title`,articles.`title`,articles.`source`,articles.`pic_url`,articles.`pic_type`,articles.`status`,articles.`is_top`,articles.`sort_index`,articles.`id`,group_concat(articles_content.`content` separator 'Z5dDrivernSKR') as articles_content_goadmin_join_content from `articles` left join `articles_content` on articles_content.`article_id` = articles.`id` GROUP BY articles.`id` order by articles.`id` desc LIMIT ? OFFSET ?",...

进入详情页后,也无法正常显示出 content,即使加了这样的代码 detail := articles.GetDetail() detail.AddField("Content", "content", db.Text ). FieldJoin(types.Join{ Table: "articles_content", Field: "id", JoinField: "article_id", }) 也不行

> Q2: 扩展问题:同理,如果我想对查询的数据字段进行一些额外的sql语句处理,请问有其他什么方法吗,谢谢 > A2: info := userTable.GetInfo().Where("bid", "=", 2) 我的意思是指类似这样的语句:select `id`,`name`,FROM_UNIXTIME(`time`) as date from a where id = 1; FROM_UNIXTIME(`time`) as date 使用到了 mysql 的将时间戳转换为日期格式的函数,这种需要怎么办?