Life isn't easy if your last name is 'Null' as it still breaks database entries the world over
-
Wordpress is a sin against mankind.
Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?
-
Wordpress is a sin against mankind.
Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?
-
Wordpress is a sin against mankind.
Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?
-
Are there character escapes for SQL, to protect against stuff like that?
Use parameters, that way data and queries are separate.
-
Are there character escapes for SQL, to protect against stuff like that?
Yes but it's a dangerous process. You should use paramatrized queries instead.
-
Legacy systems still handle more traffic than modern ones, I’d wager
And it's probably not seen as urgent enough an issue to need replacing the whole system for.
-
This post did not contain any content.
NULL!= 'NULL'How do devs make this mistake
-
NULL!= 'NULL'How do devs make this mistake
How do devs make off by one mistakes.
-
Yep. For the curious, any time a license plate photo couldn’t be fully read by the automated system, it was marked as “NULL” and he was flagged as the driver. So every single red light camera and speeding camera in the area was sending him to court every day.
It got worse than this, the ticketing company really wanted to get the money from him so when he got hold of a copy of the records and pointed out that one ticket was for a completely different car they modified the records on their end to change the make of car so it would match his. iirc he only got out of it because he had paper copies.
-
It got worse than this, the ticketing company really wanted to get the money from him so when he got hold of a copy of the records and pointed out that one ticket was for a completely different car they modified the records on their end to change the make of car so it would match his. iirc he only got out of it because he had paper copies.
Don't they have to prove it with a photograph? In GermanyI'd laugh in theirface withput a photograph as evidence.
-
I have never seen this happen, and I don't know what tools would confuse the string "null" with NULL. From the comments in this thread, there are evidently more terribly programmed systems than I imagined.
As long as there's javascript somewhere, anything can happen
-
This post did not contain any content.
Lmao, I knew a guy from grade school with the last name Null.
-
NULL!= 'NULL'How do devs make this mistake
It's baffling to me. Maybe I'm just used to using "modern" frameworks, but the only way this could be an issue is if if you literally check if the string value equals "null" and then replace it with a null value.
lastName = lastName.ToUpper() == "NULL" ? null : lastName;Either that or the database has some bug where it's converting a string value of "null" into a
null. -
It's baffling to me. Maybe I'm just used to using "modern" frameworks, but the only way this could be an issue is if if you literally check if the string value equals "null" and then replace it with a null value.
lastName = lastName.ToUpper() == "NULL" ? null : lastName;Either that or the database has some bug where it's converting a string value of "null" into a
null.That is something I’ve had to do on rare occasions because people set up and store info in stupid ways…
-
Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?
Maybe your app is based on WordPress :'D
-
It got worse than this, the ticketing company really wanted to get the money from him so when he got hold of a copy of the records and pointed out that one ticket was for a completely different car they modified the records on their end to change the make of car so it would match his. iirc he only got out of it because he had paper copies.
Isn't that falsifying legal documents? In many countries that would land you in jail? Am I wrong, did the people really run that risk?
-
Unless you’re coding from scratch it’s hard to not do this with any modern framework.
Unless you’re coding from scratch it’s hard to not do this with any modern framework.
I think that word modern is doing a lot of heavy lifting there.
A lot of systems simply aren't modern. There's always that mentality of "well, it's been working for the last 12 years, let's not mess with it now", despite all the valid objections like "but it's running on Windows2000” or "it's a data beach waiting to happen"...
-
This post did not contain any content.
I bet, I can't even read this article without confusion
-
I was NaN years old when I learned this.
It's funny because I also learned on [Object object].
-
Don't they have to prove it with a photograph? In GermanyI'd laugh in theirface withput a photograph as evidence.
Hey AI can you swap this 2015 corolla with a green 2019 Mazda 2.
Keep the license plate the same!
And remember THERE ARE FOUR PASSENGER DOORS NOT 6
