Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007

    Question Unanswered: Syntax error in INSERT INTO statement

    Hi. I am using dreamweaver and and access database.

    I have sucessfully created a login page etc...

    However i now wish to create a page which can insert data into the database. I used dreamweaver to generate the code for this. When previewing the page i recive a error of the following form:

    Microsoft JET Database Engine error '80040e14'

    Syntax error in INSERT INTO statement.

    /regis.asp, line 99

    The line of code on that line is as follows:

    96 Set MM_editCmd = Server.CreateObject("ADODB.Command")
    97 MM_editCmd.ActiveConnection = MM_editConnection
    98 MM_editCmd.CommandText = MM_editQuery
    99 MM_editCmd.Execute
    100 MM_editCmd.ActiveConnection.Close

    Has any one got any ideas why it is erroring like this. Thanks

  2. #2
    Join Date
    Apr 2007
    Where did you put the value inside MM_editQuery variable? Please post from there.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts