File:goods-offer.html
Method:db.dataScalar(sql)
资源池 'internal' 没有足够的系统内存来运行此查询。
当前命令发生了严重错误。应放弃任何可能产生的结果。
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
...CatalogPath,goo.Status,goo.TagIds,goo.ParentGoodsId,goo.Keyword,man.CompanyName,man.CompanyQQ,datediff(year,man.ChenliDate,getdate()) ChenliDate,man.sjTag,man.BusinessLicenceProvinceId,man.BusinessLicenceCityId,man.ManufactorId from goods_goods goo left join usmanufactor man on (goo.ManufactorId=man.ManufactorId and man.Status=1 and man.mStatus=0) where goo.Status=1 {@sqlwhere})a where RowNumber {#between(RowNumber)}']);
@querycity=$query(city,logistics);
@queryman=$query(manufactor,user);
@count=@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 {@sqlwhere}']);
$if(@count==0){
@plist=['<li style="width:100%;color:red;text-align:center;font-size:15px;border:0px"><img style="width:100%;height:100%;border:0" src="images/non022.png" /></li>'];
@Pager=$empty;
}
$else{
@pagedata();
}
$return($empty);
}
$sub getSeachpara(){
@query=$query(pararela,goods);
...