Formatting Numbers in Database Results

RoadKill · External Since: Feb 03, 2009 Posts: 3

Okay, so I have several averages that are being displayed in my results page.
How can I get it formatted to two decimal places instead of the 14 that it
presently has?

4.78 looks a lot cleaner than 4.77777777777778

We are running V2003.

Thank you

Karl E. Peterson · External Since: Dec 10, 2003 Posts: 10

RoadKill wrote:
> Okay, so I have several averages that are being displayed in my results page.
> How can I get it formatted to two decimal places instead of the 14 that it
> presently has?
>
> 4.78 looks a lot cleaner than 4.77777777777778

What are you using to read from the database?

If ASP/VBS, use FormatNumber(TheValue, 2).

http://www.w3schools.com/vbScript/func_formatnumber.asp
--
..NET: It's About Trust!
http://vfred.mvps.org

RoadKill · External Since: Feb 03, 2009 Posts: 3

It is ASP via the Wizard. Here is one of the averages:

<td align="center">
<%=FP_FieldVal(fp_rs,"AvgOfQuestionSeven")%></td>

"Karl E. Peterson" wrote:

> RoadKill wrote:
> > Okay, so I have several averages that are being displayed in my results page.
> > How can I get it formatted to two decimal places instead of the 14 that it
> > presently has?
> >
> > 4.78 looks a lot cleaner than 4.77777777777778
>
> What are you using to read from the database?
>
> If ASP/VBS, use FormatNumber(TheValue, 2).
>
> http://www.w3schools.com/vbScript/func_formatnumber.asp
> --
> ..NET: It's About Trust!
> http://vfred.mvps.org
>
>
>

Karl E. Peterson · External Since: Dec 10, 2003 Posts: 10

RoadKill wrote:
> It is ASP via the Wizard. Here is one of the averages:
>
> <td align="center">
> <%=FP_FieldVal(fp_rs,"AvgOfQuestionSeven")%></td>

Gonna have to shift into manual at some point, unless you're happy with being Wizzed
upon.

<%=FormatNumber(FP_FieldVal(fp_rs,"AvgOfQuestionSeven"), 2)%>

--
..NET: It's About Trust!
http://vfred.mvps.org

> "Karl E. Peterson" wrote:
>> RoadKill wrote:
>> > Okay, so I have several averages that are being displayed in my results page.
>> > How can I get it formatted to two decimal places instead of the 14 that it
>> > presently has?
>> >
>> > 4.78 looks a lot cleaner than 4.77777777777778
>>
>> What are you using to read from the database?
>>
>> If ASP/VBS, use FormatNumber(TheValue, 2).
>>
>> http://www.w3schools.com/vbScript/func_formatnumber.asp
>> --
>> ..NET: It's About Trust!
>> http://vfred.mvps.org

RoadKill · External Since: Feb 03, 2009 Posts: 3

Cool, that works. I hear ya and am rebuilding it without the Wizard now.

Thanks for the help.

"Karl E. Peterson" wrote:

> RoadKill wrote:
> > It is ASP via the Wizard. Here is one of the averages:
> >
> > <td align="center">
> > <%=FP_FieldVal(fp_rs,"AvgOfQuestionSeven")%></td>
>
> Gonna have to shift into manual at some point, unless you're happy with being Wizzed
> upon.
>
> <%=FormatNumber(FP_FieldVal(fp_rs,"AvgOfQuestionSeven"), 2)%>
>
> --
> ..NET: It's About Trust!
> http://vfred.mvps.org
>
>
>
> > "Karl E. Peterson" wrote:
> >> RoadKill wrote:
> >> > Okay, so I have several averages that are being displayed in my results page.
> >> > How can I get it formatted to two decimal places instead of the 14 that it
> >> > presently has?
> >> >
> >> > 4.78 looks a lot cleaner than 4.77777777777778
> >>
> >> What are you using to read from the database?
> >>
> >> If ASP/VBS, use FormatNumber(TheValue, 2).
> >>
> >> http://www.w3schools.com/vbScript/func_formatnumber.asp
> >> --
> >> ..NET: It's About Trust!
> >> http://vfred.mvps.org
>
>
>
>