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
building variable width/DB tables etc using getrows instead of movenext.
Performance is a major concern as this app requires SSL.
My question is, when does it become more about the challenge of building
faster apps vs. getting the job done??? If my calculations are correct, I
just added an extra 10,000+ possible hits within a 12 hour day or so.. an
extra 10,000 hits???!!! What percentage of applications do you think will
ever see this kind of traffic?
Is this insane? If this app ever gets maxed out, will my end users ever
realistically notice a difference?
i'm importing a date ( 13/2/2005 1:20:22 PM) from SQL server
to informix.
The problem now is informix doesnt accept alphabet in datetime format,
so i plan to convert it before the date insert into informix db.
But the problem is i dont know any function that can convert the date time
from 12 hours format to 24 hours format.
I want to create a weekly report on diciplinary actions taken. I dont
have an idea of how i'm goint to go about doing it. I have done the yearly
reports and the monthly reports without much hasle. I just dont know how
to create a weekly report.
For a System I'm Creating I wish to send a weekly reminder to everyone in the database. Could you help me go about this as I dont even know where to start?
View Replies View RelatedI need to create a weekly calendar in which each day has 13 time slots. I would like to create a reservation system where by a member can log in, look at the calendar, be able to see which are the free slots and then reserve a particular time slot. I don't know how I can do this?
View Replies View RelatedI need to pull five records randomly from a database, and display them on a web page. These need to change weekly.
Is there a way to do this in ASP?
I need to create dynamicly an ouput table that users can edit their hours and cost center. Each day have maximum 2 entries for week if they have one entry per week, then the design table will have an empty text box for users to enter in....
Please see the attached outline to show the weekly timesheet in edit mode. Below is the query I am using it. Code:
I need to convert number into hours..Example: 12.60 should be 13 hrs,etc.
My variables
Total = oRs0("Tot") + oRs1("Tot1")
I need to get average of the hours after (start_date - end_date). *start_date and end_date is in format 'mm/dd/yyyy hh:mi:ss am' . Is there any function in oracle that i can use so that i can directly get the average of the hours in SQL statement?
View Replies View RelatedHow can I subtract hours from 'Now()'?
I can subtract a day, but that's by only having ONE integer...what do I do for hours? (i need this because our server uses EST and clients need their TimeZone)
how you convert an integer such as 5 into an hour string so the system identifies it as an hour instead of just the number 5 and then once you do that ("if you need to do that at all") add 5 hours to the current time...
Also is there a way way to add lets say 50 hours to our current time and date so when it is calculated it shows 2 days and 2 hours away from now... If you cant do that it would be nice to know how to change 7.85 into just 7... or 8.94 into just 8... no rounding up or down just the first number before the decimal.
How would I write in SQL or ASP the following?:
Count number of Database Records between NOW and 24 HOURS EARLIER? I know
how to retrieve recordsets etc - its just the date thing I cant grasp. I am
stuck getting the 24 hours earlier data capture.
I have a request from the boss to make a report that will require me to display how many hours something has been in a particular state. (As in status). Hard to explain. Anyway, I need to go to the table in the db, find all rows for a particular trouble ticket, find when they were put into one of our 7 statuses, when they were put into another status (this info is already in those rows), then determine how many hours they spent there in
each status.
So a ticket report will say that ticket 1000 spent 4 hours in customer research, 5 hrs in our company coding. 3 in our company testing, 4 in customer testing, etc.
The thing is, It has to assume an 8-5 workday, and leave out any hours which don't fall in between 8 am to 5 pm, and also rule out any weekends.
I have two Win2K machines. Both "appear" to have been set up identically.
They both reckon that they're using UK date format.
However, if I create the following ASP code:
<%
Response.Write Now
%>
One returns
16/01/2004 17:12:19
Which is what I want, whilst the other returns:
1/16/2004 5:15:21 PM
Here, the day and month have been transposed and the time appears in the 12 hour clock format.
I just need to know the DateDiff function for what I need to do...
I will store the date of the database record in a variable called 'sDate' what now? (Also, the format is xx/xx/xx 2:4:56 PM/AM)
I'm trying to write a script to countdown the number of hours and minutes until tomorrow. So far, this is what I have:
Code:
<%
response.write(dateDiff("h",now(),date+1)) & " hours and " & dateDiff("m",Time(),date+1) & " Minutes "
%>
The code above correctly displays the hours until tomorrow. but it's not displaying the minutes correctly. It's displaying the total minutes until tomorrow. If there at 4 hours left until tomorrow it's saying "4 Hours and 240 minutes."
I need it to display "4 hours and 0 minutes."
Been playing with the function DateDiff, and with it it's easy to calculate the difference in years/months/days between two dates. However, if i wanted to calculate the difference in Years, Months, Days, Hours, Seconds (a la Ebay bids) how can I do this? Is it easy or complicated?
View Replies View RelatedIve got some code on my site that shows how current the database is. Basically it looks at fixed text file that I am basing the database on, checks to see iwhen it was created, then displays the time.
My webserver must be on the East Coast and I am on the West Coast, so the time the stamped file time is 3 hours ahead. 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 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
I have a list of data in a database(access). How can I get the total rows in the database?
View Replies View RelatedI 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
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 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 have a small issue with displaying total
heres what i need to do
if its 11 * 7 =77
i need to print 77.00
if its 7.95 * 3 =23.85 then its right
so when its whole number i want to put a .00
is this possible
here is my code for it
Code:
i dont know if this should be a mysql question or a asp question...
i have a database that stores all the orders and each orders total. How can i make it so that i can add all the order totals together, to get a final total
Im using mysql.
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 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