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

[Joshua Gauthier]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.idyll.org/pipermail/socal-piggies/attachments/20070119/b8f705fe/attachment.htm>