Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax error in INSERT INTO statement

Status
Not open for further replies.

Kingmarl

Programmer
Mar 22, 2001
48
GB
I keep getting this message every now and again when I make an Insert form. The forms normally work fine, but 1:10 bring back this error (Syntax error in INSERT INTO statement).

I've just started to add bits of my own code & started to hand code a bit, but I know too little about ASP to correct the error. I've tried striping the whole thing off the page and remving any remaining ASP from the page, Then re-building it from scratch, but nothing seems to work.

Any Ideas how I can solve this??? ----------------------------------------
Don't forget to visit for some banging new music from DJ Cumback (ME!)
 
there's only that message? there's no en explaination of the error that shows the sql code? Stevie B. Gibson
 
This is exactly what it says.

"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/linkgroup/guestbook/arse123.asp, line 90"

Line 90 is the Execute command for the INSERT INTO.
(MM_editCmd.Execute)

Please help me.... :-( I'm lost in the huge world of ASP.... Where am I???? ;-) ----------------------------------------
Don't forget to visit for some banging new music from DJ Cumback (ME!)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top