Added: May/10/2006 at 4:59am | IP Logged

I've got the following problem.

I get an error at the MyConn.execute(SQL) row in the following script.

Set MyConn = Server.CreateObject("ADODB.Connection")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";"
MyConn.open strConn

dim ID

ID = request.querystring("ID")
dagtxt = request.querystring("dagtxt")

SQL="UPDATE data SET dagbok = '" & request.querystring("dagtxt") & "' WHERE count='" & ID & "'"

 MyConn.Execute(SQL)

I've checked the Value of SQL and it is: UPDATE data SET dagbok = 'test test' WHERE count='1'

Would be very greatful for some help. D.Z.

Added: May/27/2006 at 7:50am | IP Logged

the problem isnt with the sql, it is in the connection settings

the code must be like this

 MyConn.Execute(SQL).LockType = 3

hope this helps

tell me what happens with u

Best Regards