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 CatalogId='912'
数据库执行错误
xmls/goods.xmls
...bstring(0,@len);
$return(["{@nstr}..."]);
}
$else{
$return(@str);
}
}
$else{
$return(@str);
}
}
//产品详细
$sub productOfferview(){
@query=$query(goods,goods);
@crid=$http.get(crid,0,N);
@tplx=$http.get(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(ma...