@error_bot well shit
restore
scarab
take scarab
get out of hole
Posts made by Sels
-
RE: TDWTF Plays Zork I
-
RE: TDWTF Plays Zork I
@error_bot drop boat
drop wrench
dropscrewdriver
drop bloody axe
drop nasty knife
get in boat -
RE: Citisnoofle
@Scarlet_Manuka said in Citisnoofle:
@Sels said in Citisnoofle:
same difference
I think you'll find you're not sorting 90 before 89 any more, which your original did (because it wasn't actually sorting at all).
I think you'll find there is no 89 selected there
And if there were:
@dkf said in Citisnoofle:
@JazzyJosh said in Citisnoofle:
And AFAIK Chase still toUpperCase's your password before saving it to the database or checking it against your password hash, so your password is case-insensitive.
I'm surprised that they aren't just running all their operations on a database that only supports capital letters and using some skanky code to recreate the lower case letters on output for these newfangled ASCII computers.
Every financial institution I've worked for has had a hard on for capital letters everywhere, I blame accountants.
-
RE: Citisnoofle
@Sels said in Citisnoofle:
[SQL]
You order by clause is ineffective there, it's only applying to the final query and the union isn't guaranteed to respect it in any case (i.e. it could reorder the results of the final query too, if there had been more than one). You need to do
select num from (
union goes here) order by num
.
same difference, I used to see the same error in our DBs all the time because we also use alphanumeric cost centers, but is easily solved by leading zeros