Aji Andri <[EMAIL PROTECTED]> wrote on 04/15/2005 12:34:23 PM: > STY REPORT > > std_nis std_class std_item std_value > 111 1 1 8 > 111 1 2 7 > 111 1 5 6 > 111 1 4 9 > 222 3 1 6 > 222 3 2 5 > 222 3 3 6 > > my fetching result is like that, > how do I update those rows in one single query > > You can't change the results of a query unless you are using some kind of record management object (like an "ADODB.Recordset" object) from within a programming language (like VB or PHP). Even then you aren't updating the results, you are asking your recordset object to produce an UPDATE statement to change the records on the server to match the records you have in your record management object.
The question you pose (and this is the second time you have asked) is too vague to answer. Please provide explicit details as to what you are trying to do and how you are trying to do it. Include any code you have written that failed and why it failed to do what you expected. Only then can you expect a better answer. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
