« first day (1937 days earlier)      last day (1243 days later) » 
00:00 - 19:0019:00 - 00:00

12:00 AM
RELOAD!
[Minesweeper] Games Played: 135, Bombs Used: 89, Moves Performed: 19777, New Users: 9
 
Yep... That wont update as I wanted 'View not updatable because the modification affects multiple base tables.' will have to wait till tomorrow.
My guess is I'll have to update each table separately.
Or I related the tables incorrectly.
</iven>
 
12:34 AM
 
12:54 AM
909 stars. Inching towards 910
 
 
3 hours later…
3:33 AM
Oh dear, a physicist and philosopher don’t get along...Source: twitter.com/i/events/1176235254207565824
 
 
2 hours later…
5:04 AM
> Message: String lengths are both 17. Strings differ at index 1.
Expected: ""Still in path 1""
But was: ""still in path 1""
ORLY
damn, something still isn't right.
TTGTB
 
@Duga that build will fail
</mug>
 
5:22 AM
[rubberduck-vba/Rubberduck] build for commit 894020d1 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
 
1 hour later…
6:30 AM
Hi
anyone online?
 
7:12 AM
Doubt it. Lot everyone’s out by now. I’m just finishing up studying.
@PrisonMike Even if we’re not here ask away and we’ll get back with you.
 
7:32 AM
Thanks but it's solved :)
 
8:28 AM
yo
 
Kaz
9:15 AM
@MathieuGuindon Coincidentally, it's also going to be my 5 year anniversary with my company ^^
 
 
4 hours later…
12:58 PM
@Kaz congrats!
I'm at 4.5 years here which is the longest I've ever had one name on the top left corner of a paycheck.
I did spend about 6 yrs doing work for one company, but it was 1.5 as a contractor, 2 as an employee, then 2 at the co they outsourced everything to when they shut down the division...
 
1:33 PM
ok... back to this API call issue. It seems that it may have been caused by me passing parameters as Request Headers, vs in the Body.
I tested one query in Postman that showed that is required them in the body, so I clicked the "body" tab, the selected "raw" and entered the parameters in JSON format like this:
{
  "startDate": "2019-09-18T00:00:00-05:00",
  "endDate": "2019-09-18T23:59:59-05:00",
  "locationId": [
    106
  ]
}
in Postman, there's an option right next to "Raw" called "x-www-form-urlencoded" which lists individual parameters and their values, but the ones entered in "raw" don't get translated to that format by postman.
In my request, I've got .SetRequestHeader "Content-Type", "application/x-www-form-urlencoded" Do I need to change that to "Content-Type", "raw" to be able to specify the parameters in the body in the format above? If I leave it as is, how do I format the parameter string?
Duplicating that JSON format in the body request text, removing the .SetRequestHeader calls that otherwise set those parameters and making the call still yields a "500" error, so I'm not sure if it's because I'm not doing it right or that this isn't the solution...
 
@FreeMan that's not how it work, really.
Content-Type has to be a valid MIME (?) type
 
clutches at straws. lets go of that one
 
the raw simply means to show the body without any formatting/encoding, but isn't a MIME type in itself
hey, @FreeMan ever did a HTTP on a telnet?
 
take a wild guess at what the answer to that question is gonna be... I'll give you 3 chances...
 
1:48 PM
ok, have you actually seen how HTTP request/response look like?
 
@FreeMan Yes, No, and Maybe?
 
LOL
 
@Hosch250 exactly right, except for the first and third...
 
Yeah, I knew it was "No" from your response.
 
@this beyond what I've seen in Postman over the last couple of weeks trying to make this work, no.
 
1:49 PM
But I was trying to think of a third response to a boolean question.
 
well done! ^
@this looking
 
The key point is that HTTP communication are basically just text with certain conventions.
So question: how do you know what the format of the request body is if it can be anything?
 
@this a much more succinct way of asking what I was trying to get to above...
 
well, there's two ways to touch your nose. ;-)
anyway, the expectation is that the Content-Type has to actually conform to the actual content of the request.
if you say Content-Type: application/x-www-form-urlencoded and provide a XML body, you've told the server a dirty filthy lie
because the server is going to be expecting it to look something like these
 
