Displaying Data To 2 Decimal Points
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?
View Replies
ADVERTISEMENT
let's say there will be 4 files for 2 questions. Qn1.asp Q2.asp Check1.asp Check2.asp
Check1.asp consist of the codes below to check Q1.asp and Check2.asp is to check Q2.asp
What do i need to put in the "" in both check1.asp and check2.asp so that if the user answer both the qn correctly it will 2 out of 2.. both wrong 0 out of 2 and so on.. I want the points to be stored inside a database.. Code:
View Replies
View Related
I remember seeing a post with a link to a ranking of members rep points, but I can't find it again. Is it still available? Can anyone post the link or maybe alter the User CP or members pages to include a permanent link? Or have a sticky post?
View Replies
View Related
I have alot to learn!!! If i use the connection below, after i have done my select statement, how do i make a statment to say, if the results are null then write....postcode dissallowed else go on.. Code:
dim post_code
dim pcservice
pcservice = service
post_code = left(Request.Form("postcode"), 4)
connDB.open
Set rsPC = Server.CreateObject("ADODB.Recordset")
rsPC.open "SELECT *, PDA_PD_SER_TAG AS servicetag, PDA_AREA AS area FROM tblPostcode_Disallowed_Area WHERE (PDA_PD_SER_TAG = '" & service & "') AND (PDA_AREA = '" & post_code & "')" connDB, 1, 2 ...
View Replies
View Related
I have a fairly simple (at least in PHP) request but I can not find how do do it. I've seen things that are kindof what I want but not really. Here is what I want:
I have a ton of data in a DB. I want to pull some of that data and display it in a table. In PHP I would create a SQL query called $Result "(SELCT * FROM whatever)" and produce this code:
View Replies
View Related
Is it possible to show different information on a page for different users?
For example a first year student that needs to select modules for this year compared to a second year student how would have to select different modules.
View Replies
View Related
I've got an table that has event name, start date, end date. For instance:
EventID: 1
EventName: My Event
EventStartDate: 1/1/2007
EventEndDate: 1/4/2007
Right now we just display the name, start date through end date (if there's a different end date). So the above looks like:
My Event
1/1/2007 - 1/4/2007
Now instead, they want to have something like the following:
My Event 1/1/2007
My Event 1/2/2007
My Event 1/3/2007
My Event 1/4/2007
Other than trying to create some kind of math calculation based on the date, is there an easier
View Replies
View Related
there will be 4 files for 2 questions. Qn1.asp Q2.asp Check1.asp Check2.asp
Check1.asp consist of the codes below to check Q1.asp and Check2.asp is to check Q2.asp
What do i need to put in the "" in both check1.asp and check2.asp so that if the user answer both the qn correctly it will 2 out of 2.. both wrong 0 out of 2 and so on.. I want the points to be stored inside a database..
<%
r1=Trim(request.form("r1"))
r2=Trim(request.form("r2"))
r3=Trim(request.form("r3"))
I=Trim(request.form("I"))
urans=Trim(request.form("Answer1"))
result= Round(CLng(r3)*CLng(I)/(CLng(r2)+CLng(r3)))
if (CStr(result) = CStr(urans)) then
" "
elseif (CStr(result) <> CStr(urans)) then
" "
End if
%>
View Replies
View Related
I would like to display the data in a table like first 50 records in a column and next 50 records in another columns.
View Replies
View Related
I have a client who is running a Windows Media Server where audio files are streamed with a ASX file. The client wants to display the most recent tracks played on a webpage.
The problem is, how can one find out what is the current track playing on Windows Media Server, so it can take the data and then insert it into a database which the webpage can just take it from there.
View Replies
View Related
I'm using ASP to display data from an Access Database. My question revolves around the data and how it looks using CSS.
1) Do I have to use <p> in my access data to display paragraphs in my story.asp page? Without the <p> I just get one big chunk of data.
Which leads my to my other problem. When I do use <p> in my access data this code won't pick up my CSS class "body". I'm not sure why because I would think it would cascade.
<P class="body"> <%Response.Write (rs("newsBody"))%></P>
View Replies
View Related
I have a page that allows users to sign on and then have access to the site. What I need to do is to have them sign on and see selected (tables) or data that is in the database.
I need some help. How would this be written. Unfortunalely the only book I have on the subject is asp.net. Code:
View Replies
View Related
im currently working on a login system, and its the first time i have had to use an inner join. basically i have 2 tables, an attendance table and a member table. the attendance table contains the following: Code:
View Replies
View Related
I am trying to display a vaule from access (which is set to currency in access) as a currency (2 dp) on a web page. Here is the code: code:
Dim rsDB
Dim strSQL
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )%>
<p><b>Product:</b> <%=rsDB("ProductName" )%></p>
<p><b>£</b><%=rsDB("ProductPrice" )%></p>
<% rsDB.Close %>
Should be easy enough, but I'm just starting out.
View Replies
View Related
I have an ASP web page that displays records from SQL 2005 database. It works fine until I re-order the columns, all values of some columns disappear. I have no error or warning
I tried to change the font and font size, it doesn't effect.
Also I have an update record form, If I re-order the fields, some values disappear Code:
View Replies
View Related
I am creating a dynamic website by using Dreamweaver 8 and Access as the database. I have designed the layout for the website and the database have also been completed. However, when I try to display the data on the webpage, it just won't display. I am also having some problems with the form and recordset.
View Replies
View Related
I am using MS-Access database to display top 10 records containg title and date, and with each record a text named "NEW" is also displaying.
But I want to display "NEW" only with the records which are not older than a week. Is there some way to calculate the present date with the date of each record?
View Replies
View Related
I want to display data like the following:
<table>
<tr>
<td>1 to 10 records</td><td>11 to 20 records</td><td>21 to 30 records</td>
</tr>
<tr>
<td>31 to 40 records</td><td>41 to 50 records</td><td>51 to 60 records</td>
</tr>
</table>
I tried with rowcount it is displaying in a row ancontinully with if conditions also. how to do this or any example script.
View Replies
View Related
I want to be able to display my recordset as follows:
a e
b f
c g
d h
Instead of :
a b
c d
e f
g h
Any links to some examples?
View Replies
View Related
I have to do several operations with values that i capture from textfields, but these values will be integer sometimes and float some other times. I use Cdbl(expression) to get them to double subtype, but i the input have to be in comas for it to work. Like 2,75 instead of 2.75, if the input is like 2.75 it will take 275 as the value..
Anyway I wrote a javascript that takes care of that, changes the textfield input for comas. The thing is, all of the people i tell this act stranged and tell me they have never needed to use comas instead of points, does anybody know why is this? Im affraid my code will not work on some browsers maybe?
View Replies
View Related
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that?
How about 3 columns?
View Replies
View Related
I have a drop down list which pulls Names from a column called 'Name' from an SQL Server view.
In this view is another column called 'ref' and each person has their own unique ref no.
I have linked a drop down list to the Name column (so user can pick name from the list) but now after selecting a particular name, I want my page to also display the corresponding ref for that particular name underneath.
The ref can be displayed just as text on the page.
View Replies
View Related
I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
View Replies
View Related
I've got an application setup that uses freightquote.com API to receive XML responses containing shipping information. A basic response example is as follows: Code:
View Replies
View Related
I'm trying to display three columns in a table row, then I want to create a new row with three columns until there are no more records to display. Unfortunately, my code only displays one column in each row: Code:
View Replies
View Related
I am calling the values from a table and displaying them in a table, no biggie, i have not used a for loop to create the Html table, rather i have created it myself using a for loop so i can specify the table values i want.
What i am calling from the table is All of the fixtures for the football games in a season but i want to put a seperator or insert a spece of some sort just to seperate the fixtures by date otherwise it just comes out in a long list of fixtures, no nice on the eyes.
here is the code from selecting the data form the table to displaying it:
View Replies
View Related
I am trying to display some DateTime data from a SQL Server db using the standard recordset object...objRec("PostTime").value
It displays nothing.
View Replies
View Related
I have this situation:
each user has some amount of points, for example:
table:users
user_id --- user_name --- points
1 --- user1 --- 100
2 --- user2 --- 100
3 --- user3 --- 100
4 --- user4 --- 200
5 --- user5 --- 500
-------------------
total points: 1000
I want to generate random selection of user, according to their points respectively, so the more points he has, the more likely he will be selected:
user1 in 10% cases
user2 in 10% cases
user3 in 10% cases
user4 in 20% cases
user5 in 50% cases
this percentage is respective to their points; I put some rounded numbers in the example - so total points of 1000 equals 100% - but they can have any amount of points: 1, 200, 3672 etc.
View Replies
View Related
I try to debug ASP aplication. I use Visual InterDev 6.0 and Windows
server 2003,but Visual InterDev Debugger Skips Server-Side Break Points. I read thisbug was in asp.dll version 4.02.0622 (WIN NT), but why doesn't it work on WINserver 2003
View Replies
View Related
I used to have some static htm files which used to display data. There is a
calling asp file which used to do something like below
if Request.QueryString("PageName").count = 0 then
strPageNameHtm = "toc.htm"
strPageNameInc = "toc.inc"
else
strPageNameHtm = Request.QueryString("PageName") & ".htm"
strPageNameInc = Request.QueryString("PageName") & ".inc"
end if
strPageNameHtm = server.mapPath(strPageNameHtm)
strPageNameInc = server.mapPath(strPageNameInc)
'response.write(strPageNameHtm)
set fs = server.createobject("scripting.fileSystemObject")
set f = fs.openTextFile(strPageNameHtm)
strSPDHtml = f.readall
The strSPDHTML info used to be displayed using a response.write(strSPDHTML).
This allowed the static content to be loaded up.
I switched the static pages to be asp pages having the content come from a
database. I would still like to maintain the controlling page logic. Can I
modify the above section of code in anyways to access the asp page content
View Replies
View Related
I am having an issue figuring out the correct syntax and possible SQL code to display data from one table (CustEndPoints) with a DropDownList used for a GridView to get data from another table. I have been playing with Joins, which is probably correct, as well as ControlParameters. Code:
View Replies
View Related
I tried to find some components I can use to dynamically
generate chart or graph from database in ASP. It seems to
me that only some other companies have software on this
but Microsoft doesn't have any of them. Am I wrong?
View Replies
View Related
An application is logging faxes sent in SQL2000 image column type. I have
found code on the net but what it is doing is prompting to save to local
which is fine for single page image. Not good for multiple page faxes. I
have not been able to locate an example to load in the browser or how to
handle multiple image in the one column. Code:
View Replies
View Related
