当前位置: 代码迷 >> vbScript >> 程序取现有行的列信息出错解决思路
  详细解决方案

程序取现有行的列信息出错解决思路

热度:9343   发布时间:2013-02-26 00:00:00.0
程序取现有行的列信息出错
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<% 
  dim ID
  dim rs
  dim sql
  dim Conn
  ConnStr="driver={sql server};server=127.0.0.1;database=tire;uid=sa;pwd=111111"
  set Conn=server.createobject("adodb.connection")
  Conn.Open ConnStr
  Set rs=server.CreateObject("ADODB.recordset")
ID=request.QueryString("产品编号")
  Response.Write("产品编号ID为:"&ID&" <br>")
  sql="select * from chanpin3 where 产品编号='"& ID &"'"
  if request("产品编号")<>"" and Submit<>"提交" then
  rs.Open sql,Conn,1,1
  if rs.EOF or rs.BOF then
  Response.Write("<hr>数据库中暂无资料!")
  Else
  do while not rs.EOF or rs.BOF
  %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改信息</title>
<style type="text/css">
<!--
.STYLE 7{font-size:12px; font-family:"宋体";}
.STYLE 8{font: bolder "宋体"; font-size:12px; color:#990000;}
.STYLE 9{font-size:12px; color:#990000; font-weight:bold;}
.STYLE 10{font-size:12px; color:#FFFFFF; font-weight:bold;}
-->
</style>
</head>
<body>
<div align="center" class="STYLE 7">
<p align="left"><font size="+6"><font face="宋体"><font color="#0000FF" face="幼圆"><img src="head_nJwL_41440b206096.jpg" width="74" height="104" align="middle">产品信息管理系统</font></font></font></p>
<form action='gain.asp?产品编号=<%=rs("产品编号")%>' method="post" name="form1">
<table width="66%" border="1" align="center" bordercolor="#0066FF">
<tr>
<td height="25" colspan="2" background="head_9qb2_41903n206096.jpg"><div align="center"><span class="STYLE 2">修改产品信息</span></div></td></tr>
<tr bordercolor="#FFFFFF"><td width="20%"><div align="center"><span class="STYLE 8">产品编号:</span></div></td>
<td width="80%"><div align="left"><span class="STYLE 7">
<input name="text1" type="text" class="STYLE 7" id="text1" value="<%=rs("产品编号")%>" readonly="false">
</span></div></td></tr>
<tr bordercolor="#FFFFFF">
<td><div align="center"><span class="STYLE 8">产品名称:</span></div></td>
<td><div align="left"><span class="STYLE 7"><input name="text2" type="text" class="STYLE 7" id="text2" value="<%=rs("产品名称")%>" size="40">
</span></div></td></tr>
<tr bordercolor="#FFFFFF"><td><div align="center"><span class="STYLE 8">产品型号:</span></div></td>
<td><div align="left"><input name="text3" type="text" class="STYLE 7" id="text3" value="<%=rs("产品型号")%>" size="50">
</div></td></tr>
<tr bordercolor="#FFFFFF"><td><div align="center"><span class="STYLE 8">制造商:</span></div></td>
  相关解决方案