|
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.
|
# ¿ Apr 30, 2014 18:19 |
|
|
# ¿ May 21, 2024 12:46 |
|
~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. DESIGN!!!!
|
# ¿ May 1, 2014 15:59 |