i have some problem in showing data. I have two tables . First table(containing Hosting categories). Second table(Containg catagories data like l,keyword,description.....etc). I want to display catgories names from first table and then diffrent catagories total records from second table, like this
ASP.NETHosting(10)
Linux Hosting(20)
Windows hosting(13)
:
:
:
etc
i have some problem in showing data. I have two tables
First table(containing Hosting categories)
Second table(Containg catagories data lik
url,keyword,description.....etc)
I want to display catgories names from first table and then diffrent catagories
total records from second table, like this
ASP.NETHosting(10)
Linux Hosting(20)
Windows hosting(13)
i am developing a hosting directory web site on this site there will be the links of hosting websites, i want that when user click on a particular website link it will be recorded in the database how it could be done.
View Replies View Relatedi need some help with my asp project. there few text field . for user to enter in amount. and i need the system to auto calculate the total everytime user finish enter amount in a text field. another problem is how can i make the text field accept number only?
View Replies View Relatedi am developing a hosting directory web site on this site there will be the links of hosting websites, i want that when user click on a particular website link it will be recorded in the database how it could be done.
View Replies View RelatedI need to calculate a total based on fields in a repeat region, these values are stored in an SQL db, all are numeric and written in ASP.fields are
TOTAL_COST VAT GRANDTOTAL (Page selects records based on
field parameter and displays in a repeat region)
At bottom of page need to show total sum like
TOTAL_COST(sum of above)
VAT(sum of above)
GRANDTOTAL(sum of above)
how to write a function to calculate total amount to nearest penny in ASP using VBSCRIPT.
View Replies View Relatedhow can i get a total number of filtered records? what's the code?
View Replies View Relatedi'm using command object like this:
objCommand.CommandText = strSQL
strSQL being a SELECT string.
then executing it:
Set rsRec = objCommand.Execute
how can i get total number of records found, changing the line above to this:
Set rsRec = objCommand.Execute totRec
gives me an error and doing just this:
totRec = rsRec.RecordCount ....outputs -1
I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)
Joe Bloggs ---> 100 Closed
Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:
I have been asked to design a page where users login.
The users list is accessable from a drop down list which is taken from an SQL server table
The user, when selected then click next to login to a page where their name, associated with thier username is displayed.
Now I am a total newbie to this, can anyone guide me in the right direction?
Im trying to figure out how i can do the following:
I used a search script to select data from the database now each record has a figure such eg. £125.56 and so you can end up with rows like:
£125.56
£12.34
£.456.76
What I want to be able to do is have a select box to the right hand side where you select certain records and if possible at the bottom will have a live update showing the total of the selected items.
Does anybody know of a script?
I am trying to add the price and shipping to equal the total price and display it in a table(receipt) I am able to get the price and shipping and handling to write to the page, but not sure how to add them together to get the total price:
The below code gives me $40.00$ 3.00 I want it to show as $43.00 ($40 + $3.00)if they ordered 500 business cards or $75.00 ($72 + $3.00)if they ordered 100 business cards.
<%
quantity = Request.QueryString("quantity")
If (quantity = "500") Then
price = "$40.00"
Else
price = "$72.00"
End If
%>
<%
shipping = "$ 3.00"
total = (price + shipping)
%>
I am using a javascript function to draw a graph on my page, which all works fine. One of the parameters that I pass to the javascript function is the maximum value of the x and y axes.
I have encountered a problem, in that if I hardcode the maximum value of the y axis to 1000, and the maximum value that I am plotting is very low, eg 10, the bar is so small it can hardly be seen. It would be better in this case if the maximum y value was something like 15 to ensure that the bar went almost to the top of the grid.
The code which is doing the count is a simple loop which is looping through each of the months in the financial year counting the number of meetins which have occured in each month. Code:
Our store software currently displays the total amount saved (the list price minus our price) for every product using the code below:
'Calculate "YouSave"
If Product_ListPrice > 0 Then
Product_YouSave = Product_ListPrice - Product_LowestPrice
End If
I, however, would like to also diplay the percentage saved next to the amount saved. I tried using the code below but it won't work. Can someone help me out?
'Calculate "YouSavePercent"
If Product_ListPrice > 0 Then
Product_YouSavePercent = ((1 - (Product_LowestPrice / Product_ListPrice) * 100)
End If
I am building a database that users will update.
I have a table named "products".
Every product has a shelf life of 3 years and expires exactely at the end of the 3rd year.
Here is my table:
Productid ---- int
productName ---- varchar
manufacture_date ----- datetime default (getdate)
Expire_date ----- datetime
What I want is this, whenever a product is entered, the defualt date is the date the entry
was made. (I am using the "getdate") to automatically grab this.
BUT I also want the "Expire_date" field automatically calculated and then filled in.
That is, a user enters a product "manufacture_date" as 05/22/2003,
Then I want the expire field to be filled with 05/22/2006.
My preference is to handle this on the DB site and not ASP.
I have an asp page that gives records that shows number of days like so:
<% Days = RSItin("Depart") - RSItin("Arrive")%>
<% response.write days %> days
How do I get the total number of days - ie:
Record 1 2 days
Record 2 4 days
TOTAL 6 days
How to take values from a query and add them together to get totals.The current setup I have:
User selects home they want and clicks on link that passes variable (model home #) that takes them to page 2.
Value in query string is taken and used to bring information about home such as base price amongst other things.
What I would like to do is start with home base price and then call upon options stored in database(each option has their own price)and user can go down a list and select the options(via checkboxes)they want and then at bottom they have a total button that totals base price of home and each option they chose.
I have a list of data in a database(access). How can I get the total rows in the database?
View Replies View Relatedif it's possible to do what follows:
i'm getting from querystring *, /, - or + like ...&calculate=* now i want to use this in the calculation like var1 calculate var2 . how do i get it to understand that it's not a string but an actual calculation?
I have a table named tblsheets (access 2000), There are 4 fields I'm concerned about.
Size, Material Grade, Module and Weight.
I wanted to be able to give the user the ability to calculate the
sum of weight according to a specific material grade and specific size in a specific module.
How would I go about creating an asp script that will allow me to do so?
There has to be an option in which the user can select from a combo box the module, and then select material grade and size, also from a combobox if possible (getting the data from tblsheets).
I have a problem to calculate the day different. I use
datediff(currentdate, quoteDate) > 20
The error message is : Wrong number of arguments or invalid property
assignment: 'datediff'
I use datediff("D", Date, quoteDate) > 20, but still could get the correct one. Maybe I need to change string to the digit. How to do it?
I have a column which i store my totals (price) and i want to sort the records by total.
simple way of ordering as ORDER BY doesn't give correct solution since it sort according to the first number. like this:
1
24465
27184654
i want to sort it like
27184654
24465
1
do you know how?
I have a script that writes out a report to a webpage with data pulled from a mssql database.
I am trying to figure out how to keep a running total for one of the columns of data.
For example, in the users column, if Steve Smith appears 172 times, I want to have a total at the bottom of the report that says:
Steve Smith : 172
Debbie Brown: 100
Brian Katich: 42
etc
Any one have any suggestions on the best to add up the values of a certain fields that
are displayed in a table, like below:
Hours Actual Annual Sick Compassionate Other Reason
8 0 8 0 0 0 leave
8 0 0 8 0 0 flu
--------------------------------------------------------------------------------
16 0 8 8 0 0
need to do a simple form calculation in asp based on values in 2 other field and enter that data into table.
(field)SubTotal + (field)VAT = (Result in field)GrandTotal
I have an web application that allows a user to order items online. The user selects an item from a list on the order items page and enters the quantity. The quantity and unit price of the item is calculated on the order summary page. And than on the process order page, the calculated total from the order summary page is represented as the extended total for that item.
My problem is when that same user in a single user session orders another item, the extended total for the second item is not being added to the extended total of the first item. In other words, I would like to know the code to keep a running total for this user. I keep getting only the extended total for the current item exclusive of the previous item in that user session.
I have been asked to create an ASP page that calculates a variety of tariffs,i currently have a an excel document which allows users to input the data and then when pressing the auto sum the other spreadsheets update.
Is there away of linking an asp page to the excel document to input the user data, and then to display the results on the next page?
I need to display 3 fields with future dates (Fridays only) as table
column headers.
i.e. 16th Feb | 23rd Feb | 2nd March.
As each week passes, i.e. from the Saturday, the dates should move
accross 1, i.e. column 1 will update to 23rd Feb, Column 2 to 2nd
March and Column 3 to 9th March.
23rd Feb | 2nd March. | 9th March
I need this to work in IE & Firefox specifically.
Please can you help me work this out ?
I am trying to calculate (in minutes) the difference between two times. In the database the times are in this format:
Start Time (Game_Time): 1/1/1900 12:00:00 PM
End Time (GameEndTime): 1/1/1900 1:00:00 PM
Here is the code I'm trying:
Code:
GameLength = DateDiff("n",Game_Time,GameEndTime)
The result is: 780
I would expect it to be: 60 minutes
What am I doing wrong?
Is there a simple function in ASP to calculate the dimensions of an image?
View Replies View RelatedI need to be able to subtract the total quantity of a product when someone places an order. I'm trying to get my head around this; what's the strategy for doing something like this?
ASP SQL
So let's say I have a "Thank You" page at the end of the purchase. I have a table with a list of product Ids and a column of quantities left.
If I understand your post, I'm picturing this being a stored procedure that looks at the total quantities from my table that contains all the product quantities. Let's say product 1a has a quantity of 5 and product 2a has a quantity of 6.
A bit fuzzy here but what would a stored procedure look like that is able to update and step through all the items that were purchased?
I am using a select sum(tot_daily) as total hours ...it calculates the time incorretly...
Example:
ID | Tot_hrs | Person
----------------------
1 5.45 A
2 5.45 A
3 5.45 A
The total hours should be 17 hours 15 mins...but the result comes as 16.35.... Is there a way to calculate it as 17.15 in db level in a select statement