File:personal center.html
Method:query.map(columns,*where,*order)
关键字 'and' 附近有语法错误。 select top 1 * FROM ususer WHERE UserId= and AreaId=1
数据库执行错误
xmls/member.xmls
...listTag=$list();
@listTag.add(0,请选择);
@table.fillList(@listTag,CityId,CityName);
@mapTag=$map();
@mapTag[call]=input;
@mapTag[id]=Province;
@mapTag[type]=select;
@mapTag[class]=kdhw;
@mapTag[name]=Province;
@mapTag[options]=@listTag;
@mapTag[onchange]=["changeProvince(this,'{#path}',0)"];
@Province=$control.run(@mapTag);
$return(@Province);
}

//用户信息
$sub userinfo(){
@query=$query(user,user);
@query[UserId]=$http.getSession(UserID);
//语言
@AreaId=1;
@query[AreaId]=@AreaId;
@
rowuser=@query.map(*,['UserId={*UserId} and AreaId={*AreaId}']);
$if(@rowuser==$null){
@rowuser=$map();
}

@ProcinceName=@rowuser[Province];
@CityName=@rowuser[City];
@queryorder=$query(order,order);
@queryorder[UserId]=$http.getSession(UserID);
@queryorder[OrderStatus]=0;
@queryorder[AreaId]=@AreaId;
@nopay=@queryorder.scalar(['count(*)'],['UserId={*UserId} and OrderStatus={*OrderStatus} and AreaId={*AreaId}']);
@LastLoginDate=@rowuser[LastLoginDate];
@LastLoginDate=$datetime(@Last...