File:goods-offer.html
Method:db.dataScalar(sql)
资源池 'default' 没有足够的系统内存来运行此查询。
select count(*) from goods_goods goo left join usmanufactor man on goo.ManufactorId=man.ManufactorId where goo.Status=1 and man.Status=1 and man.mStatus=0 and goo.AreaId='1' and SerialsId='0'
数据库执行错误
xmls/goods.xmls
...tplx,0,N);
@query[GoodsId]=@crid;
@GoMap=@query.map(['GoodsId,GoodsName,ParaType,UserId,Price,Pic,CatalogId,SerialsId'],['GoodsId={*GoodsId}']);
@db=$db();
@db[AreaId]=$shell[AreaId];
@db[SerialsId]=@GoMap[SerialsId];
@db[CatalogId]=@GoMap[CatalogId];
@countcrid=@db.dataScalar(['select count(*) from goods_goods goo left join usmanufactor man on goo.ManufactorId=man.ManufactorId where goo.Status=1 and man.Status=1 and man.mStatus=0 and goo.AreaId={*AreaId} and CatalogId={*CatalogId}']);
@counttplx=@db.dataScalar(['select count(*) from goods_goods goo left join usmanufactor man on goo.ManufactorId=man.ManufactorId where goo.Status=1 and man.Status=1 and man.mStatus=0 and goo.AreaId={*AreaId} and SerialsId={*SerialsId}']);
@queryman=$query(manufactor,user);
@queryman[UserId]=@GoMap[UserId];
@itemdt(@GoMap[GoodsId]);
@Pic=@GoMap[Pic];
$if($file.existsFile($file.getMapPath(@Pic))==0){
@Pic=['images/default.jpg'];
}
@ManMap=@queryman.map(['CompanyName,ManufactorId,sjTag,dat...