Re: Help I am getting an error when I run my insert statement

Imposter!

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Arnie" <99yoda@xxxxxxxxxxxxxxxx> wrote in message
news:u0e%23N%23XHHHA.3616@xxxxxxxxxxxxxxxxxxxxxxx
Try the OLEDB group?


"Tescumeh" <tescumeh@xxxxxxxxx> wrote in message
news:1165868180.115810.136290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?





.

Relevant Pages

  • Re: SQL Server Express and Pubs DB
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... You can't help someone get up a hill without getting a little closer to ... for SQL Server 2005? ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Server Express and Pubs DB
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... You can't help someone get up a hill without getting a little closer to the ... for SQL Server 2005? ...
    (microsoft.public.sqlserver.msde)
  • Re: Server Pack 4
    ... SELECT serverproperty('ProductLevel') ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... You can't help someone get up a hill without getting a little closer to the ...
    (microsoft.public.sqlserver.clients)
  • Re: How to check if SP1 is installed?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... You can't help someone get up a hill without getting a little closer to the ... not SQL Server 2005? ...
    (microsoft.public.sqlserver.setup)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
Loading