subject:"\[sqlite\] complex update"

Re: [sqlite] complex update

2012-12-19 Thread Adam DeVita

Thank you for the principal. I had to rewrite a little since I only wanted to affect the rows that were using the max entry. Adam On Tue, Dec 18, 2012 at 12:58 PM, Igor Tandetnik wrote: > On 12/18/2012 12:27 PM, Adam DeVita wrote: >> >> There is a table products where has a

Re: [sqlite] complex update

2012-12-18 Thread Igor Tandetnik

On 12/18/2012 12:27 PM, Adam DeVita wrote: There is a table products where has a location id. Unfortunately duplicate dictionary names got added to list of locations products haslocationid and a bunch of other stuff I can easily get the max (bad) and min (good) location ids associated

[sqlite] complex update

2012-12-18 Thread Adam DeVita

Good day, I'm attempting to fix some bad data: There is a table products where has a location id. Unfortunately duplicate dictionary names got added to list of locations products haslocationid and a bunch of other stuff I can easily get the max (bad) and min (good) location ids