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? Link to comment https://forums.phpfreaks.com/topic/46049-asp-getting-script-and-object-required-errors/ 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. Link to comment https://forums.phpfreaks.com/topic/46049-asp-getting-script-and-object-required-errors/#findComment-223912 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 Link to comment https://forums.phpfreaks.com/topic/46049-asp-getting-script-and-object-required-errors/#findComment-1360098 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. Link to comment https://forums.phpfreaks.com/topic/46049-asp-getting-script-and-object-required-errors/#findComment-1360099 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.