数据库处理

来源：百度知道 编辑：UC知道 时间：2024/06/01 06:50:51
大家帮我看看这段代码啊，为什么我提交的时候会出现内部服务器错误啊？？？
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("../Database/00.asa")
JobCategoryID=request.form("JobCategoryID")
SubCompanyID=request.form("SubCompanyID")
ReleaseDate=request.form("ReleaseDate")
PositionName=request.form("PositionName"
PositionNum=request.form("PositionNum")
ValidDate=request.form("ValidDate")
PositionKeyword=request.form("PositionKeyword")
PositionDescription=request.form("PositionDescription")
DutyRequest=request.form("DutyRequest")
Urgent=request.form("Urgent")
exec="insert into PE_Position(JobCategoryID,SubCompanyID,ReleaseDate,PositionName,PositionNum,ValidDate,PositionKeyword,PositionDescription,DutyRequest,Urgent)values('"+JobCategoryID

楼主，我记得前两天我已经帮你解决了这个问题啊 难道你还没有发现错误吗？错误写法：
exec="insert into PE_Position(JobCategoryID,SubCompanyID,ReleaseDate,PositionName,PositionNum,ValidDate,PositionKeyword,PositionDescription,DutyRequest,Urgent)values('"+JobCategoryID+"','"+SubCompanyID+"','"+ReleaseDate+"','"+PositionName+"','"+PositionNum+"','"+ValidDate+"',"+PositionKeyword+",'"+PositionDescription+"','"+DutyRequest+"','"+Urgent+"')"
正确写法：
exec="insert into PE_Position(JobCategoryID,SubCompanyID,WorkPlaceID,ReleaseDate,PositionName,PositionNum,ValidDate,PositionKeyword,PositionDescription,DutyRequest,Urgent) values("&JobCategoryID&","&SubCompanyID&","&WorkPlaceID&",'"&ReleaseDate&"','"&PositionName&"',"&PositionNum&","&ValidDate&",'&quo