another shocker error: Updatable query required

[SmagO]

Hi all,
I have a terrible error.
I put up a web site using ASP and it worked fine initially. Then one day I get an error that says an UPDATABLE query is required whenever an update query is written in my code.

The sql query is definiately correct and it workd off my local PC and personal web server.

anyone ever experienced this before?

It happens on every single update query
eg

sqlq = "UPDATE thread set showme = FALSE where threadID " &
indexStr
OBJdbConnection.Execute(SQLq)

...and then i get the error...bizarre

[monte96]

Change this:
OBJdbConnection.Execute(SQLq)

to this:
OBJdbConnection.Execute SQLq

Use the parenthesis only when you are returning something (like in this case a recordset). VB isn't as picky about this but VBScript is. VBScript will only allow you to use parenthesis in a sub call if you use the Call keyword.

[SmagO]

do u have any idea how come it worked initially even with the brackets. Also on my PC using Personal Web Server there seems to be no problemo. any ideas as to why?

[monte96]

Did you perhaps have an 'On Error Resume Next' statement on the page? Dunno why it initially worked..

[SmagO]

no on error resume

[kayoca]

Make sure your directory where your MDB is located have read and write access.

[JoshT]

Use the parenthesis only when you are returning something (like in this case a recordset). VB isn't as picky about this but VBScript is. VBScript will only allow you to use parenthesis in a sub call if you use the Call keyword.

Isn't it the opposite, though? VB is picky but VBscript doesn't care.