Re: [GENERAL] Update Query doesn't affect all records

2009-08-06 Thread Alban Hertroys
On 5 Aug 2009, at 19:27, Scott Marlowe wrote: On Wed, Aug 5, 2009 at 6:56 AM, Csaba Nagy wrote: Hi Andor, On Wed, 2009-08-05 at 14:15 +0200, Schindler Andor wrote: Can anyone tell me, how this is possible? If we insert 12 on the end, then it decreases, but 11 remains the same. The problem on

Re: [GENERAL] Update Query doesn't affect all records

2009-08-05 Thread Leif B. Kristensen
On Wednesday 5. August 2009, Sam Mason wrote: >On Wed, Aug 05, 2009 at 11:27:52AM -0600, Scott Marlowe wrote: >> Otherwise we're blind men describing an elephant. > >Interesting analogy, not heard that one before! http://www.noogenesis.com/pineapple/blind_men_elephant.html -- Leif Biberg Kristens

Re: [GENERAL] Update Query doesn't affect all records

2009-08-05 Thread Sam Mason
On Wed, Aug 05, 2009 at 11:27:52AM -0600, Scott Marlowe wrote: > On Wed, Aug 5, 2009 at 6:56 AM, Csaba Nagy wrote: > > On Wed, 2009-08-05 at 14:15 +0200, Schindler Andor wrote: > >> Can anyone tell me, how this is possible? If we insert 12 on the end, then > >> it decreases, but 11 remains the same

Re: [GENERAL] Update Query doesn't affect all records

2009-08-05 Thread Scott Marlowe
On Wed, Aug 5, 2009 at 6:56 AM, Csaba Nagy wrote: > Hi Andor, > > On Wed, 2009-08-05 at 14:15 +0200, Schindler Andor wrote: >> Can anyone tell me, how this is possible? If we insert 12 on the end, then >> it decreases, but 11 remains the same. The problem only occurs, when the >> where condition co

Re: [GENERAL] Update Query doesn't affect all records

2009-08-05 Thread Csaba Nagy
Hi Andor, On Wed, 2009-08-05 at 14:15 +0200, Schindler Andor wrote: > Can anyone tell me, how this is possible? If we insert 12 on the end, then > it decreases, but 11 remains the same. The problem only occurs, when the > where condition contains "sorrend > 9" or less. I bet the "sorrend" column

Re: [GENERAL] Update Query doesn't affect all records

2009-08-05 Thread Scott Marlowe
On Wed, Aug 5, 2009 at 6:15 AM, Schindler Andor wrote: > Hi! > > I've got this update query: > > http://pastebin.com/m2e29990 > > Can anyone tell me, how this is possible? If we insert 12 on the end, then > it decreases, but 11 remains the same. The problem only occurs, when the > where condition c