File:cn/accommodation-det.htm
Method:query.map(columns,*where,*order)
'=' 附近有语法错误。
select top 1 * FROM cpproduct WHERE LeaseStatus>0 and ProductId=
数据库执行错误
cn/xmls/house.xmls
...//////////////////////////////////////////////////房源详情
$sub HouseDetail(){
@house=$query(product,product);
@region=$query(region,product);
@catalog=$query(catalog,product);
@deploy=$query(deploy,product);
@school=$query(school,product);
@school=$query(school,product);
@community=$query(community,product);
@hotarea=$query(hotarea,product);
@landmark=$query(landmark,product);
@metro=$query(metro,product);
@brokersession=$query(brokersession,product);
@house[ProductId]=$get(id);
@houseDetail=@house.map(*,['LeaseStatus>0 and ProductId={*ProductId}']);
@houseType=@catalog.scalar(CncatalogName,['CatalogId={@houseDetail[CatalogId]}']);
@houseTypeUrl=$join(["accommodation.html?CatalogId="],@houseDetail[CatalogId]);
//负责业务信息
@queryuser=$query(user,user);
@userMap=@queryuser.dataMap(['select * from {#0} where UserId={@houseDetail[UserId]}']);
$if(@userMap){
@userUsername=@userMap[Username];
@userPic=@userMap[Pic];
@userMobile=@userMap[Mobile];
}
$else{
@userUs...