1:57 PM
but... if you have no clue what you're doing it isn't really a lie so much as it is pure simple wrong information... (lack of intent) ;)
 
do not let the fact that you are using a WinHttp client library distract you from the fact that in the end, you must send a well-formed HTTP message
 
OK. read through that. Got a bit of a clue. attempting a reasonable(?) approach...
Holy Carp, Batman, THAT WAS IT!!!!!!!!!
I can haz results and a "200"!!!!!
body = "response_type=xml&c_id=106"
 
it let you do convenient things like SetRequestHeader blah blah, but it will not help you create a sensical HTTP message. For that, you need to know a bit about HTTP. Which is why I made the point earlier that you should get familiar with how the HTTP message actually look like, using raw views.
:+1:
 
thank you thank you thank you thank you!!!!
life is sooo much harder when yer stupid and fail to read directions
 
now you can tell the tech support, "Yo, a rando jerk in a chatroom worked it out. You suck."
 
2:00 PM
@FreeMan LOL, reminds me of a comic I saw.
 
Now, I wonder if I can make all the calls with properly formatted body parameters or if some need body and others need request headers.
 
With one area marked "Stupid people here -->".
 
@this if only you were a jerk, I would do that.
 
@FreeMan FWIW, I went through a period of head-banging myself. The fact that I was using XmlHttpRequest did not help at all because frankly , the abstraction leaks badly
 
well, at least I knew I didn't know what I was doing.
 
2:02 PM
The trouble with those libraries is that they only make it easier to set up a HTTP request and read a HTTP response but they do nothing whatsoever to help you not make nonsense requests.
@this Negative much?
since they leak more than punctured wet brown paper bag, you have no choice but to know HTTP.
 
At the end of the day, you can only go so far anyway.
Even in C# ASP.NET MVC, you need to know it eventually.
 
well, I done learnt me some HTTP today. A very small bit, I'm sure, but it's a start.
 
Probably but at least with newer frameworks/nuget packages, it's easier to avoid get all mucked up in HTTP plumbing.
The older WinHttp or XmlHttpRequest libraries, OTOH, are horrid.
 
OK, I added a bodyParameters property to my IRESTDriver class yesterday and t'ain't working as I'd expect... The call:
  Dim apiCall As IRestDriver
  Set apiCall = RESTDriver.Create(URL, REQUEST_GET_CUSTOMERS, SITE_ID, API_KEY)

  With apiCall
    .RequestHeader("Content-Type") = "application/x-www-form-urlencoded"
    .bodyParameter("response_type") = "xml"
and the Leters:
Private Property Let IRestDriver_RequestHeader(ByVal key As String, ByVal Value As String)
  this.requestHeaders.Add key, Value
End Property

Private Property Let IRestDriver_bodyParameter(ByVal key As String, ByVal Value As String)
  this.bodyParameters.Add key, Value
End Property
Private Type TInfo
  requestHeaders As Scripting.Dictionary
  bodyParameters As Scripting.Dictionary
End Type

Private this As TInfo
Implements IRestDriver
the Let IRestDriver_RequestHeader works just fine, but the Let IRestDriver_bodyParameter gives me a RTE 91
 
2:17 PM
@mansellan LOL!
 
they are defined the same. they are implemented the same, they are called the same, but they no function the same.
never mind...
had one, needed the second:
  Set this.requestHeaders = New Scripting.Dictionary
  Set this.bodyParameters = New Scripting.Dictionary
derp
 
2:34 PM
I'm gonna have to assume that the tech support guys never looked at the code I sent them. If they had, you'd think they'd have noticed that I was sending parameters as request headers instead of in the body.
however, since I'm the one who noticed the difference in Postman when they were screen sharing, and when I mentioned it their response was "well, maybe..." that maybe they don't realize the difference...
 
more likely, they don't actually use their own API
so they are no better than some random nimrod on the internet
 
well, when he started screen sharing, he did have Postman open with a bunch of requests, but that may have been only for testing for this particular issue...
 
my point is more that if they were dogfooding, they would have known it was wrong from get-go
 
