UC知道一个超难asp问题
来源：百度知道 编辑：UC知道 时间：2024/06/06 12:48:28
<!--#include file="conn.asp"-->
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
<!--
table {
font-size: 9pt;
text-decoration: none;
border: 1px solid #000000;
}
-->
</style>
<table width="398" border="0" align="center" cellpadding="3" cellspacing="0">
<tr align="center" bgcolor="#006699">
<td width="384" height="20"><font color="#FFFFFF">客户管理系统</font></td>
</tr>
<tr align="center">
<td><%
name=trim(request.form("name"))
sql="select * from reg where name='"&name&"'"
set rs=db.execute(sql)
'-------------------------------------------------------
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
<!--
table {
font-size: 9pt;
text-decoration: none;
border: 1px solid #000000;
}
-->
</style>
<table width="398" border="0" align="center" cellpadding="3" cellspacing="0">
<tr align="center" bgcolor="#006699">
<td width="384" height="20"><font color="#FFFFFF">客户管理系统</font></td>
</tr>
<tr align="center">
<td><%
name=trim(request.form("name"))
sql="select * from reg where name='"&name&"'"
set rs=db.execute(sql)
'-------------------------------------------------------
不是大侠，你可以试试把SQL写成一行，不换行，像这样
missme = "'" & name & "','" & quyu & "','" & tel & "','" & person & "','" & zhiwei & "','" & address & "','" & email & "','" & faren & "','" & jyfw & "','" & qylx&"','" & hangye & "','" & zczj & "','" & nyye & "','" & zzc & "','" & ygrs & "','" & xsfzr & "','" & qyfzr & "','" & content & "'"
insertsql="insert into reg(name,quyu,tel,person,zhiwei,address,email,faren,jyfw,qylx,hangye,zczj,nyye,zzc,ygrs,xsfzr,qyfzr,content) values(" & missme & ")"
db.execute(insertsql)