80040e14--Syntax error in INSERT INTO statement

80040e14--Syntax error in INSERT INTO statement

This error occurs when the server tries to process a page containing an Insert Record server behavior.

This error typically results from one or more of the following problems with the name of a field, object, or variable in the database:

  • Using a reserved word as a name. Most databases have a set of reserved words. For example, "date" is a reserved word and cannot be used for column names in a database.
  • Using special characters in the name. Examples of special characters include:

    . / * : ! # & - ?

  • Using a space in the name.

The error can also occur when an input mask is defined for an object in the database, and the inserted data does not conform to the mask.

To fix the problem, avoid using reserved words such as "date", "name", "select", "where," and "level" when specifying column names in your database. Also, eliminate spaces and special characters.

See the following web pages for lists of reserved words for common database systems:

  • Microsoft Access at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209187
  • Microsoft SQL Server at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp
  • MySQL at http://dev.mysql.com/doc/mysql/en/reserved-words.html

Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly