日期:2014-05-17  浏览次数:20815 次

在线等 提交不了 所以分数都给了 请帮我
看下我代码吧     数据提交不了

我的代码:

<%
Set   Con=Server.CreateObject( "ADODB.connection ")
          Con.Open= "File   Name=C:\Inetpub\wwwroot\shopping\data\db.udl "  
action=trim(Request( "action "))
xm=trim(Request( "xm "))
sheng=trim(Request( "sheng "))
shi=trim(Request( "shi "))
xz=trim(Request( "xz "))
cun=trim(Request( "cun "))
mph=trim(Request( "mph "))
yb=trim(Request( "yb "))
gzdw=trim(Request( "gzdw "))
lxdh=trim(Request( "lxdh "))
dzyx=trim(Request( "dzyx "))

if   action= "index "   then   checkpass=true
if   len(xm) <1   then   checkpass=false
if   len(sheng) <1   then   checkpass=false
if   len(shi) <1   then   checkpass=false
if   len(xz) <1   then   checkpass=false
if   len(cun) <1   then   checkpass=false
if   len(yb) <1   then   checkpass=false
if   len(gzdw) <1   then   checkpass=false
if   len(lxdh) <1   then   checkpass=false
if   len(dzyx) <1   then   checkpass=false

if   checkpass   then
          query= "insert   into   xinxi(xm, "
  query=query& "sheng, "
  query=query& "shi, "
  query=query& "xz, "
  query=query& "cun, "
  query=query& "mph, "
  query=query& "yb, "
  query=query& "gzdw, "
  query=query& "lxdh, "
  query=query& "dzyx)values( ' "
  query=query&xm& " ', ' "
  query=query&sheng& " ', ' "
  query=query&shi& " ', ' "
  query=query&xz& " ', ' "
  query=query&cun& " ', ' "
  query=query&mph& " ', ' "
  query=query&yb& " ', ' "
  query=query&gzdw& " ', ' "
  query=query&lxdh& " ', ' "
  query=query&dzyx& " ') ' "
 
  Con.Execute   query
 
  Response.Redirect "index.asp "
  end   if

%>

<!DOCTYPE   HTML   PUBLIC   "-//W3C//DTD   HTML   4.01   Transitional//EN "   >

<html>
<head>
<meta   http-equiv= "Content-Type "   content= "text/html;   charset=gb2312 ">
<title> 订购页面 </title>
<style   type= "text/css ">
<!--
.style7   {
font-size:   xx-large;
font-weight:   bold;
}
.style11   {font-size:   18px}
-->
</style>
</head>


<body>
<table   width= "684 "   border= "0 "   align= "center "   cellpadding= "0 "   cellspacing= "0 ">
    <tr   bgcolor= "#669999 ">
        <td   he