var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
Has any one got any ideas why it is erroring like this. Thanks
Where did you put the value inside MM_editQuery variable? Please post from there.