Category: Client & Server Side Scripting (PHP, ASP, JavaScript)
Must use an updateable query ??????: HTML, CSS, JavaScript, PHP
Hi ,
The below code
strSQL2 = "INSERT INTO commentsA (studentName,studenteMail,portal,referal,comments,entryMonth,reason) VALUES ('"&iRS("studentName")&"','"&iRS("studenteMail")&"','"&iRS("portal")&"','"&iRS("referal")&"','"&iRS("comments")&"',"&iRS("entryMonth")&",'"&iRS("reason")&"')"
Set kuUpdate = Server.CreateObject("ADODB.Connection")
kuUpdate.Open Conn
(line 27) kuUpdate.Execute strSQL2
kuUpdate.Close
cnt=cnt+1
is producing the below error
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/webwork/Student Space/archive-action.asp, line 27
Could someone better explain this please
cheers.
O Dear,
There is nothing wrong with your query. Actually the folder is write protectedin which your database is lying. You must set the write permissions on tht folder. Ask your hosting provider or use your hosting control panel for this. There must be some options for these changes.