File:ybooth.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。
select top 1 ShopType FROM ususer WHERE
数据库执行错误
xmls/exhibition.xmls
...,16,@count,$argv(1,1),#1,3);
@list=@table.format(@format){
$if($var[*index]==7){
@table2=@query.pager(*,['Status>0 and level=1 {?} and {*CatalogId =}'],['Grade desc,ContentId desc'],2,$argv(1,1));
@viplist=@table2.format(@format2);
$if(@viplist){
@viplist=$join(["<li class="none"></li><li class="none"></li>"],@viplist);
}
}
$else{
@viplist=$empty;
}
@href=["{~company/home/$var[CompanyId]}"];
@UserId=@queryc.scalar(UserId,['CompanyId={$var[CompanyId]}']);
@queryu[UserId]=@UserId;
@ShopType=@queryu.scalar(['ShopType'],['{*UserId =}']);
$if(@ShopType==2){
@href=["{~company/Exhibitor/$var[CompanyId]}"];
}
$if(@ShopType==3){
@href=["{~company/certifi/$var[CompanyId]}"];
}
}
@map=$map();
@map[list]=@list;
@map[pager]=@pager;
$if(!@list){
@map[list]=['<div class="cred">Sorry, no product data yet.</div>'];
@map[pager]=$empty;
}
$shell.put(@map);
$return($empty);
}
//展会栏目
$sub excatalog(){
@format=[#
{@con}
#];
@CatalogId=$argv(0,$null);
@query=$quer...