https://www.webmaster-forums.net/crss/node/1023769 en https://www.webmaster-forums.net/web-database-development/why-update-times-out#comment-1145943 <p>oh that ASP hum</p> Wed, 18 Feb 2004 21:36:00 +0000 druagord comment 1145943 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/why-update-times-out#comment-1145940 <p>Hi Mark,</p> <p>Yes I tried executing from SQLConsole and it ran fine. It took me most of the night but I found out in the end: just before the code above I opened the same record into Recordset1 but didn't close Recordset1 till after the code above so the row was locked out when the code tried to update it.</p> <p>D'oh!</p> Wed, 18 Feb 2004 21:28:37 +0000 sjjs comment 1145940 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/why-update-times-out#comment-1145873 <p>Have you tried executing the query from a command prompt?<br /> If your using PHP to run the query, have you tried echoing mysql_error()?<br /> Does your mysql user have permissions to perform an UPDATE query?</p> Tue, 17 Feb 2004 17:19:10 +0000 Mark Hensler comment 1145873 at https://www.webmaster-forums.net