File:product-two.html
Method:query.table(columns,*where,*order,*top)
語法錯誤 (操作符丟失) 在查詢表達式 'CatalogId= and AreaId=1' 中。 select top 7 * FROM cpcatalog WHERE CatalogId= and AreaId=1 ORDER BY CatalogId asc
數據庫執行錯誤
xmls/product.xmls
...format1);
}
$return(@listta);
}

$function listProduct1(format){
@querygcata=$query(catalog,product);
@cid=$http.get(cid);
@querygcata[CatalogId][email protected];
@[email protected](ParentId,['CatalogId={*CatalogId}']);
$if(@ParentId==0){
@AreaId=$shell[AreaId];
@querygcata[AreaId][email protected];
@[email protected](*,['CatalogId={*CatalogId} and AreaId=1'],['CatalogId asc'],7);
}
$else{
@querygcata[CatalogId][email protected];
@AreaId=$shell[AreaId];
@querygcata[AreaId][email protected];
@
[email protected](*,['CatalogId={*CatalogId} and AreaId=1'],['CatalogId asc'],7);
}
@[email protected](@format);
$return(@listta);
}


$function listProduct2(format){
@querygcata=$query(catalog,product);
@queryggoods=$query(product,product);
@querygcatas=$query(catalog,product);
@pid=$http.get(pid);
@queryggoods[ProductId][email protected];
@[email protected](CatalogId,['ProductId={*ProductId}']);
@querygcata[CatalogId][email protected];
@[email protected](ParentId,['Cata...
单机麻将