Delete a Message
Thanks!
Sounds logical: using replace is like "playing" with RegExps or using a hammer: it can hurt a lot even when done with care
Talking about Australian Macks, there's a kind of mess about them: for now we classify them as made in Australia, made for Australia (only 3 trucks are set that way without "made in"), or both.
As said on the Australian corporate site, "[proud to] have celebrated 50 years of local Mack production on Australian soil in 2013":
So, as Mack trucks made in Australia may also end in New Zealand, we would certainly be right by having them just as "made in"...
If Ok, do the following codes help? Tested without apparent collateral damage, but at usual "in backup we trust"
1- All Mack trucks with the "made for Australia" flag get the "made in" one if not present;
2- Delete the "made for Australia" flag for Mack trucks set with the "made in Australia" one.
Ok, the 1st line is certainly a bit overkill, as only 3 trucks are really concerned. Let's say I'm a hopeless geek
[...] I'm always a little afraid of functions like Replace in SQL :D)
Sounds logical: using replace is like "playing" with RegExps or using a hammer: it can hurt a lot even when done with care
Talking about Australian Macks, there's a kind of mess about them: for now we classify them as made in Australia, made for Australia (only 3 trucks are set that way without "made in"), or both.
As said on the Australian corporate site, "[proud to] have celebrated 50 years of local Mack production on Australian soil in 2013":
Every Mack truck, custom built for the Australian and New Zealand market, comes to life at the Australian production facility in Wacol, QLD.
So, as Mack trucks made in Australia may also end in New Zealand, we would certainly be right by having them just as "made in"...
If Ok, do the following codes help? Tested without apparent collateral damage, but at usual "in backup we trust"
update theTable set madeInField='countryIdForAustralia' where theMakeField='idForMack' and madeForField='countryIdForAustralia';
update theTable set madeForField='' where theMakeField='idForMack' and madeInField='countryIdForAustralia';
update theTable set madeForField='' where theMakeField='idForMack' and madeInField='countryIdForAustralia';
1- All Mack trucks with the "made for Australia" flag get the "made in" one if not present;
2- Delete the "made for Australia" flag for Mack trucks set with the "made in Australia" one.
Ok, the 1st line is certainly a bit overkill, as only 3 trucks are really concerned. Let's say I'm a hopeless geek