File:software-prosubsub.htm
Method:query.table(columns,*where,*order,*top)
关键字 'ORDER' 附近有语法错误。 select top 6 * FROM covideo WHERE ORDER BY videoId desc
数据库执行错误
xmls/product.xmls
...ecomdpaper(format){
@query=$query(goods,paper);
@TagIds=1;
@query[TagIds]=[",{@TagIds},"];
@table=@query.table(*,['CStatus>0 and {*TagIds like}'],['Grade desc,GoodsId desc']);
@listta=@table.format(@format);
$return(@listta);
}

$sub recomdvideo(format){
@query=$query(video,download);
@querygoods=$query(goods,goods);
@querygoods[GoodsId]=$argv(0);
@GoodsCode=@querygoods.scalar(GoodsCode,['{*GoodsId =}']);
@TagIds=2;
@query[GoodsCode]=@GoodsCode;
@query[TagIds]=[",{@TagIds},"];
@
table=@query.table(*,[' {*GoodsCode =}'],['videoId desc'],6);
@content=@table.format(@format);
$return(@content);
}



$sub recomdpeixun(format){
@query=$query(goods,goods);
@cid=10;
@TagIds=1;
@query[TagIds]=[",{@TagIds},"];
@query[CatalogPath]=[",{@cid},"];
@table=@query.table(*,['CStatus>0 and {*CatalogPath like} and {*TagIds like}'],['Grade desc,GoodsId desc'],6);
@content=@table.format(@format){
@AttrJson=$var[AttrJson];
@tid=$datatable.loadJson(@AttrJson);
$if(@tid==$null)...