File:vip-address.html
Method:query.table(columns,*where,*order,*top)
关键字 'and' 附近有语法错误。 select top 6 * FROM usaddress WHERE UserId= and AreaId=1 ORDER BY Status desc
数据库执行错误
xmls/member.xmls
...ser[LastLoginDate];
@LastLoginDate=$datetime(@LastLoginDate);
@Modifiedstring=@LastLoginDate.toString(yyyy-MM-dd);
@sexstring=$empty;
@Sex=@rowuser[Sex];
$if(@Sex==0){
@sexstring=女士;
}
$if(@Sex==1){
@sexstring=先生;
}

$return($empty);
}

//用户收货地址
$sub Useraddresslist(){
@queryaddress=$query(address,user);
@queryCity=$query(city,logistics);
@formatadd=[#
{@uaddress}
#];
@queryaddress[UserId]=$http.getSession(UserId);
@AreaId=$shell[AreaId];
@queryaddress[AreaId]=@AreaId;
@
tablect=@queryaddress.table(*,['UserId={*UserId} and AreaId=1'],['Status desc'],6);
@uaddresslist=@tablect.format(@formatadd){
@Province=$var[Province];
@City=$var[City];
@adstatus=$var[Status];
@AddressD=$var[AddressId];
@uaddress=["
<li class="pull-left">
<a class="disb por" href="javascript:;">
<input class="poa vpaddin" type="radio" name="AddressId" checked="checked" value="{*AddressId}" cityName="{*Country}"/>
<p>{*Province} {*City} ({*Fullname} 收)</p>
<p>{*Address}</p>
<p>{*Mo...