[socal-piggies] Reminder: meeting this Thursday 01/18 at USC 7 PM

[Daniel Arbuckle]

That looks to me like the value you want is inside a pair of nested
1-tuples. try using YOUR_VARIABLE[0][0]

On 1/19/07, Joshua Gauthier <jjgauthi at gmail.com> wrote:
> The decimals are fine, i am trying to eliminate the parenthesis, and commas.
>
> thanks for the start though, i will look into output format.
>
> Josh
>
>
> On 1/19/07, Chris Hughes <christopher.hughes at gmail.com> wrote:
> > Is it a decimal field type?
> > If it is make sure that its represented as such.
> >
> > OR
> >
> > In your select do
> > select field1, field2, format(field3,2) as field3 from whereever
> > If that isn't suitable use the round function instead.
> >
> > -C
> >
> > On 1/19/07, Joshua Gauthier <jjgauthi at gmail.com> wrote:
> > > Greetings everyone,
> > >
> > > I have a quck question, I am running a query out of mysql and dumping it
> to
> > > txt, but I am experiencing some formatting issues, I would prefer my
> query
> > > to just dump a raw number instead of something similar to this:
> > >
> > > ((54948.899902343997,),)
> > >
> > > any sage advice you can give would be greatly appreciated.
> > >
> > > Thanks
> > >
> > > Josh
> > >
> > > _______________________________________________
> > > socal-piggies mailing list
> > > socal-piggies at lists.idyll.org
> > > http://lists.idyll.org/listinfo/socal-piggies
> > >
> > >
> > >
> >
> > _______________________________________________
> > socal-piggies mailing list
> > socal-piggies at lists.idyll.org
> > http://lists.idyll.org/listinfo/socal-piggies
> >
>
>
> _______________________________________________
> socal-piggies mailing list
> socal-piggies at lists.idyll.org
> http://lists.idyll.org/listinfo/socal-piggies
>
>
>