这句话哪里错了～

[oldwatch]

<%
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.open connstr
Employee=session("Employee_ID")
sql = "select * from customers where Employee_ID = '"&Employee&"'"
rs.open sql,conn,1
%>
<!--**************身份验证部分****************-->
<%
set rs = conn.execute(sql)
Customer_Name = request("Customer_Name")
State = request("State")
City = request("City")
Address = request("Address")
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
估计是sql = "select * from customers where Employee_ID = '"&Employee&"'" 出错，得出结果没有select到，出来的数据全是customers的，没有判断到，大家帮帮忙看看问题在哪里～◎◎

[oldwatch]

没人帮帮忙吗？

[zjcxc]

'不明白,没有select到是什么意思?

'试试改为

<%
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.open connstr
Employee=session("Employee_ID")
sql = "select * from customers where Employee_ID = '"&Employee&"'"
rs.open sql,conn,1
%>

<!--**************身份验证部分****************-->
<%

<!-- 去掉下面句-->
'set rs = conn.execute(sql) --去掉这句试试,既然上面已经打开,这里这样多余.


Customer_Name = request("Customer_Name")
State = request("State")
City = request("City")
Address = request("Address")
rs.close
set rs = nothing
conn.close
set conn = nothing
%>

[pengdali]

sql = "select * from customers where Employee_ID = '"&Employee&"'"
rs.open sql,conn,1
%>
<!--**************身份验证部分****************-->
<%
Customer_Name = rs.fields(1).value

先这样试试可以吗？