这个是单单打印 field的字符串
product.id,product.uid,product.shop_id,product.class_id,product.ti
tle,product.price,product.hits,shop.name,auth.star,concat("http://olespykc1.bkt.clouddn.com/",logo,"?imageView2/1/w/300/h/300/q/75|imageslim") as logo,concat("http://olespykc1.bkt.clouddn.com/",file_name,"?imageView2/1/w/300/h/300/q/75|imageslim") as couponphoto ，没什么问题
但是我看报错所生成出来的sql语句
却发现有错误
SELECT `product`.`id`,`product`.`uid`,`product`.`shop_id`,`product`.`class_id`,`product`.`title`,`product`.`price`,`product`.`hits`,`shop`.`name`,`auth`.`star`,concat("http://olespykc1.bkt.clouddn.com/",`logo`,"?imageView2/1/w/300/h/300/q/75|imageslim") as logo,`file_name`,"?imageView2/1/w/300/h/300/q/75|imageslim") as couponphoto FROM `jsb_product` `product` INNER JOIN `jsb_shop` `shop` ON `product`.`uid`=`shop`.`uid` INNER JOIN `jsb_authenticate` `auth` ON `product`.`uid`=`auth`.`uid` INNER JOIN `jsb_attachment` `att` ON `product`.`id`=`att`.`table_id` WHERE `product`.`status` = 1 AND `shop`.`status` = 1 AND `auth`.`status` = 1 AND `shelf` = 1 AND `isdelete` = 0 AND `att`.`table_name` = 'product' AND `city` = '500101' GROUP BY att.table_id ORDER BY product.update_time desc,product.id desc LIMIT 0,2 [/b]
我把打印出来的字符串复制到 生成出来的sql语句里面去，一切正常
