if huiyuanzhanghao<>"" and huiyuanmima<>"" then
        rs.open "select * from 充值卡信息 where 充值卡号码='" & chongzhihaoma & "' and 充值卡密码='" & chongzhimima & "' and 充值卡是否被充值='未使用'",con,1,3
        if rs.bof and rs.eof then
            rs.close
            response.write("充值卡号或密码错误,再者该充值卡已被使用，如有疑问请联系GM!")
            response.end
        else
            youxizhanghao=rs("游戏账号")
            chongzhikaID=rs("充值卡编号")
            chongzhihaoma=rs("充值卡号码")
            chongzhimima=rs("充值卡密码")
            chongzhidianshu=rs("充值卡点数")
            if rs("充值卡是否被充值")="未使用" then
                rs("游戏账号")=huiyuanzhanghao
                rs("充值卡是否被充值")="已使用"
                rs("被充值时间")=Now()   
            end if
            rs.Update
            rs.Close
        end if
        
        rs.open "select * from 充值卡信息 where 充值卡号码='" & chongzhihaoma & "'",con,1,3
        rs.Update
        rs.Close
        response.write "成功充值了"&chongzhidianshu
        response.end


end if
end if
%>


怎么在充值成功了 后 加入一个  执行SQL命令的代码

response.write "成功充值了"&chongzhidianshu

'您前面已有rs.close
可以再次调用数据库的，
rs.open sql,conn,1,3
rs.close
'你要关闭内存不然服务器不堪重负。
set rs = nothing
conn.close
set conn = nothing
response.end

谢谢