Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
The MUMPSorceress
Jan 6, 2012


^SHTPSTS

Gary’s Answer

This isn't even a SQL problem. This is a "people filling out the forms are stupid" problem. Why would you put a combinations of letters and numbers that could be a valid license plate number into the plate field for a car that has no plates. Draw one giant X or a big line through the box, problem solved.

Adbot
ADBOT LOVES YOU

The MUMPSorceress
Jan 6, 2012


^SHTPSTS

Gary’s Answer

~Coxy posted:

That wouldn't solve the problem by itself because then all that happens is the transcriptionist entering the ticket into the database takes it upon herself to enter "MISSING" or "XXXXXXX" or "NO TAG" because the drat input field in the UI is compulsory. :v:

DESIGN!!!!

  • Locked thread