File:view.html
Method:query.map(columns,*where,*order)
资源池 'default' 没有足够的系统内存来运行此查询。
select top 1 CatalogName FROM goods_catalog WHERE CatalogId=953
数据库执行错误
xmls/goodsview.xmls
...ldval=$empty;
$if(@paratb<>$null){
@paratb.foreach(){
$if($var[Id]==@fieldid){
@fieldval=$var[value];
@fieldunit=$var[unit];
$break();
}
}
}
}
//---------------------产品浏览记录---------------------
$sub addgoodsData(){
@query=$query(goods,goods);
@gid=$http.get(id,0,N);
@pid=$http.get(pid,0,N);
@query[GoodsId]=@gid;
@row=@query.map(*,['GoodsId={*GoodsId}']);
$if(@row==$null){
$end();
}
$else{
@dbcatalog=$query(catalog,goods);
@dbcatalog[CatalogId]=@row[CatalogId];
@rowCatalog=@dbcatalog.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().toStri...