News for hackers. Stuff that matters.
Re:C:\ONGRTLNS.W95, OneDrive by cordite on Wednesday November 05, 2014 @12:01PM (#8562774)
We have to do that in our database for numbers since zeros get truncated off the left side if it is detected as a number--and the number of zeros is important.

I don't know about people doing stuff in file systems these days like that, but it is a simple hack.

Re:C:\ONGRTLNS.W95, OneDrive by naturalethic on Wednesday November 05, 2014 @12:27PM (#8562937)
Uh what. Do you use Excel as your database?
Re:C:\ONGRTLNS.W95, OneDrive by cnvogel on Wednesday November 05, 2014 @12:30PM (#8562955)
I think /cordite/ tried to make a sarcastic joke. Or did he...?
Re:C:\ONGRTLNS.W95, OneDrive by cafard on Wednesday November 05, 2014 @12:58PM (#8563129)
The ways of Microsoft controls can be interesting indeed. At one point, we had to reverse-sort phone numbers to be loaded into a VARCHAR column in SQL Server. The vendor used a Microsoft control, which would look at a couple of phone numbers, say 2025551212, conclude that they were suitable for 32-bit integers, and choke somewhere around the 404 area code.

Then there was the time another package tried to write out street addresses that were something like 3E123 or maybe it was E456. Apparently the control read them as numbers in scientific format that were just way too big.

Re:C:\ONGRTLNS.W95, OneDrive by cordite on Wednesday November 05, 2014 @08:18PM (#8565293)
Since traversing forward is always cheaper than backwards, we subtract our reverse numbers by a magic number for things we want to access in reverse order. Or in this case, dates where the most recent is first.
Re:C:\ONGRTLNS.W95, OneDrive by cordite on Wednesday November 05, 2014 @01:09PM (#8563204)
I am not making a joke. This stuff is from the 70-80s. Everything is a string unless it is numeric.