RE: UPDATE and ORDER BY

Thanks for all your replies. I'll have to use the 2 query approach. Regards Martin "Mike Hillyer" <[EMAIL PROTECTED]> 23/06/2003 23:22 To: <[EMAIL PROTECTED]>, "wayne" <[EMAIL PROTECTED]> cc: <[EMAIL PROTECTED]> Subject:RE: UPDATE and ORDER BY Then

RE: UPDATE and ORDER BY

Hi, I left out the LIMIT 1 in the example I copied... I only want the first occurance updated. "wayne" <[EMAIL PROTECTED]> 23/06/2003 23:22 To: <[EMAIL PROTECTED]> cc: <[EMAIL PROTECTED]> Subject:RE: UPDATE and ORDER BY Have you tried it without i

UPDATE and ORDER BY

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 er

Re: Fulltext Search Problem

t; a MATCH with another condition? > > Any ideas, or is the only solution to run the first query, store the results in > a temp table, and then run a 2nd query. > > Regards > Martin Curmi > > > > - >