File:view.html
Method:query.scalar(columns,*where,*order)
资源池 'default' 没有足够的系统内存来运行此查询。
select top 1 count(*) FROM usgoodsData WHERE GoodsName='二氧化氯消毒装置 咨询玉洁 规格型号全' and CatalogName='污水处理设备 / 固废处理设备' and CompanyName='潍坊玉洁环保水处理设备有限公司' and BrandName='玉洁环保' and CreateDate='2025-09-22 00:00:00'
数据库执行错误
xmls/goodsview.xmls
...log.map(['CatalogName'],['CatalogId={*CatalogId}']);
@dbmanufactor=$query(manufactor,user);
@dbmanufactor[UserId]=@row[UserId];
@rowmanufactor=@dbmanufactor.map(['CompanyName'],['UserId={*UserId}']);
@dbgoodsData=$query(goodsData,user);
@dbgoodsData[GoodsName]=@row[GoodsName];
@dbgoodsData[CatalogName]=@rowCatalog[CatalogName];
@dbgoodsData[CompanyName]=@rowmanufactor[CompanyName];
@dbgoodsData[BrandName]=@row[BrandName];
@dbgoodsData[CreateDate]=$datetime.now().toString(yyyy-MM-dd);
@goodsDataCount=@dbgoodsData.scalar(['count(*)'],['GoodsName={*GoodsName} and CatalogName={*CatalogName} and CompanyName={*CompanyName} and BrandName={*BrandName} and CreateDate={*CreateDate}']);
$if(@goodsDataCount>0){
@dbgoodsMap=@dbgoodsData.map(['GoodsDataId,Click'],['GoodsName={*GoodsName} and CatalogName={*CatalogName} and CompanyName={*CompanyName} and BrandName={*BrandName} and CreateDate={*CreateDate}']);
@dbgoodsData[GoodsDataId]=@dbgoodsMap[GoodsDataId];
@dbgoodsData.nonQuery(['upd...