I recently posted this question on my implementation of an ADODB Wrapper Class. I realized in my own review that I was missing some very important things, so much so, that I decided it would be worth it to re-write the entire class. Saying that I have done quite a bit of restructuring so I am goi...
@PeterMTaylor Thanks. One of the goals of the article was to have been a showcase for this -- github.com/zspitz/ExpressionToString . Not sure it was really successful.
That's 16 books in my wishlist, 1 physical one I own and haven't yet started, and one I just "bought" today for $0 (a RavenDB book with a finished manuscript that they didn't bring to publication).
LOL! At least this is one of the less self-destructive addictions. About the only issue you might have is if a bookshelf collapses under all that weight and lands on you.
The big buzzy words are just a name given to what’s happening when we identify a procedure’s dependencies and decide to inject them. Like any procedure that needs to invoke Workbook.Worksheets.Add must depend on a given specific Workbook object. If the workbook we mean to work with is the document that’s hosting our VBA project,… Continue reading Dependency Injection in&…
> Hi, we've got a new video webcast and again, we're giving away ten (10) $100 Amazon gift cards during the event...and we'd love to have you join.The event is Sept 24 at 1pm ET, will last under 1 hour (promise) and is titled: "Your Ultimate Guide to Phishing Mitigation"
It sure feels like a phishing attempt
It seems, though that "Roger Grimes, KnowBe4’s Data-Driven Defense Evangelist" is a real guy working for a real company that actually attempts to edjumacate people on phishing and social engineering attempts.
This search consists of two functions QuickMatch() which searches for the value and getQuickRowValue() which returns the value of a given row. Both functions have a SearchBy As SearchByIndex parameter which is used to determine which values will be compared. For instance: getQuickRowValue() can...
I've got to admit... looking at the code posted in that image, I'm a bit flummoxed by If 2 = 1 Then... Why not just remove the dead, unreachable code? — FreeMan8 secs ago
@FreeMan though I've now received 2 emails for bizzarro stuff from some company I've never signed up with for stuff I'm not interested in...
@Hosch250 I don't doubt it. It's also something promoters of time-share vacation homes do in order to get you into their strong-arm presentations. I'm not claiming that this email was a phishing attempt, but it certainly smelled phishy when I saw the pop-up notification, and as I started reading it. It was only when searching for the speaker's name that it gained legitimacy. Poorly designed email, and more spam than phish, since I didn't sign up for their messages.
> The above comment to remove the corresponding keys from other .resx files is in the form of a question, so I'm hesitating to do so - though it sounds like a good idea. The only other alternative I can think of would be to create an issue for each language .resx - then, at least, the updates would be tracked. Preference?
Regarding xmldoc examples. I've not done one before, but using the existing inspection as an example, it looks fairly straight forward. It looks to me as though the resu
> > The above comment to remove the corresponding keys from other .resx files is in the form of a question, so I'm hesitating to do so - though it sounds like a good idea.
Please go ahead with deleting the keys - it makes it much easier to spot entries that need to be edited /re-translated when going over what resource keys are missing a translation. If the keys remain, it's too easy to miss the change: translators usually only need to look at missing resource keys, as opposed to reviewing ev
> #5011 implemented this for inspections. Quick-fixes, refactorings, and other features could probably also use similar xml-doc to generate content for the website, but let's have separate issues for that.
i.e. you have a 3-pin DC power supply, a 2-pin DC power supply, and you need to plug them both into a USB port: you make an adapter that takes both 3-pin and 2-pin DC power supplies, and outputs to a USB port :)
Sounds great. Will have to build in some more tech debt cause this one is has to be done ASAP and I don't have time to learn something new right now. :(
why pay today when you can pay with interest tomorrow?
Several Small Furry Animals Grooving in a Cave with a Pick
#bestSongTitleEvar
very bizarre, @MathieuGuindon. I've been using your logger (TYVM!) for quite some time. Every now and then, Access refuses to compile and complains that DebugLevel is not a valid name.
Usually a compact & repair, and/or closing Access or Excel will fix it.
even better, this "db" has all of one local table for some initialization config stuff (and another one for a test that 'the other "programmer"' has added) - everything else is linked to SQL server
@FreeMan It was a DB I was learning Access/Normalization on. Had no idea about C&R until after the file became bloated worse than Aunt Gertrude after Thanksgiving dinner.
@Vogel612 thanks! it was supposed to go live ~2AM, but my internet decided to go on strike and "something bad has happened" when I hit [publish] last night ...luckily everything was still there this morning!
I've only received 2 responses to my API call attempts "200 OK" and "500 Internal Server Error". Are these part of a standard collection of errors that I'd get, or are they custom to the API I'm calling?
thanks @Vogel612. ATM I'll simply log the return code and monitor by hand. If I have a null string, I'll skip the attempt to load that to the server...
Just saw this in the API docs (well, OK, resaw it - I'm sure I saw it previously, but that it didn't register then):
<?xml version="1.0" encoding="utf-8" ?>
<APResponse>
<resource>locations</resource>
<action>getlocations</action>
<request>GetAllLocations</request>
<result>success</result>
<errors>
<error>If there were any errors they would show here.</error>
</errors>
I guess that means I could get a "200 OK" response, but that there'd be something in the <errors> tag?
yeah... I was getting that earlier when I didn't know to Base64Encode the ID:PWD in basic:Auth - I had a 200 OK, but no data back at all. not even a message in <error>
@Duga I'll try to make a round of issue-review over the weekend. I'm sure a bunch of dupe issues are still open, and another bunch are stale or not relevant anymore
although, I have to say we're quite good with issue management, despite the high count
Backstory: I'm creating department level workbooks that contains director-level information, so I can't use a single workbook (as easy as it would make this). I need to split (and combine) 4 workbooks into 140 or more. I manage to do this relatively quickly (~30 minutes), but I was hoping to spee...
> :man_facepalming: was about to suggest changing all `hasResults` to `hasResult`, then noticed its the plural in other inspections. This is a bloody mess and it's all on me.
[Website is indeed looking for `hasResult` (singular)[https://github.com/rubberduck-vba/RubberduckWeb/blob/eb207eec1436527d61715491c812000957197f4c/RubberduckWeb/RubberduckWeb/Models/InspectionInfo.cs#L48] - feel free to make another commit to make it `hasResult`, if not then it'll be fixed in a PR that covers/reviewe al
> :man_facepalming: was about to suggest changing all `hasResults` to `hasResult`, then noticed the pluralized attribute is used in other inspections. This is a bloody mess and it's all on me.
[Website is indeed looking for `hasResult` (singular)[https://github.com/rubberduck-vba/RubberduckWeb/blob/eb207eec1436527d61715491c812000957197f4c/RubberduckWeb/RubberduckWeb/Models/InspectionInfo.cs#L48] - feel free to make another commit to make it `hasResult`, if not then it'll be fixed in a PR that
> :man_facepalming: was about to suggest changing all `hasResults` to `hasResult`, then noticed the pluralized attribute is used in other inspections. This is a bloody mess and it's all on me.
[Website is indeed looking for `hasResult` (singular)](https://github.com/rubberduck-vba/RubberduckWeb/blob/eb207eec1436527d61715491c812000957197f4c/RubberduckWeb/RubberduckWeb/Models/InspectionInfo.cs#L48) - feel free to make another commit to make it `hasResult`, if not then it'll be fixed in a PR tha
@if (Model.ResultExamples.Any())
{
<dt>The following code example(s) would trigger this inspection:</dt>
<dd>
@foreach (var example in Model.ResultExamples)
{
<p>
<div class="vbe-mock-debugger">
<div class="code-area">
<div class="code">
<div class="block">@Html.Raw(example)</div>
</div>
</div>
</div>
</p>
}
@BZngr just metadata that tells the website whether to put that example under "this example code would trigger the inspection" or "would not trigger this inspection"
@if (Model.NoResultExamples.Any())
{
<dt>The following code example(s) would <strong>not</strong> trigger this inspection:</dt>
<dd>
@foreach (var example in Model.NoResultExamples)
{
<p>
<div class="vbe-mock-debugger">
<div class="code-area">
<div class="code">
<div class="block">@Html.Raw(example)</div>
</div>
</div>
</div>
that said there should probably be some markup for identifying separate code files within an example; currently we identify separate code files with comments
needs some tinkering though, since that would break the assumption that example tags only contain a CDATA tag
eh, I'm finding out that Shopify's InventoryItems API requires inventory item IDs in the querystring. IOW I'm going to have to pull each item one by one, as a "child request" of each ProductVariant item. #Joy
@MathieuGuindon just as a reminder that you probably already knew but it would go into RubberduckMeta.sln. Note also that you have to restart VS or kill msbuild.exe instances if you have built Rubberduck.sln, then switch to RubberduckMeta.sln in same session
ok, gettin' on the phone to rattle a cage and see why I haven't had anything other than the auto-response to my support ticket from yesterday. They've had 8 biz hours to at least response wiht a "that's weird, we're looking into it"