@MathieuGuindon I am promoting your wisdom here:
See the screenshot in this answer. Columns returns a Range, and _Default is the default member. Hopefully someone like Mathieu Guindon can provide a more thorough answer. His article here about default members is a good read. — BigBen 5 mins ago
 
does anyone know if installing 2019 will include 3.0 or is it a separate thing?
 
2:46 PM
im probably not going to get 2019
not really worth it for my company to upgrade the two of us using it
we dont do enough .net programming
 
@this I think if you get the 16.3 version, it includes it.
 
@this don't disagree at all, just trying to give the benefit of the doubt...
 
@Hosch250 found under the individual components.
 
@this checked by default or no?
 
IDK - I went directly to individual instead of workloads
#DoNotTrustMicrosoft
 
3:07 PM
@BigBen posted :)
 
downloading + installing 2019 I hope 2019 won't be such a slow pig like 2017 is.
 
@this I think it's a little faster.
 
@Hosch250 did you get RD compiling under 2019 yet? I saw some of the discussions about it yesterday.
 
Not yet.
Monday I didn't have to do dishes, since most of the family was gone.
So I was able to work on it through that time.
 
Needs a little ol' love tap.
 
3:18 PM
Yesterday, I went horse riding, then worked on my resume for my new company.
They wanted a different structure to share with their clients.
 
@this not sure I know what that's referencing. Not sure I want to know... :S
 
That's usually a swift kick toward the misbehaving machine.... at least that's what I've been told
 
ooohhh.... "percussive maintenance"... now I get it!
 
3:41 PM
AV software completely lacks any reasonable logic for when scans are needed. Should only be the first open for read/exec after the file was changed. — R.. 15 hours ago
Actually, that's exactly what it is...
At least, that's what I read about Windows Defender, anyway.
You can prove it too.
Run a full-scan on your system, and it'll take a couple hours. Do it again, and it'll finish in about 15 minutes.
 
meh. the whole fearware thing is stupid.
Does anyone pay a rent-a-cop to watch after their unlocked house when they are away? No, and it'd be a crappy way to protect the house since the rent-a-cop might look other way while his buddies raid the fridge while accosting your distant relative from visiting.
 
But there are city cops.
Hence you have a single AV installed and running in the background to stop drive-by attacks.
And don't attract attention to yourself for targeted attacks.
 
city cops aren't looking after your house specifically
 
Actually, they kind of are. You can get increased patrol if you need.
 
Locking up your house is far more effective than paying someone (directly or indirectly) to watch and trusting them to do the job.
Even granting that, they're of no help once you've already have been burglarized.
 
3:47 PM
Exactly. I view a background AV as more like a deadbolt than an AR-15 that automatically shoots anyone whose fingerprint it doesn't like.
Even if the commercial companies advertise it like the latter.
 
I don't think it's like that at all
It can't work like a deadbolt.
because it basically has to look for suspicious intruders and pin them. It'll get it wrong inevitably and you end up being screwed up.
A deadbolt is simply not allowing them in the first place.
 
Depending on your AV and how you set it up, it can basically not allow them--stopping suspicious executable files from running.
 
no they're already there
I'm saying they shouldn't be even there
 
@Hosch250 I think I like that idea!
 
Well, when people stop clicking links in emails and stop using the web, that can happen.
 
3:57 PM
PSA: Registration is now open for Hacktoberfest 2019!
 
@skiwi!!! waves
 
hey @FreeMan
 
> This year, the first 50,000 participants who successfully complete the challenge will earn a T-shirt.
 
and it's 4 PRs
gosh, they'll be out of tees by Oct.2nd
 
Hacktoberfest registration link for those like me that need a little help.
 
4:07 PM
Registered. A bit on the fence over the new design, though.
 
I don't see myself getting one this year on account of classes.
 
4:28 PM
seems that several API requests have parameters that must be put in the body to work. Weird, because they work in the "Params" section of Postman, but not in the .requestHeaders of WinHttp.WinHttpRequest
 
i dont' have postman in front of me ATM but if you look at the raw view, where does stuff in Params section go?
 
