Johnathon

Wright

"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...

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. **...

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...

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...

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...

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...

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.^ ...

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...