Thanks very much,<br><br>i used your_variable[0][0:10] that got me the amount of decimal places I was looking for <br><br>greatly appreciated.<br><br><div><span class="gmail_quote">On 1/19/07, <b class="gmail_sendername">Daniel Arbuckle
</b> <<a href="mailto:djarb@highenergymagic.org">djarb@highenergymagic.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
That looks to me like the value you want is inside a pair of nested<br>1-tuples. try using YOUR_VARIABLE[0][0]<br><br>On 1/19/07, Joshua Gauthier <<a href="mailto:jjgauthi@gmail.com">jjgauthi@gmail.com</a>> wrote:<br>
> The decimals are fine, i am trying to eliminate the parenthesis, and commas.<br>><br>> thanks for the start though, i will look into output format.<br>><br>> Josh<br>><br>><br>> On 1/19/07, Chris Hughes <
<a href="mailto:christopher.hughes@gmail.com">christopher.hughes@gmail.com</a>> wrote:<br>> > Is it a decimal field type?<br>> > If it is make sure that its represented as such.<br>> ><br>> > OR
<br>> ><br>> > In your select do<br>> > select field1, field2, format(field3,2) as field3 from whereever<br>> > If that isn't suitable use the round function instead.<br>> ><br>> > -C
<br>> ><br>> > On 1/19/07, Joshua Gauthier <<a href="mailto:jjgauthi@gmail.com">jjgauthi@gmail.com</a>> wrote:<br>> > > Greetings everyone,<br>> > ><br>> > > I have a quck question, I am running a query out of mysql and dumping it
<br>> to<br>> > > txt, but I am experiencing some formatting issues, I would prefer my<br>> query<br>> > > to just dump a raw number instead of something similar to this:<br>> > ><br>> > > ((
54948.899902343997,),)<br>> > ><br>> > > any sage advice you can give would be greatly appreciated.<br>> > ><br>> > > Thanks<br>> > ><br>> > > Josh<br>> > ><br>
> > > _______________________________________________<br>> > > socal-piggies mailing list<br>> > > <a href="mailto:socal-piggies@lists.idyll.org">socal-piggies@lists.idyll.org</a><br>> > >
<a href="http://lists.idyll.org/listinfo/socal-piggies">http://lists.idyll.org/listinfo/socal-piggies</a><br>> > ><br>> > ><br>> > ><br>> ><br>> > _______________________________________________
<br>> > socal-piggies mailing list<br>> > <a href="mailto:socal-piggies@lists.idyll.org">socal-piggies@lists.idyll.org</a><br>> > <a href="http://lists.idyll.org/listinfo/socal-piggies">http://lists.idyll.org/listinfo/socal-piggies
</a><br>> ><br>><br>><br>> _______________________________________________<br>> socal-piggies mailing list<br>> <a href="mailto:socal-piggies@lists.idyll.org">socal-piggies@lists.idyll.org</a><br>>
<a href="http://lists.idyll.org/listinfo/socal-piggies">http://lists.idyll.org/listinfo/socal-piggies</a><br>><br>><br>><br><br>_______________________________________________<br>socal-piggies mailing list<br><a href="mailto:socal-piggies@lists.idyll.org">
socal-piggies@lists.idyll.org</a><br><a href="http://lists.idyll.org/listinfo/socal-piggies">http://lists.idyll.org/listinfo/socal-piggies</a><br></blockquote></div><br>