看看错在哪里~~
<%
sql = "SELECT * FROM form where key = '" &trim(key)& "' or key1='" &trim(key)& "' "
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%>
<form name="form1" method="post" action="change.asp">
<table width="80%" border="0" align="center" cellspacing="5">
<tr>
<td width="15%" align="center" valign="middle"><span class="style5">型号</span></td>
<td width="85%"><input name="key" type="text" value="<%=rs(key)%>">
</td>
</tr>
<tr>
<td align="center" valign="middle"><span class="style5">简称</span></td>
<td><input name="key1" type="text" value="<%=rs("key1")%>"> </td>
</tr>
<tr>
<td align="center" valign="middle"><span class="style5">品名</span></td>
<td><input name="textfield3" type="text" value="<%=rs("pm")%>"></td>
</tr>
<tr>
<td align="center" valign="middle"><span class="style5">价格</span></td>
<td><input name="textfield4" type="text" value="<%=rs("jg")%>"></td>
</tr>
<tr>
<td align="center" valign="middle"><span class="style5">全套</span></td>
<td><textarea name="textarea" cols="50" rows="5"><%=rs("qt")%></textarea></td>
</tr>
<tr>
<td align="center" valign="middle"><span class="style5">描述</span></td>
<td><textarea name="textarea2" cols="50" rows="8"><%=rs("ms")%></textarea></td>
</tr>
<tr>
<td align="center" valign="middle"><span class="style5">包装</span></td>
<td><textarea name="textarea3" cols="50" rows="5"><%=rs("bz")%></textarea></td>
</tr>
<tr>
<td align="center" valign="middle"><span class="style5">优势</span></td>
<td><input name="textfield5" type="text" value="<%=rs("ys")%>" size="50"></td>
</tr>
<tr>
<td colspan="2" align="center" valign="middle">
<input type="submit" name="Submit2" value="修改"></td>
</tr>
</table>
</form>
为什么value="<%=rs("ys")%>" rs返回值是空,不明白.究竟错在哪里,帮忙改改.万分感谢
