Note on: Re: Solved [Was: Re: [NTLUG:Discuss] OT: sql embedded in shell script (sh) passing parameters]

[fredjame]

Just a quick note on the cause of the problem - bad data set.
Herein I publicly own that I forgot to verify the test data myself.
My bad.

fredjame wrote:

> My apologies - I was right the first time when I said I didn't really 
> know what was happening in this.
>
> The answer to the particular part is
> AND ih.inv_type = '$InvType'
> (yep, as simple as that)
>
> Another bug in the code was masquerading as the above problem - I 
> introduced a few extra debugging lines which proved that much, now I 
> am off looking into that.
> Thanks again for all your help.
>

-- 
...small is beautiful.