91在线免费公开视频,成人国成人国产SUV,一区二区三区在线亚洲,欧美中文字幕在线二区,蜜乳av一区二区蜜臀,亚洲自偷精品视频自拍,中文字幕日韩一区二区不卡,日本三级香港三级人妇gg在线
      File:cn/goods-list.htm
      Method:query.table(columns,*where,*order,*top)
      關鍵字 'ORDER' 附近有語法錯誤。 select * FROM cpcatalog WHERE ParentId=0 and Status>0 and ORDER BY Grade desc,CatalogId desc
      數據庫執行錯誤
      cn/xmls/frame.xmls
      $sub main(){
      $shell.call($get(method));
      }

      //多層分類,兩層
      $sub GoodsCatalog(format,format1){
      @listta=$cache.get(menumob);

      @querygcata=$query(catalog,goods);
      @
      tablectmn=@querygcata.table(*,['ParentId=0 and Status>0 and {*AreaId = $shell.getData(cn)}'],['Grade desc,CatalogId desc']);
      @listta=@tablectmn.format(@format){
      @tablect=@querygcata.table(*,['{*ParentId = $var[CatalogId]} and Status>0'],['Grade desc,CatalogId desc']);
      @listtb=@tablect.format(@format1);
      }
      $cache.set(menumob,@listta,60000);
      $return(@listta);
      }
      $sub GoodsCatalogPc(format,format1){
      @listta=$cache.get(menupc);
      $if(@listta<>$null){
      $return(@listta);
      }
      @querygcata=$query(...