在线等 提交不了 所以分数都给了 请帮我
看下我代码吧 数据提交不了
我的代码:
<%
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