UC知道SQL语句转换成ACC的问题
来源：百度知道 编辑：UC知道 时间：2024/07/03 03:23:36
代码如下，Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
不知道错在哪里，请高人帮忙
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#Include File="conn1.asp"-->
<!--#Include File="char.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
If Request.Form("lpmc")<>"" Then
fwlx=int(Request.Form("fwlx"))
huxing=int(Request.Form("huxing"))
mianji=int(Request.Form("mianji"))
szqx=int(Request.Form("szqx"))
szqy=int(Request.Form("szqy"))
lpmc=Strcheck(Request.Form("lpmc"))
dprice=int(Request.Form("dprice"))
zprice=
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
不知道错在哪里，请高人帮忙
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#Include File="conn1.asp"-->
<!--#Include File="char.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
If Request.Form("lpmc")<>"" Then
fwlx=int(Request.Form("fwlx"))
huxing=int(Request.Form("huxing"))
mianji=int(Request.Form("mianji"))
szqx=int(Request.Form("szqx"))
szqy=int(Request.Form("szqy"))
lpmc=Strcheck(Request.Form("lpmc"))
dprice=int(Request.Form("dprice"))
zprice=
如果 你字段数据类型正确的情况下这样 修改strsql：
strsql="Insert into tblsale(housetype,doortype,acreage,county,area,buildname,unitprice,totalprice,payment,info,datetime,linkman,tel,email,address,saleer,sctime)values("
strsql=strsql&fwlx&","&huxing&","&mianji&","&szqx&","&szqy&","&lpmc&","
strsql=strsql&dprice&","&zprice&","&payment&","&info&",'"& Intime &"',"&linkman&","&tel&","&email&","&add&","&saleer&",#"&FormatDateTime(now(),2)&"#)"
检查下数据类型是否都对，另外，VALUES前面加空格