How (and why) to Ramble on your goat sideways
Boost Pope
iTrader: (8)
Join Date: Sep 2005
Location: Chicago. (The less-murder part.)
Posts: 33,072
Total Cats: 6,625
Take the usual steps to protect yourself. PeerBlock is a good start.
Boost Pope
iTrader: (8)
Join Date: Sep 2005
Location: Chicago. (The less-murder part.)
Posts: 33,072
Total Cats: 6,625
An Open Letter to Companies Which Sell Auto Parts, and Have Websites With a Search Function:
Dear companies which sell auto parts, and have websites with a search function. I recognize that there is a tendency among American automakers to price-gouge their customers and complicate aftermarket parts support by offering a dazzlingly large array of engine choices for any given model. By comparison, Japanese and European automakers have long rejected this concept, offering only a single, standard engine for any given car model.
While your commitment to supporting the purchasers of American cars is charitable, the manner in which you have implemented such support causes minor but persistent annoyance to those of us who own automobiles not designed principally to confuse and confound their owners. I speak specifically to the database front-end which you have created which allows us to search specifically for parts which are applicable to our make, model and year of car.
When I am searching for a part for my 1990 Mazda Miata, it is not necessary for me to specify which engine the car is fitted with. 1990 Mazda Miatas were offered with only one engine, the 1.6 liter B6-ZE. The same holds true for all Mazda Miatas from 1990 through 2004, as well as myriad other cars.
You have the capability within your reach to add a check to the database which determines whether the number of available engine choices for any given year / make / model selection is greater than one, and to skip past that selection field, auto-setting the only available value if it is not.
Please, as a service to the betterment of all humanity, implement this function.
Dear companies which sell auto parts, and have websites with a search function. I recognize that there is a tendency among American automakers to price-gouge their customers and complicate aftermarket parts support by offering a dazzlingly large array of engine choices for any given model. By comparison, Japanese and European automakers have long rejected this concept, offering only a single, standard engine for any given car model.
While your commitment to supporting the purchasers of American cars is charitable, the manner in which you have implemented such support causes minor but persistent annoyance to those of us who own automobiles not designed principally to confuse and confound their owners. I speak specifically to the database front-end which you have created which allows us to search specifically for parts which are applicable to our make, model and year of car.
When I am searching for a part for my 1990 Mazda Miata, it is not necessary for me to specify which engine the car is fitted with. 1990 Mazda Miatas were offered with only one engine, the 1.6 liter B6-ZE. The same holds true for all Mazda Miatas from 1990 through 2004, as well as myriad other cars.
You have the capability within your reach to add a check to the database which determines whether the number of available engine choices for any given year / make / model selection is greater than one, and to skip past that selection field, auto-setting the only available value if it is not.
Please, as a service to the betterment of all humanity, implement this function.
Elite Member
iTrader: (2)
Join Date: Sep 2008
Location: Central Florida
Posts: 2,799
Total Cats: 179
When I am searching for a part for my 1990 Mazda Miata, it is not necessary for me to specify which engine the car is fitted with. 1990 Mazda Miatas were offered with only one engine, the 1.6 liter B6-ZE. The same holds true for all Mazda Miatas from 1990 through 2004, as well as myriad other cars.
This could only be kind of true if you consider, for example, a 528i and a 540i to be unique car models, and not the same car model offered with more than one engine.
EDIT: It's worth noting, that not only do plenty of Japanese and European automakers offer more than one engine choice for a given car model, they offer even more engine choices in many (to us) foreign markets.
EDIT 2: I'm having a hard time believing that Joe uttered that statement in all seriousness. Consider even the most ubiquitous Japanese cars: the Accord and the Camry. Both have been offered with at least 2 different engines every year for the last 20+ years. Likewise the Altima from 2002 on. The Civic was offered with at least 2 or 3 engine options for decades. The Sentra had 2 engine options for most of the 1990's and 2000's. Examples abound.
Boost Pope
iTrader: (8)
Join Date: Sep 2005
Location: Chicago. (The less-murder part.)
Posts: 33,072
Total Cats: 6,625
Furthermore, for years in which the xDrive (AWD) system was available, that, too, shows as a unique model separate from the RWD car in step 3, as do the "GT" submodels of each. So not only are the 528 and 535 different models, there are four different models of the 535 in the 2012 model year:
So, yes. For the specific purpose of discussing the database front-end of an auto parts vendor, the 528i and the 540i are unique models.
EDIT: It's worth noting, that not only do plenty of Japanese and European automakers offer more than one engine choice for a given car model, they offer even more engine choices in many (to us) foreign markets.
EDIT 2: I'm having a hard time believing that Joe uttered that statement in all seriousness. Consider even the most ubiquitous Japanese cars: the Accord and the Camry. Both have been offered with at least 2 different engines every year for the last 20+ years. Likewise the Altima from 2002 on. The Civic was offered with at least 2 or 3 engine options for decades. The Sentra had 2 engine options for most of the 1990's and 2000's. Examples abound.
EDIT 2: I'm having a hard time believing that Joe uttered that statement in all seriousness. Consider even the most ubiquitous Japanese cars: the Accord and the Camry. Both have been offered with at least 2 different engines every year for the last 20+ years. Likewise the Altima from 2002 on. The Civic was offered with at least 2 or 3 engine options for decades. The Sentra had 2 engine options for most of the 1990's and 2000's. Examples abound.
Honda and Toyota employ a similar naming convention to that of BMW in the aforementioned, typically using a one to three letter suffix which becomes part of the model name proper. Words are occasionally used as well (Hybrid, Type R, Platinum, etc.)
So within the database, there is not one single Camry with three different engine options, but rather there are six different Camrys (Camry L, Camry LE, Camry SE, Camry XLE, Camry Hybrid LE, and Camry Hybrid XLE), each of which has only one engine option at Step 4. The same holds true for the Accord, which exists as seven different unique models which have only one engine option each, and for the Civic, which encompasses eight different models with one engine option each:
The Americans are getting somewhat better at this, but are still not totally off the hook. Take, for instance, the 2013 Ford Focus. It exists as four separate sub-models (S, SE, ST and Titanium), with the turbo engine appearing only under the ST model. Within each sub-model, however, there are still separate engine choices for flex-fuel vs. non-flex-fuel. Thus, the Focii would be examples of car models for which the fourth selection is still required, and should not be auto-populated.
This is about database structure, not semantics.
You're right that the context matters, but not in the way you just argued. You didn't merely state that autoparts websites consider the Camry XE and the Camry LE to be different models. Originally, you suggested that, in terms of an automotive culture, the Japanese and European automakers "rejected" the strategy of offering more than one engine in a given car model.
If you want the argument to be about database structure and not semantics, then please restrict all truth claims to database structure.
If you want the argument to be about database structure and not semantics, then please restrict all truth claims to database structure.
Boost Pope
iTrader: (8)
Join Date: Sep 2005
Location: Chicago. (The less-murder part.)
Posts: 33,072
Total Cats: 6,625
You didn't merely state that autoparts websites consider the Camry XE and the Camry LE to be different models. Originally, you suggested that, in terms of an automotive culture, the Japanese and European automakers "rejected" the strategy of offering more than one engine in a given car model.
Because that's the record you're about to set.
This has nothing to do about database structure, and everything to do with lazy web developers that don't add a simple check after a SQL query.
P.S. I share your annoyance. That little item being left out of every major autoparts store website I've visited irritates the **** out of me.
P.S. I share your annoyance. That little item being left out of every major autoparts store website I've visited irritates the **** out of me.
Dear mgeoffriau,
You have received an infraction at Miata Turbo Forum - Turbo Kitten is watching you test compression..
Reason: Retardation
-------
I'm running out of creative explanations for these infractions. Sorry.
-------
You have received an infraction at Miata Turbo Forum - Turbo Kitten is watching you test compression..
Reason: Retardation
-------
I'm running out of creative explanations for these infractions. Sorry.
-------
Boost Pope
iTrader: (8)
Join Date: Sep 2005
Location: Chicago. (The less-murder part.)
Posts: 33,072
Total Cats: 6,625
It's an old programmer joke:
An experienced helicopter pilot, flying without instruments, becomes lost in Seattle air space in the fog with a panic-stricken passenger. Suddenly, out of the fog looms a tall building. The pilot, running low on fuel, grabs a bullhorn and shouts to one of the people in the window, "Can you tell me where I am?"
The man in the window, shouts back, "You're in a helicopter!" The passenger panics even further when he realizes that's all the help they are getting, but the pilot smiles knowingly, quickly turns the helicopter on a new heading, and makes it safe and sound to Seattle-Tacoma International Airport.
When they land, the amazed passenger asks how he did it. The pilot replies, "That fellow gave me an answer that was completely true, but utterly useless. Therefore, I knew he had to be a Microsoft tech support guy, so I plotted a course from Redmond, Washington to SeaTac Airport and here we are!"
The man in the window, shouts back, "You're in a helicopter!" The passenger panics even further when he realizes that's all the help they are getting, but the pilot smiles knowingly, quickly turns the helicopter on a new heading, and makes it safe and sound to Seattle-Tacoma International Airport.
When they land, the amazed passenger asks how he did it. The pilot replies, "That fellow gave me an answer that was completely true, but utterly useless. Therefore, I knew he had to be a Microsoft tech support guy, so I plotted a course from Redmond, Washington to SeaTac Airport and here we are!"
Yesterday, I was at Harbor Freight picking up a fuel pressure tester and a set of cheap star-drive sockets. I paid for this purchase with my debit card, using a terminal that had both a touchscreen (with captive stylus) and a physical keypad. To complete the transaction, I first had to use the stylus to press an icon for debit, then switch the stylus to my other hand so that I could press some keys on the keypad, then put the stylus back into my writing hand to press an icon indicating that I did not want cash back, and then hand over the stylus once again so that I could press a physical button indicating that I accepted the transaction.
By the end of this twenty second interaction, I was damn near shaking with rage at the idiots who designed this product with no regard whatsoever for optimizing the interface to reduce the number of times I was required to alternate between two input modes which were mutually exclusive in terms of the utilization of my hand.