MustModify Blog: Recent Posts

Finding a faster query for USQL

December 17, 2012
"select sum(NOI_AMOUNT) FROM NOI WHERE NOI_ALLOC_DATE = { d '2012-12-05' };" ~ instant select NOI_TRN_NUMBER, sum(NOI_AMOUNT) FROM NOI WHERE NOI_ALLOC_DATE = { d '2012-12-05' } GROUP BY NOI.NOI_TRN_NUMBER; ~ instant select TRAN_TYPES.TRN_NAME, NOI_TRN_NUMBER, sum(NOI_AMOUNT) FROM NOI, TRAN_TYPES WHERE NOI_ALLOC_DATE = { d '2012-12-05' } AND...


koding.com advice on being a great consultant

November 29, 2012
http://blog.koding.com/2012/08/freelance-developers-you-are-the-future-dont-mess-it-up/ I thought this post was insightful, if repetitive. I recognized just about all of the issues discussed as things that have been problems for me at some point. * The need for professionalism ** If you're being paid, it isn't a hobby. Act professionally. **...


Misys Tiger via ODBC via C#

November 07, 2012
The code below constitutes my various attempts to connect to Misys Tiger via ODBC using C#. Feel free to skip to the word "WiN" to skip the failures. h3. Warning This code below is not inteded to be production-worthy. I just wanted to see data. Excuse the slop. h2. Questions and Answers Q. How do I create a connection to the various...


research on .NET interface to Creative Solutions

October 28, 2012
I am looking for a way to push payments and invoices to Creative Solutions Accounting version 2012.0.9, Client Bookkeeping Services. In researching this topic, I found that it's basically impossible to research. "net" is already sort of ambiguous. Add "creative solutions" and Google has no idea what I want. With that said, I'm not sure whether...


Finding false negatives / false positives in unit tests

October 08, 2012
I get a lot of confidence from seeing my tests fail, then pass. Recently I wondered whether I shouldn't be codifying that. Just because I saw it fail initially doesn't mean I'm not getting a false positive now. *Caution: this is purely theoretical. It's worth exploring on a blog, but the agile part of me realizes that I rarely have issues...


The Somewhat-Extremely-Helpful inverse_of Option

October 04, 2012
Let's say you have the following association set up: --- class Route < ActiveRecord::Base has_many :appointments, :inverse_of => :route # long live the hash rocket! end class Appointment < ActiveRecord::Base belongs_to :route, :inverse_of => :appointments end --- the 'inverse-of' option is supposed to prevent...


Introduction to HL7 Messages for Developers

September 11, 2012
The kinds of HL7 records I will be receiving look something like this: ---hl7 MSH|^~\&|GHH LAB|ELAB-3|GHH OE|BLDG4|200202150930||ORU^R01|CNTRL-3456|P|2.4 PID|||555-44-4444||EVERYWOMAN^EVE^E^^^^L|JONES|19620320|F|||153 FERNWOOD DR.^ ...


Patterns with Valuable - the ModelSearch

August 24, 2012
I find that I write a lot of "advanced search" stuff, and that modeling an advanced search, and having that be in a separate class, is very good for my sanity. h2. DataSearch model The schema is below if you're interested. These models usually start in lib, and then move to app/search once I have four or five. ``` describe DataSearch do it...