sql="select * from huiyuan where (month(shenri)="&month(date())&" and day(shenri)>="&day(date())&" and day(shenri)<="&day(date())&"+"&tiqian&" and username="&nowname&" and card="&nowcard&" and yinyan='阳') or (month(shenri)="&WDateToEDate(now(),"1")&" and day(shenri)>="&WDateToEDate(now(),"2")&" and day(shenri)<="&WDateToEDate(now(),"2")&"+"&tiqian&" and username="&nowname&" and card="&nowcard&" and yinyan='阴')"
set rs=conn.execute(sql)
if not (rs.bof or rs.eof) then
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)*2&"-"&nowdel&" where id="&nowhuiyuan)
else
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)&"-"&nowdel&" where id="&nowhuiyuan)
end if
原来的代码比较复杂,我给精简成这样了依旧出错,所有代码都在这里了,其它代码和此代码段无关。只要去掉
set rs=conn.execute(sql)
if not (rs.bof or rs.eof) then
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)*2&"-"&nowdel&" where id="&nowhuiyuan)
else
end if
只留
sql="select * from huiyuan where (month(shenri)="&month(date())&" and day(shenri)>="&day(date())&" and day(shenri)<="&day(date())&"+"&tiqian&" and username="&nowname&" and card="&nowcard&" and yinyan='阳') or (month(shenri)="&WDateToEDate(now(),"1")&" and day(shenri)>="&WDateToEDate(now(),"2")&" and day(shenri)<="&WDateToEDate(now(),"2")&"+"&tiqian&" and username="&nowname&" and card="&nowcard&" and yinyan='阴')"
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)*2&"-"&nowdel&" where id="&nowhuiyuan)
就不出错,求大侠指教,小弟不胜感激!
错误提示是:
500 - 内部服务器错误。
您查找的资源存在问题,因而无法显示。
set rs=conn.execute(sql)
if not (rs.bof or rs.eof) then
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)*2&"-"&nowdel&" where id="&nowhuiyuan)
else
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)&"-"&nowdel&" where id="&nowhuiyuan)
end if
原来的代码比较复杂,我给精简成这样了依旧出错,所有代码都在这里了,其它代码和此代码段无关。只要去掉
set rs=conn.execute(sql)
if not (rs.bof or rs.eof) then
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)*2&"-"&nowdel&" where id="&nowhuiyuan)
else
end if
只留
sql="select * from huiyuan where (month(shenri)="&month(date())&" and day(shenri)>="&day(date())&" and day(shenri)<="&day(date())&"+"&tiqian&" and username="&nowname&" and card="&nowcard&" and yinyan='阳') or (month(shenri)="&WDateToEDate(now(),"1")&" and day(shenri)>="&WDateToEDate(now(),"2")&" and day(shenri)<="&WDateToEDate(now(),"2")&"+"&tiqian&" and username="&nowname&" and card="&nowcard&" and yinyan='阴')"
conn.execute("update huiyuan set jifen=jifen+"&int(totalprice/50)*2&"-"&nowdel&" where id="&nowhuiyuan)
就不出错,求大侠指教,小弟不胜感激!
错误提示是:
500 - 内部服务器错误。
您查找的资源存在问题,因而无法显示。