File:booth.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。
select top 1 Title FROM excontent WHERE
数据库执行错误
xmls/exhibition.xmls
...s="boo_cen">
{@tp}
</div>
<div class="boo_as">
<a href="{~./company/bookingexhibition/*CompanyId_*ContentId}">Exhibition appointment</a>
<a href="{~./company/home/*CompanyId}">Enter the store</a>
</div>
</li>
#];
@Title=$argv(0);
@CatalogId=$argv(1);
//@query=$query(content,booth);
@query=$query(makeappointment,booth);
@queryc=$query(company,user);
@querygood=$query(goods,goods);
@tp1=$string;
@tp2=$string;
@queryca=$query(content,exhibi);
@queryca[ContentId]=@Title;
@Title=@queryca.scalar(Title,['{*ContentId =}']);
@query[Title]=@Title;
$if(@CatalogId){
@Directory=[",{@CatalogId},"];
@queryuser=$query(user,user);
@UserIdList=$string();
@usertable=@queryuser.dataTable(['select UserId from ususer where {*Directory like @Directory} and Status>0']);
$if(@usertable.count()>0){
@usertable.foreach(){
@id=$var[UserId];
$if(@id){
@UserIdList.append(@id);
@UserIdList.append(\,);
}
}
}
@UserIdList=@UserIdList.remove(-1);
@CompanyIdList=$string...