curt22 Posted April 7, 2007 Share Posted April 7, 2007 I have a script that is made to update information in a database but I always get a error from this line: set strSQL2 = "Update titles set title='" & title & "' set type ='" & types & "' set price = '"& price & "' set notes = '" & notes & "' where title_id = '" & id & "'" it is always either an object required error or a scipt error.What is wrong? Quote Link to comment Share on other sites More sharing options...
trq Posted April 8, 2007 Share Posted April 8, 2007 Assuming your using vbscript, there is no such function as set. Try... strSQL2 = "UPDATE titles SET title='" & title & "' SET type ='" & types & "' SET price = '" & price & "' SET notes = '" & notes & "' WHERE title_id = '" & id & "'" If your still having problems, post the line which actually executes this query. PS: Note I also changed SQL specific instructions to caps. This just makes your queries easier to read. Quote Link to comment Share on other sites More sharing options...
MiRed Posted July 8, 2012 Share Posted July 8, 2012 Hi, I get the same error but from the following code: set rs = oConn.execute (updatequery,lngRecs,1) any ideas? Thanks in advance Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted July 8, 2012 Share Posted July 8, 2012 any ideas? Yes. Start a new thread for your problem, with your own code and errors instead of resurrecting one that's over 5 years old. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.