« first day (500 days earlier)      last day (3520 days later) » 

3:12 PM
@rolfl / @Mat'sMug have you tinkered much with Full-Text Search in any RDBMS? I'm curious as to what it's actually used for, as opposed to "standard" indexing...
 
As it happens, I was messing with it today... on SEDE, and it's not there.
That is a loaded question though. let me run you through a history lesson.....
databases are rows and columns.
to make them faster, the columns could be indexed, and almost all index systems use some form of b-tree.
this means you can locate data in about log-n time.
That is for 'equi-join' conditions .... where column = 'someval'.
Databases became highly tuned by the DBA's / designers.... and they avoid, for most purposes, IO.
Indexes became much smaller than the data indexed, for the most part.
Some databases are better than others, some use mitmap indexes for some fields, etc. There are some differences, but, what's key, is that:
the index indexes the whole value in the field, not a part of it.
So, along comes big text data, and it sucks, because now you have to index subsets of the data, or, alternatively, you have to scan/process the entire field every time it is used.
So, databases have this data which does not conform to the standard mechanisms available in the system, so they have to come up with a solution.
They all did it differently.
But, the results are that you need to specify full-text on your field, and the database does some fancy analytics, and indexes the data in the column in a different way.
So, that's why you have it, to index sub-parts of text fields.... now, the question is why you need such text fields....
well, the classic example, is you want to search your e-mails, but they ar ein the database.... what to do?
Search for e-mails referencing "Code Review".
your full-text supports that..... but... the rel question is whether your database is the right tool for the job.
For the most part, there's two opinions, yes, and no.
The yes people believe that keeping your data in one place is a good thing, and leads to efficiencies.
the no people will tell you to use a system that is designed for it, like Solr/Lucene (or ElasticSearch)
Now, take Stack Exchange, they have these cool posts....
and a search bar.....
We know they store their data in SQLServer, right?
But, if you search, you are actually hitting their ElasticSearch system which has the text content indexed in a number of fields.
the default field is the 'Body', but you can also search the title, user, date, score, type fields too.
so, searching for [java] title:Database user:me table will perform searches in elastic search on different fields, the tag, title, user, and Body.
The result will be a reference back to the SQL Server document to post in the results.
The classic terms are: structured vs. unstructured data.
The algorithms and data structures needed to index and search unstructured data do not conform well to data stored in rows and columns......
@Phrancis ...... Wake up.
5
 
3:31 PM
hey @JaDogg, long time no seeing
 
yup
I was busy
 
what have you been up to?
 
@rolfl sorry we got busy all of a sudden
 
@janos working, 7 days per week, eh
 
7 days per week is slavery
 
3:34 PM
@rolfl I don't think I can star all of these....
 
@janos Fortunately I'm working at home, No need to go to an office
 
hm, I'd like that
 
@rolfl that's very interesting
 
Technically all points addressed in this question have been answered (apart from the "is anything else wrong?" part): http://codereview.stackexchange.com/questions/62946/array-like-container-for-uints-shorter-than-8-bits

When is the right time to ask a new question with revised code?
 
Thanks for the big fancy explanation :D
 
3:37 PM
You're welcome.... it's not an easy decision about when to full-text search, or when to remove the index from the database entirely.
 
@Christoph when you've revised the code, and your follow-up code looks like it has implemented enough of the recommendations from the previous review, to not generate the same answers ;)
 
@Christoph Good question. If you ....
what Mat's says.
 
...and when I know what I want to ask about the revised code
 
Apply as much from the original advice as makes sense to you, and ... ^^^ that.
Human nature is such that if you appear to be making progress, your question will be welcomed, and things will be taken to the 'next level'.
 
JAVA coders unite and check this question out, is it now fit for reopening? codereview.stackexchange.com/q/62890/18427
 
3:39 PM
I think Jamal is in class, @Malachi ^^^
 
