IMCDb Forum
Delete a Message
Reason of removal (sent to the user)

Do you really want to delete this message?  


eLMeR
Like for the Mid-Liner models (still not changed in the IMCDb :wink: ), Mack's corporate writing for the 1977-93 Super-Liner also used a hyphen:
http://pics.imcdb.org/18713/197macksuperlinerbrochureexcerpt.jpg
http://pics.imcdb.org/18713/1978macksuperlinerbrochurecover.jpg
http://pics.imcdb.org/18713/1989macksuperlinerbrochurecover.jpg
197? brochure excerpt
1978 brochure cover
1989 brochure cover


74 trucks are concerned in the IMCDb, including these (at least) 2 Australian models (already listed in the previous link): this name is still written this way in wombats' island nowadays.

It appears that it is the same spelling for all Something-Liners, in fact.
US models:
  ∗ 1975-83 Cruise-Liner (18 trucks in the IMCDb)
http://www.trucksplanet.com/photo/mack/ws_wl_cruise-liner/x_ws_wl_cruise-liner_k1.jpg
http://www.trucksplanet.com/photo/mack/ws_wl_cruise-liner/x_ws_wl_cruise-liner_k494.jpg


  ∗ 1982-90 Ultra-Liner (13 trucks in the IMCDb). Apparently also known as MH-Series by some of us, but no model is currently identified that way.
http://www.trucksplanet.com/photo/mack/mh_ultra-liner/x_mh_ultra-liner_k1.jpg

Australian models:
  ∗ Cruise-Liner
The only truck identified that way is already part of the US Cruise-Liner link above.

  ∗ Fleet-Liner. None in the IMCDb for now?
http://www.trucksplanet.com/photo/mack_australia/fleet-liner/x_fleet-liner_k1.jpg

  ∗ Super-Liner. See the US model.

  ∗ Metro-Liner. Only 1 truck concerned, I'll change it manually, I don't think a specific MySql script is needed :grin:

  ∗ Value-Liner. 2 trucks in the IMCDb that I'll change manually.
http://www.trucksplanet.com/photo/mack_australia/value-liner_2/x_value-liner_2_k1.jpg

==========

Thinking about it twice, and as I'm a lazy person, I won't have to make the manual changes if this script is Ok for you, antp:
update theTable set theModelField = replace(theModelField, 'liner', '-Liner') where theMakeField like ('Mack') and theModelField like ('')

It certainly needs some arrangements to fit the IMCDb tables structure, but it would change all Mack Something-Liner in one go, and only them. Tested and approved in a test table I made on purpose :wink:
Sign In :: Sign Up :: Lost your login or your password?
KelCommunity.be :: © 2004-2025 Akretio SPRL :: Powered by Kelare