File:product.html
Method:query.scalar(columns,*where,*order)
在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: Named Pipes Provider, error: 40 - 无法打开到 SQL Server 的连接)
数据库执行错误
xmls/product.xmls
...@format){
}
$return(@listtapic);
}
//产品
$sub ProductList(){
@querygoods=$query(goods,goods);
@querycata=$query(catalog,goods);
@querygoods[CatalogId]=$http.get(cid,$null);
@cid=$http.get(cid,0);
@querycata[CatalogId]=@cid;
@UserID=$http.getSession(UserID);
@AreaId=1;
@tps=$http.get(tp,$null);
@querygoods[AreaId]=@AreaId;
@querycata[AreaId]=@AreaId;
@querygoods[GoodsName]=$http.get(sv,$null);
@querygoods[GoodsCode]=$http.get(sv,$null);
@querygoods[Keyword]=@tps;
@cname=@querycata.scalar(CatalogName,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
@sqwher=['Status>0 and (GoodsName like {#like(%GoodsName%)} or GoodsCode like {#like(%GoodsCode%)}) '];
$if(@tps<>$null){
@sqwher=['Status>0 {?} and Keyword like {#like(%Keyword%)}'];
}
$if(@cid<>0){
@CatalogPath=[".{@cid}."];
@querygoods[CatalogPath]=@CatalogPath;
@sqwher=['Status>0 and CatalogPath like {#like(%CatalogPath%)} {?} and (GoodsName like {#like(%GoodsName%)})'];
}
@pi=$http.get(pi,0);...