急救:ASP中会员与非会员问题.
问题是这样的,程序使用ASP+ACCESS,在会员状态下订购的产品能够正常显示订购信息,但是非会员情况下任何定购信息都不能显示.
请看程序代码:
会员状态下代码如下:
<%
if request.cookies("lined")("username")<>"" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select count(*) as rec_count from orders where username='"&request.cookies("lined")("username")&"' and zhuangtai=7",conn,1,1
rec_count=rs("rec_count")
rs.close
rs.open "select sum(zonger) as zongji from orders where username='"&request.cookies("lined")("username")&"' and zhuangtai=7",conn,1,1
%>
您的购物车有<%=rec_count%>件商品
总金额:
<%
dim str
str=formatnumber(""&rs("zongji")&"","1",-1)
response.write(str)
%>元
<%rs.close
set rs=nothing
else
%>
非会员状态下:
<%
if request.cookies("lined")("username")="" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select count(*) as rec_count from orders where username='"&request.cookies("lined")("username")&"' and zhuangtai=7",conn,1,1
rec_count=rs("rec_count")
rs.close
rs.open "select sum(zonger) as zongji from orders where username='"&request.cookies("lined")("username")&"' and zhuangtai=7",conn,1,1
%>
%>
您的购物车有<%=rec_count%>件商品
总金额:
<%
dim str
str=formatnumber(""&rs("zongji")&"","1",-1)
response.write(str)
%>元
<%
rs.close
set rs=nothing
%>
<%end if%>
<%end if%>
登陆会员后,会员状态下显示正常,退出会员就不正常了,请问各位大侠我这个问题因该怎么解决?谢谢了,在线等.