File:product3.html
Method:query.scalar(columns,*where,*order)
在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: Named Pipes Provider, error: 40 - 无法打开到 SQL Server 的连接)
数据库执行错误
xmls/product.xmls
...
@querygcata=$query(catalog,goods);
@id=$http.get(cid);
@querygcata[ParentId]=@id;
@AreaId=$shell[AreaId];
@querygcata[AreaId]=@AreaId;
@tablectmn=@querygcata.table(*,['Status>0 and ParentId={*ParentId} and AreaId={*AreaId}'],['Grade asc,CatalogId asc']);
@listta=@tablectmn.format(@format){
}
$return(@listta);
}


//品牌内容
$sub viewProduct(){
@querycata=$query(catalog,goods);
@cid=$http.get(cid);
@querycata[CatalogId]=@cid;
@AreaId=$shell[AreaId];
@querycata[AreaId]=@AreaId;
@
cataname=@querycata.scalar(CatalogName,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
@rowdata=@querycata.map(*,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
$if(@rowdata==$null){
@rowdata=$map();
}
$return($empty);
}

//详情页品牌推荐
$function recommendProduct(format){
@querygoods=$query(catalog,goods);
@AreaId=$shell[AreaId];
@querygoods[AreaId]=@AreaId;
@tablegs=@querygoods.table(*,['Status>0 and AreaId={*AreaId}'],['Grade desc,CatalogId asc'],4);
@goodlist=@tablegs.format(@for...