Error
File:web/school/common.xmlc
Function Code:510
Method Code:10
关键字 'and' 附近有语法错误。 select * FROM subjectscontent WHERE status>0 and CatalogID= and SID=1576 ORDER BY Modified desc,ContentID desc
数据库执行错误
web/school/common.xmlc
...null))){
@catalogid=0;
}
@list=@query.format(@format,*,{%status>0 and Lang='{$var[lang]}' and CatalogID={@catalogid} and lang='{$var[lang]}'%},{%Modified desc,ContentID desc%},10);
$content.write(@list);
}


$function getClsSubject(format){
@list=$empty;
@query=$query(content,subjects);
$if($get.number(schid,0)<>0){
@schid=$get.number(schid,0);
@catalogid=0;
@id=0;
$if($get(id)<>$null){
@id=$get(id);
@catalogid=@query.dataScalar(catalogid,{%Status>0 and ContentID={@id}%});
}
@
list=@query.format(@format,*,{%status>0 and CatalogID={@catalogid} and SID={@schid}%},{%Modified desc,ContentID desc%}){
@cls=$empty;
$if(@id==@query[ContentID]){
@cls=selected="selected";
}
}
}
$content.write(@list);
}


//课程设置
$function subjectset(format,format2){
@list=$empty;
@query=$query(catalog,subjects);
@query2=$query(content,subjects);
$if($get.number(schid,0)<>0){
@schid=$get.number(schid);
@list=@query.format(@format,*,{%status>0 and CatalogID in (select Max(Ca...