oh... then my Humor was wasted..... :( @Jamal
 
0
Q: Open Closed Principle for IF-ELSE

O.OIn the future there is a good chance that I will need to support another database like mySQL. How to make this code open to extension, but closed to modification? foreach (ConnectionStringSettings connectionStringSetting in configuration.ConnectionStrings.ConnectionStrings) { Connectio...

 
They're not comments, they're notes.
3
 
@CaptainObvious or not?
 
This isn't going to end well......
 
3:44 PM
@CaptainObvious : !!
 
Not's, not Notes.
Self commenting code... means you comment it yourself.
4
 
Crap I'm already out of stars... @rolfl TS ^^
 
@Phrancis RSA
 
@rolfl Some idiot in the department is giving a "class" about scripting in this language we work with. He's no where near qualified, and none of the people he's teaching should even be trying this. I'm going to have a mess on my hands in a few days.
 
/* This next line
** selects all the data
** from my table
*/
SELECT * FROM MyTable;
@RubberDuck ouch...
 
3:52 PM
@Phrancis Yeah....... I don't understand why they didn't just ask the expert to give a class.... he's doing a lot of really stupid shit in his samples.
Which means I now need to go through his network drive and see what he's been up to... because...... fml.... that's why.
 
Sad ducky...
 
0
Q: Returning status codes from business layer C#

ThunderDevThis is what I've been doing so far in my business layer to return error messages to the user. public void CreateMerchant(MerchantCreationModel model, out MerchantCreationStatus status) { //check if merchantId exists MerchantDTO merchant = _merchantRepo.GetMerchant(model.MerchantId); ...

 
no.
 
Please?
 
4:06 PM
Um.... What you call old-style joins were new when I learned them.... last century. I will be ready to use these other joins.... next century ....
but, maybe I will.... maybe
 
You plan on being a very old Monkey.
 
40 pounds lost so far.
 
Why didn't anyone tell me to visit meta yesterday?? visited 259 days, 1 consecutive
 
Oh Simon... that sucks.
Simon says: Visit meta every day!
2
 
I was at 32 consecutive!
Today is apparently 100 days left until Christmas
 
4:14 PM
Nice numbers all around then:
> 321 days, 321 consecutive
 
hey @ptwales
 
@SimonAndréForsberg certainly is!
 
@ptwales I'm just saying I think you should be checking the type you're getting, or add some error-handling in there, to catch whatever error would be raised for trying to iterate an Integer or a String ;)
 
Hello @ptwales!
 
@Mat'sMug I was just letting any error that happened from passing non-iterable's occur. It should raise the appropriate error as is.
 
4:24 PM
a custom error message would probably be more meaningful here though.
but the main point of my answer wasn't the ParamArray suggestion, it was about a bug that makes it look like you're supporting object values
 
true, a custom error messsage would be an appropriate compromise for not specifying iterable.
 
and the List can hold an Integer value at index 1, a String value at index 2, and a Collection value at index 3...
 
`Err.Raise 13, "List.Extend", "sequence is not iterable"
 
^^ much better than whatever error VBA would raise here. should be Err.Raise vbObjectError + 1013 though (well vbObjectError+[any number above 1000] anyway)
 
Perhaps an argument name like "iterable" could make it a bit more self documenting too.
 
4:28 PM
sequence is pretty self documenting IMO
 
Just my two cents.
Is that what it is? Yeah. That's fine.
 
13 is type error which is the error. It's not the correct type.
 
I have an idea that soon I'll be out of stars too
 
+1 for using built in error codes.
I'm already out @swiwi
 
@Mat'sMug Also I'm not concerned about type checking. I already have a TypedList subclass that I will post later after I finish updating List.
 
4:33 PM
subclass?
it's composed with a List, right?
Maybe it's just my background, but I find a List is/should be typed - if it takes anything you throw at it, it's more of a Bag, or a PimpedCollection IMO.
 
What ptwales wrote is more like an ArrayList, where his TypedList is closer to List<T>.
Putting it in .Net terms.
 
As close of a subclass you can get in VBA yes composed.
 
aw, I was sort of hoping you had found a little magic trick :)
 
NOPE
I tried writing an interface but the more I learned about it the less I wanted it.
 
yeah they're COM interfaces.. pretty limited
 
4:42 PM
@Mat'sMug I think we're pushing the poor ancient beast to it's limits at this point....
 
@RubberDuck you are both all three waaaaay beyond it's limits.
2
 
indeed.
@ptwales have you seen this?
3
Q: Automagic testing framework for VBA

Mat's MugBuilding on @RubberDuck's recommendations, I now have something I find... beautiful. I'm sure there's a couple of things left to polish - this site is about making great code out of good any code, right? This code requires trusted programmatic access to Visual Basic Project. 1. Client Cod...

 
@Vogel612 I wish I had a star to give.
 
RSA ;)
 
The List isn't typed because collection isn't. From our pseudo inheritance standpoint it's easier to implement a TypedList as derived from a untyped list.
 
4:43 PM
Indeed, that could use a fresh perspective.
 
Yes I did. I want to use it.
 
@ptwales that just made my day! :)
 
O NO it's new
 
yeah it's not the hacked-up one!
zero boilerplate now :)
 
Hey, we're all smart guys. Instead of re-inventing the wheel all the time, why aren't we all just building a framework together?
6
 
4:45 PM
That's what I was thinking. Just start modernizing VBA for poor saps who have to use it.
 
Accepting pull requests... nudge nudge wink wink
4
 
lol
bbl, time for lunch
 
0
Q: Autocomplete Trie Optimization

driestI'm currently playing with the Typeahead problem on Talentbuddy. There are already 2 questions on this subject(Typeahead Talent Buddy and Typeahead autocomplete functionality challenge), but none of these use a trie which is why I created a new one. Problem Statement Given a big list of user...

 
I already have one but your's looks nicer.
https://github.com/ptwales/vba-extension
 
> "added ALL the things."
 
4:53 PM
@Vogel612 ^^ TS
0
A: Database of students in a social network

PhrancisIn addition to what @200_success said, I would like to mention one thing: Old-style join This is an old-style join: select id2 from friend f, highschooler a where a.name='Cassandra' and a.id=f.id1 While they work just fine, they are ANSI-89 and they are not the norm and it would be good for ...

 
@ptwales But I don't have the nifty os file system stuff. =)
@Vogel612 Damn right I did.
 
@Phrancis But how will you make both friend and friend-of-a-friend relationships work?
 
Laters ;)
 
Do someone know if I can specify more than one trustore with Djavax.net.ssl.trustStore ? I'm searching but I did not find a way yet.
 
@200_success in context (with the rest of the query and the UNION) it would work like this, no?
 
4:59 PM
Yup. Stealing using that os module in my VBEX project. That okay @ptwales?
 
Unless you can make the whole query work, I would consider "you should use JOIN" to be parroting advice blindly.
 
Good point. Hadn't thought of it that way. I'll delete it for now and test it from home, and post the revised query
 
2
Q: Unit testing a servlet in a meaningful way

DieParteiI have to write a unit test for the method processRequest in the servlet below and I'm wondering if: It just shouldn't be done. The class should be rewritten / refactored to allow easier unit testing. Suggestions as to how? There is a meaningful way of getting the value of response.getWriter()....

0
Q: Time to Next Departure

user4047248I am trying to calculate the time to next departure based on current system time in Java. I am so far not familiar with the many aspects of Java, but i have managed to get the program to work in most use cases with a switch statement and while loop, but it feels like i am using too many workarou...

 
(or leave deleted if it doesn't work, of course)
Thanks for pointing that out @200_success better to have no answer, than an answer that's potentially wrong.
 
@RubberDuck @ptwales I have an ADODB wrapper I originally wrote in VB6 for SQL Server, turns out it works perfectly fine in VBA with MySQL. Also I have a bunch of string helper methods, including my implementation of .net-like String.Format.
oh and I have a MVP "namespace" coming up, too
 
5:12 PM
Well, I'm okay with whatever repo, or multiple repos, whatever, but it seems silly for all of us to keep building the same stuff. And I'm sure there are others who could benefit from it.
I'm heading off for a bit though. Ping me and I'll get back to you.
 
I have a bunch of things to say about the automagic test framework, should I post a selfie or wait a little? @ptwales if you're considering answering, I'll wait :)
 
I won't be able to get to it early today it will be after I get off work. Got a back log of files to process.
 
I won't be able to get to it until much later tonight, too.
 
Are you on github? we should organize what should be repos and what should have dependencies or stand alone.
 
yeah, though not very active lately
 
5:17 PM
same here
 
now I wish I had a VB6 IDE, to compile a COM library that could just be referenced in any VBA project
 
Not like the the one build into excel?
 
you can't compile a VBA project into a DLL with the VBA IDE
and the COM DLL could be referenced in any flavor of VBA
 
Do those exist anymore? Because asking people to import 50 modules into their project is going to be absurd.
We need to make that happen
 
perhaps we should write it in C# (or VB.NET, for the "feel"?) then build a COM-visible class library.
it sort of kills the fun though.. I like what we've been doing with VBA
 
5:21 PM
true but I actually use this crap everyday.
 
doing it in .net would make it easier to work with GitHub / source control
oh but the "reflection" part wouldn't work :(
 
?
 
unless... can we reference and use the VBE library from a .net project?
 
Honestly I don't know how windows development works and Wikipedia is blocked at work so I can't answer these questions now
 
@Mat'sMug With the new Mojang API's Microsoft has available, you will likely be able to dig yourself out of these holes, but whether they are backported to VBA is yet to be announced.
2
 
5:25 PM
 
@Mat'sMug RSA
 
:)
 
Maybe I haven't been to Iceland because I'm busy dealing with YOUR crummy code.
4
 
lol
2
"Maybe I haven't been to Iceland because I'm busy dealing with YOUR crummy code."
 
Im out for now. I have already forked ckuhns stuff. I'm down for redoing it some larger things in VB.NET/C# if it gets us around barriers and prevents importing many files and dependecnies.
 
5:29 PM
Hi everyone :)
 
out as well. gotta work a little!
hi @Morwenn!
 
Hey
 
BBL
 
Morwenn, hi!
 
Did you know that the slides from the presentations at CppCon2014 are available on GitHub?
There are really good talks there ^^
@Mat'sMug @rolfl How are you? :)
 
5:31 PM
ornery
and you?
 
Quite good. Looking for a job.
 
Oh, by choice?
 
I am not a student anymore. And if I wait too long, I don't think that I will have much money left...
 
I heard there was decent money to be made in the music industry. ..... :(
 
It is hard to find a job that is both good and in the town I want :p
 
5:41 PM
Wondering what this is then...
> NASA to Make Major Announcement Today About Astronaut Transport to the International Space Station
 
Once again, I wrote an answer about a technology I never used.
 
I did manage to take this picture today though
 
Writing a void method with an out parameter in c# should be a capital offense :|
 
^ This doesn't seem realistic for 1944
 
@DanLyons who.. why would someone do that????
@Morwenn been worse :)
 
5:53 PM
I'm not sure. I've seen it in legacy code and even a few CR questions.
 
unless it's enforced by an interface a legacy COM interface... but that would be ref, not out...
1
A: Time to Next Departure

unholysamplerLets take a look at the first two cases of the switch statement. case 10: System.out.print("Departure in " + (Math.abs(initialTime - 10)) + " min."); break loop; case 20: System.out.print("Departure in " + (Math.abs(initialTime - 20)) + " min."); break loop; These follows...

oh and this is golden:
> Empty try-catch blocks go beyond "code smells" to "steaming piles of rotting flesh that have been baking in the sun all afternoon." I get an ulcer every time I see this.
5
A: Returning status codes from business layer

Greg BurghardtStatus codes have long gone the way of the Dodo --- made extinct by exceptions, actually. The problem with a status code is that it can be ignored. An exception cannot. Consider these two examples. Using Status Codes First, the "merchant repository" implementing CRUD operations for merchants: ...

 
6:10 PM
@rolfl re: decent money in the music industry = myth for the most part
 
The sarcasm runs deep in me today....
 
@Mat'sMug TS and
 
Uh ohhh.
 
I wonder if Stack Snippets should work on deleted answer ?
 
What?
 
6:15 PM
Well, you just joined ;-)
 
Just slowly restoring all my tabs.
 
Seeing if you were paying attention...;-)
Crash?
 
Intentional reboot.
 
I just had to restart firefox... odd things happened.
like instead of opening things in a new tab, all the link sin chat started opening in new windows instead.
 
Although it was because I was fixing problems caused by a crash earlier.
 
6:17 PM
But I cheat ;-) I have a linux machine at home with tabs open everywhere.... it is very unlikely to reboot/disconnect.
so, it appears that I am always there.
 
0
Q: Ruby: Trying to integrate icalender 2.1.2 for ruby with dashing widget

Marvrick Jean-BaptisteI'm using Dashing http://shopify.github.io/dashing/ to create a Google Calender widget provided by https://gist.github.com/akalyaev/6387762 to parse .ics files from my Calendar. I have followed the instructions to the T and have installed the gems as necessary and when the event is sent I get an ...

 
@skiwi Trippy
@rolfl my Linux box is turned off, I lost internet for a couple of days....should have it back tonight when I get home though.
anyone want to reply to this?
I see that there is a Code Review Meta which looks like to be more generic. Maybe this thread should be find its place in it ? Am I wrong (again) ? — Winz 2 hours ago
 
Done
 
well done @Marc-Andre
 
0
Q: Apply Integration of dirac function for matlab code

user8264I am try to implement a algorithm that here. For explain that algorithm. I already explain at mathematic. And now, I do it by myself. The main problem is that I want to implement the formula (7) in the reference paper. So as the suggestion from some people I assume $f(z)$ can denotes f_z=[0.01 0...

 
6:31 PM
@Mat'sMug Thanks!
 
If you're looking to find programmers to speak to, without specifically reviewing your code, you could try our chat room perhaps. A lot of the CR regulars hang out there. — Phrancis 35 secs ago
 
Although, this specific chat room is not for extended help/tutorial/information gathering sessions..... If you get engaged in an extended discussion, start a new chat room
 
Thanks Monkey I added that into my comment
 
Good point there, @Mat'sMug .... hmmm
Apparently it may be a mod privilege ;-) ?
 
0
Q: Binary Search in Ruby

user663848I want to write a search that raises an error if the list supplied is not sorted. This seems like an O(n2) problem in itself, which defeats the purpose of the binary search. Also looking for other comments on the search itself, alternatives in ruby. class BinarySearch attr_accessor :list d...

 
6:38 PM
or we create a "Monkeytaurium" chat room dedicated to teaching sessions?
(that'd make yet another tab for you to keep open!)
 
Primarium?
 
I think it benefits community when the old goat wizened monkey shares his vast knowledge ;-)
 
Just so long as it does not intefere with site-specific issues?
 
Right
 
dude, chill out - when the room is filled with lurkers, you're free to say whatever anything that lurkers won't be tempted to flag :)
 
6:43 PM
Well, I just wrote a pong program.
it responds to pings.
Now, all I need to do, is deploy it on a few thousand virtual machines, and establish a heartbeat among them.....
and then monitor which ones go down....
 
.... or .... you could actually ping them?
 
because, my next job will be to randomly kill them, and make sure they come up again.
 
chaos rolfl
:)
 
so the monkey is making a chaos monkey
 
Naahh.... I have to build in application high availability on a cloud-scale multi-datcenter system.
exactly, and I am reading all about netflix while I do.
And then, when I get all those things working, I will swap out pong for a super-sekrit application.
But, the point, is that I am writing pong as part of a billion dollar investment ... ;-)
 
6:47 PM
in case you haven't run across it yet, the simian army is up on github: github.com/Netflix/SimianArmy
 
Yup. Going through a bunch of things including the army.
(and not just me...).
 
Would anyone object to migrating this question to Stack Overflow?
4
Q: Pow function optimization

cassandradiedAssume that we have a function that takes array and exchange all elements with their power with exponent 2: void pow(int* arr, int count) { for (int i = 0; i < count; ++i) { arr[i] *= arr[i]; } } How can I speed up this code? I mean, the part with multiplication. I was thinkin...

 
0
Q: Array-like container for uints shorter than 8 bits (Rev 1)

ChristophThis is a follow-up to Array-like container for uints shorter than 8 bits In short: The PackedBitfieldArray should be a kind of container for packed (unsigned) ints shorter than 8 bits. It provides proxy objects for manipulation and iterators. What I have changed: PackedBitfieldArray::end() n...

 
AVX is an IBM power term.... let me check.
 
@200_success his edit of the text invalidated the answers :s
 
6:52 PM
have I lost my mind or found it? codereview.stackexchange.com/a/63067/18427
 
Oh, interesting.
 
as it is now, SO is a better fit, yeah
 
In that case, rolling back would be more appropriate.
 
maybe it makes sense to roll back, and he should ask his reworded version on SO
 
… except that Morwenn also responded to the new question.
Ick.
 
6:55 PM
OP was talking about Error Handling, but I didn't see any Error Handling.....
 
Upvotes to all answers, and close as "Unclear what you are asking?"
 
for my part, I won't mind if migrated
 
0
Q: HeapSort Efficiency

CodeWriterFor heap (array based) sort, we need to start at index 1, ignoring the 0th index. If I want to make a static function like public static void heapSort(int[] array){ } The user shouldn't care about leaving the 0th index empty. And I don't want to allocate a new array (only to start from the 1s...

 
The answers would look a bit out of place on Stack Overflow.
I'm going to close it with a recommendation to ask again on SO.
 
@200_success Which question?
 
6:58 PM
4
Q: Squaring all integers in an array

cassandradiedI have a function that takes array and replaces all integer elements with their square: void pow(int* arr, int count) { for (int i = 0; i < count; ++i) { arr[i] *= arr[i]; } } How can I speed up this code? I mean, the part with multiplication. I was thinking about assembly mag...

You can choose to answer the same question again and earn double credit.
 
Oh right. I had alreay forgotten.
 
@200_success makes sense to me
btw thanks a lot @200_success for rewriting this one the other day: codereview.stackexchange.com/q/62955/12390
 
I was writing an answer when I realized that you had already responded.
 
0
Q: Is this function good?

WannaBeGnomeI have written this function. It surprisingly works. (I didn´t really know what i was doing, just a little experiment.) It is supposed to count rows selected by PDO query. Is it well written? It works, but i am just asking, as it is my first more complex function. function countRows($sql, $param...

 
The title is no good.
2
 
7:14 PM
^^ TS
Man, the amount of questions I would be able to review if I learned a little PHP... (returns to not learning PHP)
4
 
^^ and ^^ ^^ TS
 
@Morwenn You there?
 
@syb0rg On phone.
 
@Morwenn Okay, take your time. I was just wondering how I would go about doing what @200_success suggests in this answer by allowing M to just be the default value when the enter key is pressed.
 
I really like @syb0rg's C++ series btw
 
7:25 PM
@janos Good! I'm hoping some reviewer's can track along with me to learn the language better like I am trying to do.
 
it writes like a story
I can almost see in front of my eyes a blog, titled: "a syb0rg's odyssey in the land of C++"
3
 
C++ is a lifelong journey.
 
@syb0rg Ok, I'm back. I will have a look :)
 
@Morwenn Right now std::cin won't accept just the plain newline character, it wants something with it
So if I press enter it just hangs and waits for "actual" input
I tried doing something else with getchar(), but that didn't work out very well in the end
 
0
Q: Brainfuck interpreter not working with nested loops

PinkponyprincessI quickly wrote a Brainfuck interpreter in javascript last night, it worked great and i was very proud of how quickly i created it and it worked , then i encountered the problem of nested loops,so i quickly started working on updating the code, but with no success , i have spent 5/6 th of my enti...

 
7:35 PM
Too bad it's off-topic, @SimonAndréForsberg would have loved that one ;-)
 
almost as long as @RubberDuck 's
0
A: Automagic testing framework for VBA

MalachiLook what I found Dim procedureName As String, lastFound As String Dim procedureBody As String Personally I don't like declaring variables like this, and almost every language allows you to do this in some way or another. I think this is one of those holy war issues though, some programmers ...

 
Thanks, Santa!
 
@syb0rg That's when I realize that I hardly ever use console input. You could read a line from std::cin with std::getline and check its length but it seems overkill.
 
Hmmm :/
 
@Phrancis I like the Brainfuck part, don't like JS :)
 
7:39 PM
char c = '\n'; std::cin.get(c); then?
char c; std::cin.get(c); seems to read the \n correctly.
 
@CaptainObvious Pinkponyprincess was a nice username!
 
@Mat'sMug what are you talking about?
 
@Morwenn The previous newline is captured and then stored in gender
	std::cin.get();
	std::cin.get(person.gender);
That works though
 
@syb0rg At least, that allows to check whether you got a newline and simply add if (c == '\n') c = 'm'.
 
time to give blood!
 
7:46 PM
@Morwenn True
 
@syb0rg Of course, std::cin.get_or(c, 'm'); would have been better, but there isn't such a function.
 
@Morwenn Is that a POSIX function or something?
 
@syb0rg No, but std::optional will have value_or, and Python's dict.get can take an argument in case the required value does not exist.
So the pattern could have been adapted to streams :p
 
David Haney on September 16, 2014

On Stack Overflow and our other code-related sites, creating a minimal, complete, and verifiable example is the best way to get an answer to your question. We’ve always loved JSFiddle and sites like it because they let both askers and answerers reference runnable, working code that demonstrates their problem or solution.

Unfortunately, the use of these external sites introduces a few problems:

If the link breaks, the post becomes worthless.

If the code isn’t embedded in the page, visitors are forced to go elsewhere to get the full content of the question or answer. …

 
@ptwales, @mat'smug, I do it in vba because I don't want to end up in dll hell. And modules wouldn't necessarily need to be imported, everything could be packaged in a *.xlam or *.accde. I have a snippet that will import an entire directory into a project. So, builds aren't bad.
 
7:49 PM
Hello @mariosangiorgio
 
hello everyone
 
1
Q: How to best structure code that shells out to an external script?

Dean RadcliffeThis code that shells out to an external script to return some things to its caller is a bit strange to me, but I can't put my finger on what seems weird about it. Input welcome, praise and critique. module CompanyLib class S3 attr_reader :output def set_path local, remote @pat...

0
Q: PHP: Better way to replace string value in an array with an array?

AnonyMouseI'm new to PHP so I'm not sure how to optimize this code. I execute a Python script from PHP and the $output variable returned is an array of arrays. exec (" /Users/$USER/anaconda/bin/python /Applications/MAMP/cgi-bin/Evaluation1.py",$output) Each array within the $output array contains one s...

0
Q: Searching a Word Document from Excel v2.0

slow_excellenceMy first question is located here. Since then I have implemented most of the suggestions by RubberDuck and Comintern. I have also added functionality for different-sized spreadsheets (horizontal and vertical), read multiple files in during a single run of the macro, and a bunch of constants. Thi...

 
Should we keep the tag? This OP just created it
 
@Phrancis I was just about to ask. :-)
 
At least rename it to to be clear and consistent with SO.
 
7:54 PM
Right
 
OK I did
 
-1
Q: Bad OO practice in Java RPG?

mafagafogiganteI am developing a really simple text-based RPG and need help to clear something out. An instance of the Hero class has a Location object (many of the Hero's methods interact with this Location). But, it makes no sense to say that Hero has-a Location (logically), although this is by far the most...

 
When looking through other potential MS Word questions, I came across this mess of a question.
 
Indeed, horribly horrible ^
 
Wow. Blech.
 

« first day (500 days earlier)      last day (3520 days later) »