4:40 PM
not sure I follow you. When I select Params, I see the Query Params and I see all the key/value pairs I've specified. When I click Body, I see 2 key/value pairs (I believe I entered them, I've tested so many things I'm not 100% sure) under form-data, but they disappear when I click any of the other radio buttons, including raw. screenshots:
BTW, from tech support:
> I'm glad to hear you got it working. I'm honestly surprised the other calls are working with the parameters in the headers, since I know they will all work with them passed through in the body.
well, then, if that's the case you should say that in your docs!!!!
the docs for all the calls I've looked at say "Query String"
 
hmm raw looks like a place for you to hand-craft stuff but doesn't actually show you what was sent
 
one of them has a small section of parameters that says "Query String" and a long list that says "Request Body"
 
I am pretty sure there was a place somewhere where Postman will show you the actual raw request as was sent
(unless it's a figment of my imagination....)
 
there are a couple of little orange words to the far right... Cookies, Code and (unavailable) Comments(0). I clicked Code and got this:
 
my concern is that the Params is kind of confusing because it looks like it'll be for query string but you chose the form-data so that'll be formatted as a form-data.
 
4:47 PM
POST /Appointments/GetAppointments?Authorization:Basic=<snip>:<snip>&amp; response_type=xml&amp; location=106&amp; start_date=20190924&amp; end_date=20190924 HTTP/1.1
Host: ws.appointment-plus.com
Content-Type: text/plain,multipart/form-data; boundary=--------------------------031106076178821554951247
Authorization: Basic <snip>
User-Agent: PostmanRuntime/7.17.1
Accept: */*
Cache-Control: no-cache
Postman-Token: 4f2fe7a8-88e4-4c78-b473-7b516a4947b9,bce49aaa-1391-4f69-b010-8cd584c157e7
Host: ws.appointment-plus.com
 
hence why I keep on asking to see the raw version
 
^ that what you're after?
 
yes
except... I don't see any of the params.
oh it's in the POST
the first line
 
POST /Appointments/GetAppointments?Authorization:Basic=<snip>:<snip>&amp; response_type=xml&amp; location=106&amp; start_date=20190924&amp; end_date=20190924
yeah, that...
 
.... that feels all kind of wrong.
 
4:49 PM
funny thing... in that same code box, I can ask it to write the code for me in a variety of languages. Here's what they give for C#:
 
I assume <snip>:<snip> is your editing
but I would hope that they are not literally sending &amp; in the query string
 
var client = new RestClient("https://ws.appointment-plus.com/Appointments/GetAppointments?Authorization:Basic=<snip>:<snip>&response_type=xml&location=106&start_date=20190924&end_date=20190924");
var request = new RestRequest(Method.POST);
request.AddHeader("cache-control", "no-cache");
request.AddHeader("Connection", "keep-alive");
request.AddHeader("Content-Length", "284");
request.AddHeader("Cookie", "PHPSESSID=mrnhsnke5m0t7ic3un502vjg21");
request.AddHeader("Accept-Encoding", "gzip, deflate");
 
wait, that's even wrong -- Auth shouldn't be in the header, either.
 
@this Yes, I cut out our user ID/Pwd
and the uuencoded base-64 encoded version of it as well
 
I think that might be a problem: text/plain,multipart/form-data
multipart is different from www-urlencoded
anyway, I expect that if you change the radio button in Postman to say.... XMl, the raw will be quite different.
and hopefully has a body
 
4:53 PM
don't think I follow you on that... Look at the last 2 images I posted. They're both of the "Body" tab, but different radio buttons selected. It's like each list is kept separately, they're not just different views of the same stuff...
tech support now says:
> I would recommend passing everything through the body. When we are working with anything in Postman here at AppointmentPlus we work exclusively by passing everything through the body. There are some weird things like the one you described below that can allow the call to still work properly.
okey dokey...
seems they weren't actually paying attention to what I sent them, since I sent them the code I was using, and I showed them my screen in the conference call and none of them noticed I was adding everything as a request header.
 
One possibility is that the framework they're using does some kind of negotiation.
 
Body it is...
 
HTTP is basically VBA without Option Explicit
 
lol
yuch
is this still appropriate as a header? .RequestHeader("Content-Type") = "application/x-www-form-urlencoded"
based on the C# code I posted, I would think so.
7 mins ago, by FreeMan
var client = new RestClient("https://ws.appointment-plus.com/Appointments/GetAppointments?Authorization:Basic=<snip>:<snip>&response_type=xml&location=106&start_date=20190924&end_date=20190924");
var request = new RestRequest(Method.POST);
request.AddHeader("cache-control", "no-cache");
request.AddHeader("Connection", "keep-alive");
request.AddHeader("Content-Length", "284");
request.AddHeader("Cookie", "PHPSESSID=mrnhsnke5m0t7ic3un502vjg21");
request.AddHeader("Accept-Encoding", "gzip, deflate");
 
5:16 PM
hm, is it just me or "find all references" just doesn't work at all for project refs?
i.e. from the CE's "Project References" node (e.g. when VBA project references an Excel add-in), "Find all references" is enabled, but does nothing
and then running "find all references" against the VBA type library returns results from all opened projects, regardless of what project node you've clicked
 
Isn't He-Who-Knows-All supposed to know that?
;)
 
hm, he who thinks he knows it all, knows nothing
 
@FreeMan but who is the "He-Who-Knows-All"?
 
he who knows he doesn't know it all knows very little
@this I thought it was the guy asking the big questions, but it seems I was wrong
 
@FreeMan Knows more than the guy who knows it all.
 
5:22 PM
See, he disqualified himself in the very asking, ergo, he cannot be that guy.
As soon as it is spoken, it is broken. What is it?
 
1 min ago, by FreeMan
@this I thought it was the guy asking the big questions, but it seems I was wrong
 
:-)
 
@this specs?
 
Anyway that popped in my head when I saw Freeman's question about he who knows it all.
@MathieuGuindon well it's broken once it's no longer abstract. As long it's abstract, you can say whatever the hell you want.
 
@MathieuGuindon truer words have never been [sp|br]oken
 
5:25 PM
Kind like how perfect circles can only exist in imagination but never in physical world.
 
phew - my 2nd guess was "breaking news"
 
LOL. That'd have been a hilarious take.
 
@this reminds me of this
but yeah, euclidian geometry in general can only ever be approximated IRL
 
Yeah I heard a story like that. I would have loved to see it executed. Surely no easy feat!
 
5:34 PM
I've started to code work's first Core 3 lib - an extension to GenericHost for WPF
 
Fun!
 
loving it :-)
 
oh yeah, I have had that happened too many times!
Clippy never was gone. He just lives underneath the hood, screwing with us all.
 
5:38 PM
Also: CSV? Here, let me just "optimise" that for you. File changed forever!
@this CSV - Clippy's Secret Vendetta
 
yeah. That stupid UV is still "started" since year and few odd months.
 
6:04 PM
Heh, someone on work's IM posted "Does anyone know how to open DBML files in VS 2019?" I posted "2007 called, it wants its ORM back" :-)
 
Meme is about as old as LinqToSql, so it seemed apropos :-)
 
@Hosch250 Alt, E, A, A for the win.
 
@mansellan "it's Core 3.0, not .NET 3.0"
 
> A sadist and a masochist married, on the wedding night the masochist said 'hurt me', 'no' replied the sadist.
LOL.
 
6:09 PM
@MathieuGuindon lol!
 
Posted in the C# design chat.
They were discussing carolina reapers and ghost peppers.
 
Kinda wonder why they're gonna call the next version Core 3.1 though, Core 4 would have fit far better with their roadmap. I guess they just felt nervous about having another major 2 months after 3, but that's the only reason I can come up with and it seems weak-sauce.
Maybe semver I guess, but they can't know yet whether anything will be breaking...
 
My boss' boss is still trying to get me to stay.
Telling the architects to try to keep me working on what I like.
(IMO, that's wouldn't be good for either me or the company...)
 
@mansellan wasn't it to avoid confusion w/ FX 4?
since NC 5 will unify them
 
6:19 PM
5 is basically Core 4.
Being "unified" just means Core will finally have all the features from FX.
 
@this ah yes, that makes sense. It's just kinda a shame, because other than 3.1, all even numbers will denote LTS...
 
Less than stellar?
 
Heh, perhaps... officially Long Term Support :-)
 
> "It helps me type faster" is actively harmful if your successor has to squint and stop and think and try to make sense of your prefixing scheme - it's distracting, and slows down reading the code.

Programming is at a minimum, 80% reading, not writing. Learn to type faster instead of making reading harder than it needs to be.
 
odd numbers will be more innovative
 
6:23 PM
this has to be one of my best ones
 
Yeah, I never really bought into "terse = better" camp
 
0
Q: Tick. Tick. *breathe* BOOM! - Taming the SetTimer API (part 1)

GreedoWinAPI Timers can be quite tricky to work with, as anyone who's tried to use them and fallen foul of one of the many pitfalls probably knows. Problems such as screen freezing, crashes, uncontrolled printing to the debug window etc. will be familiar, and so I've tried to make some code to mitigate...

 
@MathieuGuindon I would say more like 95%+ reading...
IME
 
No. I peg it at 80% reading, 15% WTFing and 5% writing.
5
 
yes. you're right :-)
 
6:32 PM
80-20 rule is never wrong, 80% of the time.
 
not exactly a "never" there....
 
80% of infinity is still infinity :)
 
just a slightly smaller version of it... ;)
 
Actually, nope. There's no "smaller" or "bigger" infinity.
infinity + 1 == infinity
 
6:34 PM
there's "negative infinity" though. go figure.
 
See: Horbert's Hotel
 
infinity ^ infinity = infinity
 
if I recall, you can infinity * -infinity = 0
 
@MathieuGuindon that's direction, not scale
 
#Words
 
6:36 PM
I do wonder though whether there's maths in "how fast a sequence approaches infinity". waaaay past my understanding to know though, not a maths geek.
 
@this there's a reason there's a ;) at the end of that...
 
@mansellan I don't think that works out
I conceive of infinity as being basically unreachable
Therefore, regardless of sequences you're using, you're reaching the infinity just as fast
 
eh, plot two sequences. the one with the greater slope is the winner :)
 
@this It has been an idle thought since high school. If there were ever a Discovery show that answered it, I'd watch. That's the limit of my interest :-)
 
6:38 PM
sure, one sequence can increase in magnitude faster than other, but that doesn't take it to infinity sooner.
 
@this :brainsplode: damn, math is blurring into philosophy at that level
 
Also, consider that you cannot traverse infinity in a finite number of steps
 
you cannot traverse infinity (period) ...no?
 
well, if you're a infinite set of number, you're already infinite.
 
But if, in 20 years, I hear of breaktroughs in "infinity math", I'll be like "dang, I intuited that when I was 12" :-)
 
6:39 PM
you can be either infinite or be finite but you can't go from finite to infinite or vice versa.
 
Layman's terms - if your equation causes an infinity, give up.
Infinities are why General Relativity breaks down for the Big Bang and black holes. It's maths shorthand for "we have no idea".
 
 
^^
 
wonders where "Range._Default assigns to Range.Value" fits in on that scale
misses "mathematical" criteria
 
6:44 PM
instead, only realise this: there is no Range
 
000001001010101011111000101111110010000100100000000000000000001111110010101010100110101101010
hopes that doesn't translate to bad words in some language
 
Bah, ReSharper license expired, and I'm on sabbatical from uni so can't register for another. Guess I'll have to use my works license (which should be fine, it's per-person)
 
posted on September 25, 2019

Thank you to everyone who came to events on my book tour! If you weren't able to make it to any of my tour events, How To is now available everywhere, including at Barnes and Noble, Target, Amazon, local independents, and more. Some Barnes and Noble locations and indies have special signed copies, so you can check with your bookseller to see if those are available.

 
I think Randall is lurking in this chat room.
 
@Feeds the hover text applies to Access SQL
 
6:58 PM
@Feeds Strangely timely :-)
@FreeMan If only we had parenthesis highlighting :-)
 
00:00 - 19:0019:00 - 00:00

« first day (1937 days earlier)      last day (1243 days later) »