File:view.html
Method:query.map(columns,*where,*order)
资源池 'default' 没有足够的系统内存来运行此查询。
select top 1 * FROM goods_goods WHERE GoodsId=1101479 and Status=1
数据库执行错误
xmls/goodsview.xmls
...'select u.Mobile from ususer u inner join usmanufactor m on u.UserId=m.UserId where m.ManufactorId={*ManufactorId}']);
$if(@PotentialId>1){
$write($map.serialize(status,ok,OpenId,@OpenId,Mobile,@Mobile).toJson());
$end();
//推送公众号信息
}
}
$write($map.serialize(status,no).toJson());
}
$sub goodsview(){
@ParaTypeName=$string();
@OtherJson=[];
@query=$query(goods,goods);
@gid=$http.get(id,0,N);
@pid=$http.get(pid,0,N);
$if(@gid==0){
$write(参数异常);
$end();
}
@query[GoodsId]=@gid;
@row=@query.map(*,['GoodsId={*GoodsId} and Status=1']);
//@row=@query.map(*,['GoodsId={*GoodsId} ']);
$if(@row==$null){
//$write(数据不存在);
$http.redirect(["notfound.html"]);
$end();
}
@query.nonQuery(['update {**table} set Click=Click+1 where GoodsId={*GoodsId}']);
//检索产品是否推荐产品
@queryextension=$query(extension,goods);
@queryextension.setField($field(GoodsId,@gid,number));
@extensiontb=@queryextension.dataMap(['select M.ManufactorId,b.Price,B.UserId from goods_extension e inner ...