File:crew.htm
Method:query.scalar(columns,*where,*order)
语法错误 (操作符丢失) 在查询表达式 'CatalogId=' 中。
select top 1 CatalogName FROM cocatalog WHERE CatalogId=
数据库执行错误
xmls/news.xmls
...ger(*,['Status>0 and AreaId=1 {?} and {*CatalogPath like}'],['CreateDate desc'],100,$get(page,1));
@list=@tables.format(@format);
@map=$map();
@map[list]=@list;
@map[count]=@count;
@map[pages]=$number.ceiling((@count/100));
$write(@map.toJson());
}
$sub News(){
@query=$query(content,content);
@quert=$query(catalog,content);
@query[ContentId]=$argv(0);
@querys=@query.map(*,ContentId={*ContentId});
@ids=@query.scalar(CatalogId,['ContentId={*ContentId}']);
@quert[CatalogId]=@ids;
@name=@quert.scalar(CatalogName,['CatalogId={*CatalogId}']);
@Termtime=$datetime(@querys[CreateDate]);
@Termtimes=@Termtime.toString(yyyy/MM/dd hh:mm:ss);
$return($empty);
}
$sub jxyf(format,ids){
@query=$query(content,content);
@query[CatalogId]=@ids;
@tables=@query.table(*,['Status>0 and AreaId=1 and CatalogId={*CatalogId}'],['Grade desc']);
@list=@tables.format(@format){
@Cntent=$var[tz];
$if(@Cntent==可跳转){
@Subtitle=$var[Subtitle];
@as=["{@Subtitle}"];
}
$elseif(@Cntent==不可跳转...