File:en/accommodation-det.htm
Method:query.scalar(columns,*where,*order)
'=' 附近有语法错误。 select top 1 RegionName FROM cpregion WHERE RegionId=
数据库执行错误
xmls/house.xmls
...ame=$string();
@hotareaCnName=$string();
@communityMap=@community.map(*,['CommunityId={@houseDetail[Community]}']);

@areaUrl=$join(["accommodation.html?CatalogId="],@houseDetail[CatalogId],["&region="],@communityMap[Region]);;

$if(@communityMap){
@communityNameY=@communityMap[CommunityName];
@cnCommunityName=@communityMap[CnCommunityName];
@longitude=@communityMap[Longitude];
@latitude=@communityMap[Latitude];
@area=@region.scalar(RegionName,['RegionId={@communityMap[Region]}']);
@
hotareaName=@region.scalar(RegionName,['RegionId={@communityMap[Hotarea]}']);
@hotareaCnName=@region.scalar(CnRegionName,['RegionId={@communityMap[Hotarea]}']);
@City=@region.scalar(RegionName,['RegionId={@communityMap[City]}']);
@1=@communityMap[Region];
@2=@communityMap[Hotarea];
@3=@communityMap[City];
//@hotareaName=@hotarea.scalar(HotareaName,['HotareaId={@communityMap[Hotarea]}']);
}
//经纪人
@brokerName=$string();
@brokerPhone=$string();
$if(@houseDetail[Broker]){
@brokerSessionM...