473,378 Members | 1,134 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Displaying data to 2 decimal points

Hi there,

I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP
page.
I have a money column in a SQL table that contains money income values.

When data is input to this field it needs to be displayed as money (to 2
decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the extra 0,
and if 7.6 is entered, it is still displayed as 7.6

I need all data to be displayed as money values (and it is selected as money
in SQL), so is there any way (either in the table design, View design, or
display on the ASP page) to get the data to 2 decimal places, no matter
what?

Thanks for you help, in advance

--
G

www.bradflack.com

Please remove ANTI and SPAM from my
email address before sending me an email.
Jul 19 '05 #1
10 5645
Guy Hocking wrote:
Hi there,

I have an ASP/SQL 7 application that rips data from SQL Views onto an
ASP page.
I have a money column in a SQL table that contains money income
values.

When data is input to this field it needs to be displayed as money
(to 2 decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the
extra 0, and if 7.6 is entered, it is still displayed as 7.6

I need all data to be displayed as money values (and it is selected
as money in SQL), so is there any way (either in the table design,
View design, or display on the ASP page) to get the data to 2 decimal
places, no matter what?

Thanks for you help, in advance


Use one of these vbscript functions:
FormatCurrency
FormatNumber

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #2
Hi,

Thanks for the response -

Any examples of the functions in my scenario?

Cheers

--
G

www.bradflack.com

Please remove ANTI and SPAM from my
email address before sending me an email.
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:O9*************@tk2msftngp13.phx.gbl...
Guy Hocking wrote:
Hi there,

I have an ASP/SQL 7 application that rips data from SQL Views onto an
ASP page.
I have a money column in a SQL table that contains money income
values.

When data is input to this field it needs to be displayed as money
(to 2 decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the
extra 0, and if 7.6 is entered, it is still displayed as 7.6

I need all data to be displayed as money values (and it is selected
as money in SQL), so is there any way (either in the table design,
View design, or display on the ASP page) to get the data to 2 decimal
places, no matter what?

Thanks for you help, in advance


Use one of these vbscript functions:
FormatCurrency
FormatNumber

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #3
Guy Hocking wrote:
Hi,

Thanks for the response -

Any examples of the functions in my scenario?

Given that you have not provided any details about your scenario (where are
you having a problem? Connecting to the database? Retrieving data in a
recordset? Reading the data from the fields in the recordset?), I can't
offer any examples beyond what is shown in the online documentation. Perhaps
that is what you need ... ? Here is a link:

http://tinyurl.com/7rk6

Just look up the functions in there once you have downloaded and installed
it. A Google search or a search of www.aspfaq.com could also provide you
with some examples of their use.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #4
Hi there,

Apologies for that.....

I have downloaded the script docs, and it is very useful, ta.....
But i was wondering how i would incorporate this into my SELECT statement?

See entire code below -
*******
<%
Dim strConnect, DataConnection

Set DataConnection = Server.CreateObject("ADODB.Connection")
strConnect = "DRIVER={SQL
Server};SERVER=server;UID=user;PWD=password;DATABA SE=database"
DataConnection.Open strConnect
%>
<%
Dim RS
Set RS = DataConnection.Execute("SELECT col2, currencycol FROM view
WHERE col1='" & Session("listbox") & "'")
do until RS.EOF

<a href= "page.asp?col1=<% =RS("col2")%>"><% =RS("col2")%></a>

<% =RS("currencycol")%>

<% RS.MoveNext
Loop %>
*******

How/where can i format the "currencycol" ???

Thanks again

--
G

www.bradflack.com

Please remove ANTI and SPAM from my
email address before sending me an email.
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:#$*************@TK2MSFTNGP10.phx.gbl...
Guy Hocking wrote:
Hi,

Thanks for the response -

Any examples of the functions in my scenario?
Given that you have not provided any details about your scenario (where

are you having a problem? Connecting to the database? Retrieving data in a
recordset? Reading the data from the fields in the recordset?), I can't
offer any examples beyond what is shown in the online documentation. Perhaps that is what you need ... ? Here is a link:

http://tinyurl.com/7rk6

Just look up the functions in there once you have downloaded and installed
it. A Google search or a search of www.aspfaq.com could also provide you
with some examples of their use.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #5
Guy Hocking wrote:
Hi there,

Apologies for that.....

I have downloaded the script docs, and it is very useful, ta.....
But i was wondering how i would incorporate this into my SELECT
statement?
Why do you need to put it in your Select statement? Just use the appropriate
function when writing the results to your page. Like this:
<% =FormatCurrency(RS("currencycol"),2)%>

If you really want to do it in your query, look up the CONVERT function in
SQL BOL.

Here is an example for you to run in QA:

select convert(varchar(20),cast(45.1213 as money))

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #6
Wicked, that works great, 1 thing -

Its coming up in dollars $
How can i get it to do it in pounds

Cheers

--
G

www.bradflack.com

Please remove ANTI and SPAM from my
email address before sending me an email.
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:uM**************@TK2MSFTNGP10.phx.gbl...
Guy Hocking wrote:
Hi there,

Apologies for that.....

I have downloaded the script docs, and it is very useful, ta.....
But i was wondering how i would incorporate this into my SELECT
statement?
Why do you need to put it in your Select statement? Just use the

appropriate function when writing the results to your page. Like this:
<% =FormatCurrency(RS("currencycol"),2)%>

If you really want to do it in your query, look up the CONVERT function in
SQL BOL.

Here is an example for you to run in QA:

select convert(varchar(20),cast(45.1213 as money))

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #7
Guy Hocking wrote:
Wicked, that works great, 1 thing -

Its coming up in dollars $
How can i get it to do it in pounds

It depends on which one you did. I suspect you're talking about
FormatCurrency rather than the T-SQL CONVERT, so add this line of code to
your page:

session.LCID=2057

The problem is that the Regional Settings for the IUSR account are the
default (US) settings. You can override that with the LCID property.

Bob Barrows
PS. If you were talking about the CONVERT alternative, simply prepend a
pound symbol:

select char(163) + convert(varchar(20),cast(45.1213 as money))
or
select '&pound;' + convert(varchar(20),cast(45.1213 as money))

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #8
Bob Barrows wrote:
Guy Hocking wrote:
Wicked, that works great, 1 thing -

Its coming up in dollars $
How can i get it to do it in pounds

It depends on which one you did. I suspect you're talking about
FormatCurrency rather than the T-SQL CONVERT, so add this line of
code to your page:

session.LCID=2057


Sorry, I should have said
Response.LCID =2057

The Session setting will affect all pages accessed during the session,
unless overridden with the Response setting. If you use the Session setting,
it should be done in global.asa.

Bob Barrows
PS. I just realized you included the sql server setup group in your
crosspost. That did not seem to be an appropriate group so I've just removed
it from this reply. If any sql server group was relevant, it would have been
..programming.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #9
Exellent, the session LCID worked a treat,

Thanks for the wonderful service you ppl provide

--
G

www.bradflack.com

Please remove ANTI and SPAM from my
email address before sending me an email.
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl...
Guy Hocking wrote:
Wicked, that works great, 1 thing -

Its coming up in dollars $
How can i get it to do it in pounds

It depends on which one you did. I suspect you're talking about
FormatCurrency rather than the T-SQL CONVERT, so add this line of code to
your page:

session.LCID=2057

The problem is that the Regional Settings for the IUSR account are the
default (US) settings. You can override that with the LCID property.

Bob Barrows
PS. If you were talking about the CONVERT alternative, simply prepend a
pound symbol:

select char(163) + convert(varchar(20),cast(45.1213 as money))
or
select '&pound;' + convert(varchar(20),cast(45.1213 as money))

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #10
U guys are amazing. I am very new with asp. i found thses information very useful.

Thanks a LOT :)
Apr 21 '06 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Rahul Chatterjee | last post by:
Hello All I have an asp page in which I am performing the following 1. Querying a database view 2. Returning rows in to a recordset. 3. Looping thru the recordset and printing the data 4....
5
by: Michael Hill | last post by:
Hi, folks. I am writing a Javascript program that accepts (x, y) data pairs from a text box and then analyzes that data in various ways. This is my first time using text area boxes; in the past,...
4
by: pmud | last post by:
Hi, I have an image which resides on a different server...on data server. I am developing on Development server. When I use the image URLin my ASP.Net web page as ...
1
by: .Net Sports | last post by:
the below itemdatabound function works , displays all the grand totals in the footer control of the datagrid: private void dglvboard_ItemDataBound(object sender,...
0
by: Sam | last post by:
I am trying to use a Simple form with 3 fields from SQL NorthWind Database (Order Details Table with 3 Fields. - OrderId, ProductId and Unit Price). The Field Unit Price has a data type of 'Money...
0
by: Sam | last post by:
Folks.. I am trying to use a Simple form with 3 fields from SQL NorthWind Database (Order Details Table with 3 Fields. - OrderId, ProductId and Unit Price). The Field Unit Price has a data...
4
by: Ronald S. Cook | last post by:
We're designing the data model for a project. The app will be in .NET, the database will be in SQL Server 2005. I'm a little confused on type conversion between the two and which I should...
20
by: D.M. Procida | last post by:
I'm trying to find a guide for the formatting and presentation of numbers in web pages, which will answer questions along the lines of what if anything to use as separators in large figures, how to...
1
by: drwigginton | last post by:
I have created several bar charts in MS Access using query results to provide the data for the chart. I added data tables to the charts to show the actual values. My problem is that one of the fields...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.