The Official Status Thread
-
Status: trying to add a column to a string-concatenated query consisting of like 50 parts, each of a few subparts, returning 100 columns and spanning roughly 200 lines of code.
ORA-00918: column ambiguously defined
FUUUUUUUUUUUUUUUUUUUUUUUUUUUUUCK.
-
That makes sense, yet at the same time, seems totally insane; I don't see why you can't just have an
int
PK, and store all the other info in normal fields.
-
This gets even better[*]. There are a few tables that get their keys from a Counter table. The table has one value in it, a static object takes the maximum value from that table and gets a list of the next 10 numbers. When an insert needs a new key it pops the smallest value from the list and uses it. When the list is empty it updates the counter table with a new base value and gets a new list
This needs its own sidebar. It also means that my previous trick of getting the highest value from a table and adding a random amount to it is still dangerous because I'm not updating the counter table so someone might still end up reusing the ID
I guess this was someone's attempt at implementing a cross table sequence but it's so full of holes IDK where to start
[*]worse
-
-
I don't see why you can't just have an int PK, and store all the other info in normal fields.
depends on the why of it.
one thing that SF id gives you is easy pathing for a rest API.
want to frobulate a gonkulator?
PUT /frobulate/{ID}
want to frobulate a fubar?PUT /frobulate/{ID}
-
Explain? I cannot think of a reason that's a good idea…
The DB I work on at work is really the database representation of data that the main system it works with slurps in in the form of flat text files that hold a roughly-relational data model within them. Of course, the record IDs have the object type and some sort of partition data bitshift-encoded into them.
Do you mean natural keys or that you're creating a surrogate key that then has other meaning not found in the rest of the table?
The latter, as above.or possibly the PKs form Salesforce:
00119000004x29eAAA
ok. so the prefix is 001. that means this is an accountid, the suffix is AAA that's a checksum so i can make sure i got the rest of the number correct. the account id is then 19000004x29e which i know encodes both the sandbox ID (because this is a test sandbox id) and the account ID propper (not sure how that's encoded, but given the IDs in our test sandbox i think it's the 19 prefix that ids the sandbox.)
Pretty much us, except we're working with 32-bit integers represented as hex strings (because Orrible has trouble with hex) and there is no checksum to keep you from producing a broken ID.Also, the system uses this ID format for all objects in the system, whether they be in the static data load, the RDB tables, in memory, or even on the wire (it's a distributed system using a custom messaging layer).
-
depends on the why of it.
one thing that SF id gives you is easy pathing for a rest API.
want to frobulate a gonkulator?
PUT /frobulate/{ID}
want to frobulate a fubar?PUT /frobulate/{ID}
I guess, but equally, I don't see why it couldn't bePUT /gonkulator/{ID}/frobulate/
andPUT /fubar/{ID}/frobulate/
. But then maybe that's my Web API experience talking (or, probably more accurately, my MVC experience).
-
Why is it I've gotten like four notifications today that this post was moved by @boomzilla?
To get rid of those, you have to go to your older notifications and click the button to dismiss notifications, I'm afraid.
-
Status: Well… that was an hour or so.
I'm late for lunch; think I'll go get some, come back less hungry.
-
I'm late for lunch; think I'll go get some, come back less hungry.
Just go for lunch now you dumb hedgy!
-
i am open for freelance contracts. call me if you're interested.
Are you hitting on me? I will have you know I am a married man! :P
-
.... there's two jokes i could make here.... not sure which would be better...
-
Just go for lunch now you dumb hedgy!
yes, that is a good plan. Hangry hedgehog is almost as bad as hangry fox. :-P
-
-
Status: BTW as follow-up to the stack overflow question I asked a few days ago, yes the site has been utterly useless to me. Again. Per usual.
Your questions are too hard. Did you try asking "How to sum all numbers in an array using jQuery"?
-
Did you try asking "How to sum all numbers in an array using jQuery"?
"Closed as duplicate of half the questions on SO"
-
@accalia said:
i am open for freelance contracts. call me if you're interested.
Are you hitting on me? I will have you know I am a married man! :P
Cali, how could you? Without me, that is?
@accalia said:Hangry hedgehog is almost as bad as hangry fox
True, but really I just needed a break after the whole green text thing.
-
I think there's a plugin for that.
GIVE ME POINTZZZZ
-
Status: Getting confused by the static analyzer:
I eventually realized TRWTF was me for forgetting to#include <assert.h>
.
Filed under: Slightly anonymized with the help of the Web Inspector
-
Status: Coworker is incessantly complaining about a Windows Update that makes reboots take forever and fails every time. Update is a service pack for SQL Server 2005 which was auto-installed by Visual Studio and not used by any employee of this company. Coworker refuses to uninstall unneeded software which causes problems, but continues to complain about it. I think I secretly work with blakeyrat. (Also pondering which would make him madder, that I said his name without mentioning him, or if I actually mentioned him?)
-
I've had a Windows update on my home PC for about a month now that won't go away. It's an Update For Windows, a 23kb download, and whenever I try to install it, it's back again after the reboot.
-
Status: I feel super productive today :D
-
Stop hogging all the productivity, I need some.
-
I will at 1PM EDT. I have things to do.
-
That's an hour after I get off work.
Filed under: On the other hand, I have a dragon to knit. I'll take it.
-
-
Sounds cool.
It's actually pretty wonky and full of mistakes, because I couldn't find a pattern I liked so I'm making one up. This is just a prototype to work out the pattern, and then I'm going to do a proper one with nicer yarn. I hope someone will love this first one in spite of his deformities though: I intend to leave him at the train station with a label saying 'please look after this dragon'.
-
I intend to leave him at the train station with a label saying 'please look after this dragon'
Why not donate to Oxfam or, better still, somewhere like Great Ormond Street Hospital?
-
It's really really a shoddy piece of work, I'd be ashamed. I doubt a charity shop could sell it, and while a kid in hospital might like it even so, I would feel embarrassed.
I might knit an extra one when I've got the pattern worked out and do just that, if I knew of anywhere collecting toys for a kids' hospital (probably not Great Ormand Street as there's one in my city). Also I rather liked the train station idea.
-
It's really really a shoddy piece of work, I'd be ashamed. I doubt a charity shop could sell it, and while a kid in hospital might like it even so, I would feel embarrassed.
Personally, if I made something like that, shoddy or not, then found out it helped a kid who was dealing with cancer, I'd be stoked. But of course, it's up to you ;)
-
I intend to leave him at the train station with a label saying 'please look after this dragon'.
and don't feed him after midnight?
Status: client doesn't want .csv, he needs excel files! i'm not even bothering explaining anything this time.
(uhm, that last phrase had a lot of -ing s i hope it's correct)
-
client doesn't want .csv, he needs excel files!
Tab separate the csv and save it as .xls. They'll get a warning on opening but it will look like a normal spreadsheet (as long as they don't expect any fancy formatting)
-
-
Great!
i didn't want to include an excel lib just for this.
-
@blakeyrat
Ooh, it does work!
-
Also, check this out, I found a video with @blakeyrat in it IRL:
Internet Bridge Troll – 02:56
— Dropout
-
They'll get this warning when opening
Then if they try to edit and save:
Yes will keep it as a tab separated file with the xls extension, no will open the save as dialog so they can resave as a proper spreadsheet. Depending on the paranoia of the client, they may get nervous about all the warnings, but it should all work
-
I'm not sure mention bombing him at this point is the best idea...
-
I'm not sure mention bombing him at this point is the best idea...
What's he going to do, come in here and rant?
-
-
-
Lunch was indeed had ;)
-
Status: thinking I might be in a valid use case for
goto
, since the alternative looks like becoming a large tree of nestedif...else if...else
calls.The horrors I've seen today may have stripped me of my sanity. If I don't make it out, tell my fiancée I love her
-
-
I need to proof my mobile posts better.
No, they're fine this way.
Gibberish, but that's OK, too.
-
-
Personally, if I made something like that, shoddy or not, then found out it helped a kid who was dealing with cancer, I'd be stoked. But of course, it's up to you
It just feels ungenerous, 'this one's not good enough for me to keep, but it'll do for sick kids'.
-
Status: thinking I might be in a valid use case for goto, since the alternative looks like becoming a large tree of nested if...else if...else calls.
I used one goto in a piece of low-level C code and got chewed out for it. Had to rewrite it without goto and it was like triple the number of lines.
-
It just feels ungenerous, 'this one's not good enough for me to keep, but it'll do for sick kids'.
But this is a generous thought!
If it's that bad, after you use it as a model, why not just frog it and re-use the wool?
But I like the train station idea - it reminds me of Paddington.
-
Status: thinking I might be in a valid use case for
goto
, since the alternative looks like becoming a large tree of nestedif...else if...else
calls.
Not possible toswitch
?