File:en/ProductsThr.htm
Method:query.dataMap(sql)
' or GoodsCode=' 附近有语法错误。
字符串 ' ' 后的引号不完整。
select * from cpgoods where CAS='22'-Cyclouridine' or GoodsCode='22'-Cyclouridine' or GoodsName='22'-Cyclouridine'
数据库执行错误
themes/theme/en/xmls/engoods.xmls
...@brandMap=$map();
}
@queryuser=$query(user,user);
@queryuser[UserId]=@UserId;
@userMap=@queryuser.map(['UserGrade,UserType'],['UserId={*UserId}']);
$if(!@userMap){
@userMap[UserGrade]=0;
@userMap[UserType]=0;
}
@pro=$call(~apps/user/shopcart.xmls);
@pro.getPormotion(@brandMap[PromotionIds],@cataMap[PromotionIds],@itemMap[PromotionIds],@itemMap[Price],1,@userMap[UserGrade],@userMap[UserType]);
}
//��Ʒ����
$sub viewGoods(){
@queryGoods=$query(goods,goods);
@Guid=$argv(0,$null);
@rowGoods=@queryGoods.dataMap(['select * from cpgoods where CAS='{@Guid}' or GoodsCode='{@Guid}' or GoodsName='{@Guid}' ']);
@CatalogName=@queryGoods.dataScalar(['select EnCatalogName from cpcatalog where CatalogId={@rowGoods[CatalogId]}']);
@pid=@queryGoods.dataScalar(['select ParentId from cpcatalog where CatalogId={@rowGoods[CatalogId]}']);
@CATALOGNAME=@queryGoods.dataScalar(['select EnCatalogName from cpcatalog where CatalogId={@pid}']);
//�ܷ�����
@pid=@queryGoods.dataScalar(['select ...