Hi,
Any ideas why I get an error when i use ORDER BY in an UPDATE statement? Also is there anywhere i can lookup the error codes?
UPDATE `Subscriptions` SET picks=picks+1 WHERE (username = 'webmaster' AND picksdatabasename = 'BetaTestService') ORDER BY subscriptionid ASC
ADODB.Connection.1 error '80004005'
SQLState: 42000 Native Error Code: 1064 [TCX][MyODBC]You have an error in your SQL syntax near 'ORDER BY price ASC' at line 1
Are you using MySQL 3.23? ORDER BY for UPDATE was introduced in 4.0.0.
Thanks in advance. Martin
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]