File:goods-details.html
Method:query.scalar(columns,*where,*order)
語法錯誤 (操作符丟失) 在查詢表達式 'CatalogId= and AreaId=1' 中。 select top 1 CatalogName FROM cpcatalog WHERE CatalogId= and AreaId=1
數據庫執行錯誤
xmls/product.xmls
...=0){
@content3=['<div style="color:#FF0000;font-size:12px;height:45px;line-height:45px;text-align:center;">對不起,當前沒有數據!</div>'];
@Pager=$empty;
}
$return($empty);
}


//查詢內容
$sub viewProduct(){
@querygoods=$query(product,product);
@querycata=$query(catalog,product);
@GoodsId=$http.get(pid);
@querygoods[ProductId][email protected];
@[email protected](CatalogId,['ProductId={*ProductId} and AreaId=1']);
@querycata[CatalogId][email protected];
@AreaId=$shell[AreaId];
@querycata[AreaId][email protected];
@
[email protected](CatalogName,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
@[email protected](@GoodsId);
@Modified=$empty;
$if(@rowdata==$null){
@rowdata=$map();
@rowdata[ProductName]=無數據;
}
$return($empty);
}