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

[Joshua Gauthier]

Thanks very much,

i used your_variable[0][0:10] that got me the amount of decimal places I was
looking for

greatly appreciated.

On 1/19/07, Daniel Arbuckle <djarb at highenergymagic.org> wrote:
>
> 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
> >
> >
> >
>
> _______________________________________________
> socal-piggies mailing list
> socal-piggies at lists.idyll.org
> http://lists.idyll.org/listinfo/socal-piggies
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.idyll.org/pipermail/socal-piggies/attachments/20070119/43fa11c1/attachment.htm>