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 Thanks in advance. Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
