The Official Status Thread
-
-
@hungrier thankfully no. <Shudders at the thought>
-
@Benjamin-Hall said in The Official Status Thread:
@Tsaukpaetra so yes.
Related: I took the following picture on Monday in a game store parking lot. The whole car is covered in these, and these are the most tame ones. Also on the car? The word "senpai".
@Polygeekery? I know you're not well at the moment, but we're all going to feel better when it's done.
-
@Applied-Mediocrity said in The Official Status Thread:
@Polygeekery? I know you're not well at the moment, but we're all going to feel better when it's done.
If it makes you feel any better I am very sensitive to light at the moment, and I really don't want to drink any water. So aquaphobia paired with photophobia.....I may have rabies. Once the rage starts I will get working on my backlog until I either die from rabies or the authorities put me down.
I will move this one close to the top of the list. How close is it to @Luhmann's house?
-
@Polygeekery said in The Official Status Thread:
How close is it to @Luhmann's house?
I'll have a spray bottle of water and flashlight ready.
-
@Polygeekery said in The Official Status Thread:
I may have rabies
Or you may have been visiting WebMD
until I either die from rabies or the authorities put me down.
Hey, "If you want to shine like the sun, first you have to burn like it"
If it makes you feel any better
I think I'm past the curve of the man-flu that had chosen to bother me this week.
Yours seems like something worse. So yeah, get better soon, because this.
-
@Polygeekery Probably a decent distance. This was in St. Petersburg (Florida, not Russia).
-
@Benjamin-Hall
Russia would be closer. Now if only Putin could be arsed to meddle in the formation of our federal coalition government so that things could move right along.
-
@Applied-Mediocrity said in The Official Status Thread:
Or you may have been visiting WebMD
Nah, it tells you something different.
-
Status: While I am grateful for a 10 minute all-staff meeting, that meeting could have been an email. Like most of them.
-
-
Status: Finally wrote up a timeline of major events for my sci fi novels. The first few books might have a few minor discrepancies, but things ought to be pretty consistent from here on.
-
Status: Back to Outlook VBA. I have so much noise mail that I ran out of room for Outlook rules. So, slowly but surely, I have been condensing them into a massive VBscript that looks like this:
Public Sub SuperRule (Object_Mail as Outlook.MailItem) Dim Collection_Static as Collection Set Collection_Static as New Collection 'dozens of calls to Collection_Static.Add() Dim String_Location as String String_Location = "C:/Users/Zenith/Desktop/OutlookVBA.txt" Dim Object_Processor as Zenith.RuleClassContainer Set Object_Processor = New Zenith.RuleClassContainer Dim Structure_Temporary as Variant For Each Structure_Temporary in Collection_Static 'log function call started Select Case CallByName(Object_Processor, Structure_Temporary.Function, VbCallType.VbMethod, Object_Mail, String_Location) 'Case 0 'Case 1 'Case 2 End Select 'log function call ended Next Structure_Temporary End Sub 'dozens of functions distilled down to "if conditions, move it" with a return code
-
Windows 10 lets me control my Android phone from my laptop and I think that's rad.
Filed under: I know we're not supposed to say nice things about Windows 10. My bad.
-
-
@error said in The Official Status Thread:
@PleegWat said in The Official Status Thread:
Point with a
stickfrickin' laser beam!I get the impression that image is at least a decade old, if not two. Note the complete lack of indication of the potential for death by powerpoint.
-
@PleegWat said in The Official Status Thread:
@error said in The Official Status Thread:
@PleegWat said in The Official Status Thread:
Point with a
stickfrickin' laser beam!I get the impression that image is at least a decade old, if not two. Note the complete lack of indication of the potential for death by powerpoint.
We had laser pointers when I was in middle school 23 years ago.
Filed under: Teachers HATED them.
-
@error
Maybe if you would have done more than just one simple trick with them, they would have been more well received.
-
@izzion said in The Official Status Thread:
@error
Maybe if you would have done more than just one simple trick with them, they would have been more well received.Is there any trick more funny than putting two red dots over the nipples of whoever is presenting?
-
@error said in The Official Status Thread:
@PleegWat said in The Official Status Thread:
@error said in The Official Status Thread:
@PleegWat said in The Official Status Thread:
Point with a
stickfrickin' laser beam!I get the impression that image is at least a decade old, if not two. Note the complete lack of indication of the potential for death by powerpoint.
We had laser pointers when I was in middle school 23 years ago.
Filed under: Teachers HATED them.
-
@Parody said in The Official Status Thread:
an engineer
You're not so far off. I have a math degree and i always wanted to be Mr Data when I growed up. Software/analytics just pays the bills (but analytics is potentially relatively close to the math I enjoy).
-
@Captain said in The Official Status Thread:
You're not so far off. I have a math degree and i always wanted to be Mr Data when I growed up.
Remember, you're not supposed to use contractions.
-
@mott555 said in The Official Status Thread:
Status: Finally wrote up a timeline of major events for my sci fi novels. The first few books might have a few minor discrepancies, but things ought to be pretty consistent from here on.
Status Addendum: Easily amused.
-
Oh boy...
Damnit, my wife just bought me a new old laptop.
-
-
Status: Wolfram Alpha still hasn't fixed their shit
-
I guess a couple years I kickstarted some eldritch style dice?
Anyway, a huge box landed on my porch this afternoon, filled with polyhedra of every size and shape and color and... I think I may have gotten carried away.
-
Status: Something tells me "run a script" was not supposed to be used as a wholesale replacement for regular Outlook rules...
-
@error said in The Official Status Thread:
I guess a couple years I kickstarted some eldritch style dice?
Anyway, a huge box landed on my porch this afternoon, filled with polyhedra of every size and shape and color and... I think I may have gotten carried away.
You can send them to me!
-
@Zenith Is it creating a new process for each email?
-
Status: google, several states over is not "nearby"...
-
@Benjamin-Hall said in The Official Status Thread:
@error said in The Official Status Thread:
I guess a couple years I kickstarted some eldritch style dice?
Anyway, a huge box landed on my porch this afternoon, filled with polyhedra of every size and shape and color and... I think I may have gotten carried away.
You can send them to me!
And me!
-
@e4tmyl33t said in The Official Status Thread:
@Benjamin-Hall said in The Official Status Thread:
@error said in The Official Status Thread:
I guess a couple years I kickstarted some eldritch style dice?
Anyway, a huge box landed on my porch this afternoon, filled with polyhedra of every size and shape and color and... I think I may have gotten carried away.
You can send them to me!
And me!
I'm sure they could find uses...
-
@Benjamin-Hall Not that I know of but I wrote it like a C# program which is usually a mistake in classic VB.
-
@Tsaukpaetra I'm pretty sure I've mentioned this on the forum before but a few years ago I entered "south", looking for a shopping centre named after a local neighbourhood. The first two suggestions were "South Africa" and "South Korea".
Just checked it again on the desktop version, and it auto suggested the neighbourhood, followed by South Africa and South Korea as the 2nd and 5th options, respectively
-
@Zenith There's probably some kind of super-slow inter-process COM interop thingy going on.
-
@mott555 It's probably that testing is doing the equivalent of selecting all rules on the entire inbox.
But I also learned that sometimes SenderEMailAddress has an AD path in it which is stupid.
-
Unpopular opinion: self-checkouts > regular checkouts. Because then you don't get stuck behind the person who
- has 25+ items in the "express, 10 items or less" lane
- with a new cashier
- using EBT/WIC
- who is using a bunch of coupons, including ones that have to be run after the EBT card swipe
- and several gift cards, some of which were empty; the person refused to believe that and tried to swipe them multiple times
It took the cashier roughly 15 minutes to ring up a single transaction. And I was stuck behind this person for the duration. With a self-checkout I'd have been out of there nearly instantly (I had like 5 things).
-
@Benjamin-Hall said in The Official Status Thread:
self-checkouts > regular checkouts. Because then you don't get stuck behind the person who
No you get stuck behind 1094 different morons instead.
-
Status: Failing at MySQL.
My code:
UPDATE someTable SET `payment_date` = case when `payment_status` = \'Completed\' then `payment_date` when ? = \'Completed\' then UTC_TIMESTAMP() else `payment_status` end where (condition)
Intent: If the payment is already completed, don't change it, if the new payment status is now Completed (the question mark substitution), then timestamp, otherwise leave unchanged.
At present it seems to keep the first condition fine, and the last condition, but the middle one (the important one!) doesn't ever happen.
Am I assuming order of execution wrong?
-
@Tsaukpaetra said in The Official Status Thread:
Am I assuming order of execution wrong?
Yes, yes I am. See, leftward in the statement I was assigning the new
payment_status
, which takes effect immediately I guess.I wonder if I can get away with assigning the same column a value multiple times...
-
This post is deleted!
-
@Captain said in The Official Status Thread:
Damnit, my wife just bought me a new old laptop.
My new new laptop just arrived. I wonder if I'm okay... I know AT&T must be pissed at me. The internet to my house has reset 2x already. Downloading all the needed updates (came with 1903) and Visual Studio (1.49GB of 4.89GB so far).
-
@Tsaukpaetra said in The Official Status Thread:
Status: google, several states over is not "nearby"...
On the East coast it is...
-
@dcon To me, "nearby" means "I can walk there in five minutes or less, and five minutes is pushing it.
-
@Tsaukpaetra said in The Official Status Thread:
Status: Failing at MySQL.
My code:
UPDATE someTable SET `payment_date` = case when `payment_status` = \'Completed\' then `payment_date` when ? = \'Completed\' then UTC_TIMESTAMP() else `payment_status` end where (condition)
Intent: If the payment is already completed, don't change it, if the new payment status is now Completed (the question mark substitution), then timestamp, otherwise leave unchanged.
At present it seems to keep the first condition fine, and the last condition, but the middle one (the important one!) doesn't ever happen.
Am I assuming order of execution wrong?
Can you find a way to only assign to the rows where you're going to change something so as to keep the set of modifications small? I fully admit to not being great at SQL but something like this would seem to be far more efficient:
UPDATE someTable SET `payment_date` = UTC_TIMESTAMP() WHERE `payment_status` <> 'Completed' AND ? = 'Completed' AND (condition)
-
@dkf said in The Official Status Thread:
only assign to the rows where you're going to change something so as to keep the set of modifications small?
It's updating a single row.
-
@Tsaukpaetra said in The Official Status Thread:
@dkf said in The Official Status Thread:
only assign to the rows where you're going to change something so as to keep the set of modifications small?
It's updating a single row.
So? SQL is by far best when written to work on sets of rows, instead of being used like a dumb procedural language.
-
@dkf said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@dkf said in The Official Status Thread:
only assign to the rows where you're going to change something so as to keep the set of modifications small?
It's updating a single row.
So? SQL is by far best when written to work on sets of rows, instead of being used like a dumb procedural language.
I don't understand. I'm updating an entity, specifically four columns in it, why would I mass-update rows I don't need to?
-
@Tsaukpaetra said in The Official Status Thread:
@dkf said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@dkf said in The Official Status Thread:
only assign to the rows where you're going to change something so as to keep the set of modifications small?
It's updating a single row.
So? SQL is by far best when written to work on sets of rows, instead of being used like a dumb procedural language.
I don't understand. I'm updating an entity, specifically four columns in it, why would I mass-update rows I don't need to?
You still should write your code that way to reduce the ugly.
Or if you're certain you know what's in the row, use the ID of the row and a simple
SET
. Or you couldCOALESCE
so that the value is written only if it is not already written.Or you could set a trigger on the table so setting the status to completed causes the timestamp to be recorded.