|
|
Posted by Dave Smith on 11/11/05 02:28
That worked! Thank you very much!
Dave
In article <1131667753.659031.233300@f14g2000cwb.googlegroups.com>,
"ZeldorBlat" <zeldorblat@gmail.com> wrote:
> One way is to fetch the row as a numerically-indexed array and use the
> numeric keys. The preferred (and much better) way is to alias the
> column names in your query. So something like this:
>
> CLNT_STATS_YTD.Vol_Collected as YTD_Vol_Collected
> CLNT_STATS_MTD.Vol_Collected as MTD_Vol_Collected
> CLNT_STATS_TD.Vol_Collected as TD_Vol_Collected
>
> Then, when you fetch the result, you can refer to the columns as
> YTD_Vol_Collected, MTD_Vol_Collected, etc.
Navigation:
[Reply to this message]
|