Help I am getting an error when I run my insert statement
- From: "Tescumeh" <tescumeh@xxxxxxxxx>
- Date: 11 Dec 2006 12:16:20 -0800
Please help I am getting the same error no matter how I change my
quotes.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Plan'.
conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
[revfinish],[responsible],[action],[title],[dept],[author],[type])
values ('" & request.Form("startdate") &"' ,"&
Request.Form("finishdate") &" ," & Request.Form("revfinish") & ",'" &
Request.Form("responsible") & "','" & Request.Form("action") & "','" &
Request.Form("title") & "','" & Request.Form("dept") & "','" &
session("empid") & "','" & Request.form("type") & "')")
'set Rs =conn.Execute("SELECT * FROM Equipment")
startdate, finshdate,revfinish are all smalldatetime
[Action], responsible, dept, author, type are all text
title is nvarchar
any Ideas?
.
- Follow-Ups:
- Prev by Date: Re: Messed up SQL 2000 - Error Code 193
- Next by Date: Re: Help I am getting an error when I run my insert statement
- Previous by thread: Re: Messed up SQL 2000 - Error Code 193
- Next by thread: Re: Help I am getting an error when I run my insert statement
- Index(es):
Relevant Pages
|