28,406
社区成员
发帖
与我相关
我的任务
分享编辑新闻数据时的一点问题
<%dim rs1
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select * from expert where id="&id,conn,1,1
%>
<body>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#6B8FC8">
<tr>
<td bgcolor="#6B8FC8" align="center"><font color="#FFFFFF">编辑产品</font></td>
</tr>
<tr><form name="myform" method="post" action="saveaddexpert.asp?action=edit&id=<%=id%>">
<td bgcolor="#FFFFFF">
<table width="963" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td align="right" width="129"> 产品型号</td>
<td width="826" colspan="2"><input name="name" type="text" id="name" size="30" value="<%=trim(rs1("name"))%>"></td>
</tr>
<tr>
<td align="right" width="129"> 所属类目</td>
<td width="826" colspan="2">
<select name="keshi">
<%
sql="select id,name,mark from ks order by id"
set rs=conn.execute (sql)
set id1=rs(0)
set name=rs(1)
set mark=rs(2)
do while not rs.eof
%>
<option value="<%=id1%>" <%if id1=cint(keshi) then response.write "selected" %>><%=name%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select>
keshi为expert的字段，为什么这个字段读取不了呢？
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select * from expert where id="&id,conn,1,1
%>
<body>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#6B8FC8">
<tr>
<td bgcolor="#6B8FC8" align="center"><font color="#FFFFFF">编辑产品</font></td>
</tr>
<tr><form name="myform" method="post" action="saveaddexpert.asp?action=edit&id=<%=id%>">
<td bgcolor="#FFFFFF">
<table width="963" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td align="right" width="129"> 产品型号</td>
<td width="826" colspan="2"><input name="name" type="text" id="name" size="30" value="<%=trim(rs1("name"))%>"></td>
</tr>
<tr>
<td align="right" width="129"> 所属类目</td>
<td width="826" colspan="2">
<select name="keshi">
<%
sql="select id,name,mark from ks order by id"
set rs=conn.execute (sql)
set id1=rs(0)
set name=rs(1)
set mark=rs(2)
do while not rs.eof
%>
<option value="<%=id1%>" <%if id1=cint(keshi) then response.write "selected" %>><%=name%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select>
keshi为expert的字段，为什么这个字段读取不了呢？
...全文
请发表友善的回复…
发表回复
