Comparing Current Time To Times Set In Array
basically what i'm trying to do is find the closest time (which are linked) to the current time (which is in red) and then forward a customer to the url.
the linked times are populated from an array, so i think one method would be to sort the array in time order then forward the customer to the first link it finds in the array.
I have no idea how to do this by the way as there doesn't appear to be a sort function in ASP does anyone have any ideas on any ways I could achieve this?
View Replies
ADVERTISEMENT
I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
View Replies
View Related
Here's my goal: 1) to set up a 7 column table containing a list of 147 numbers from a recordset (StNumberRS) and 2) to compare those numbers to a separate recordset containing a partial list of those numbers (completedStores).
If one of the numbers in the completedStores list matches a number on the StNumberRS list show the 'icon_yes.gif' image, otherwise show the 'icon_no.gif'.
I can loop through the StNumberRS and set up the 7 column table, but I'm stuck trying to loop through the completedStores list while inside the StNumberRS loop. Could someone look through my code and see where I've gone wrong? Code:
View Replies
View Related
Is there an easy way to compare the data in one array against another and output all values that are not contained in both arrays. I basically have two lot lists that should be matched (in value, not necessarily in order) but occasionaly one or two lots will be missing in one or the other array.
I need to be able to know when the two arrays are not matched and which array of the two is missing the lot. This just seems like a pretty common thing to do, so I'm sure there is already a script out there to do it. I'm new to working with arrays and don't want to reinvent the wheel for this.
View Replies
View Related
I have the following code to check if a field number matches a specific value. here is the code:
View Replies
View Related
I need to compare the actual time on my server to the value I'm receiving on a database.
For example, let's say the actual time is 1:45 PM and the value in the database is 11:52 AM. I need to compare that if the actual time is after the one on the database, it returns a true value, if not returns a false value.
I tried this ASP code, bit it didn't worked, any ideas? Code:
View Replies
View Related
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.
View Replies
View Related
Ive 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:
View Replies
View Related
I need to create a list (diary style) of times in a day. I can do this with normal "metricated" break-up of the hours, but need to display the actual time.
I have a "Starting time" and an ending time as variables. I also have a "Timespan" for the increment. For example Start time=8:00 AM End Time 6:00 PM and increment in 30 minute intervals
I need to convert anything after the decimal point into Minutes. If I have "11.5" I want to show it as "11.30". I can divide the decimal into 60 to give me the Minute equivalent of the decimal, but need to do this without affecting the "Hour" The start time, end time and increments will be a variable from a database.
View Replies
View Related
I have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.
So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.
View Replies
View Related
well, the following script that i wrote using the aspSmartMail component, keeps timing out on me. i tried setting the timeout higher through both IIS and in the script itself, but all that does that it take longer for it to timeout.
i have written a few email programms using this component, so i don't think it is the component. i have just never tried sending emails with it automatically that each have certain unique fields in it. well anyways, here is the code:
View Replies
View Related
I need to show how long a given file size will download.
View Replies
View Related
I've written a page that uses a emailer component and it keeps timing out.
It takes 2-3 seconds to send each mail, gets part way through the list of
recipients and dies.I have tried changing the Script Timeout setting in IIS to some huge number(2147483647?).I hve tried setting Server.ScriptTimeout = 0 and Server.ScriptTimeout =2147483647.
None of these make any difference. What can I do now?
View Replies
View Related
I want to compare two times 1 time is in a variable and the other time is todays time.
i want to get the time in h.m.s
e.g.
12.30.00
13.00.00
this would then output
00.30.00
which i then can then split and if their are 0 i can have get 30 min out of it.
View Replies
View Related
I need to subtract two times
Example : 1:45 AM - 2:55 PM or 5:45 PM -1:00 AM
View Replies
View Related
I have a asp page which pulls alot of data back from a SQL database, is thier any way to show the page while its loading.
I did some diging and found this:
<%
response.buffer=true
response.flush
%>
View Replies
View Related
I have a class that access an MS SQL database.I have another class also accesses an MS SQL database and this second class uses objects from the first class.I have a third class using the DB and objects of the second class.
Each of these classes contain all the code needed to access the database and this means much duplicated code. What I'd like to know is if there is a way to avoid the duplicated code?
I know I could write the code once,then do an #include to include the code into the class,but that still means multiple occurances of the code.
View Replies
View Related
There is 600 lines of code. This page gets available rooms from RoomInfo and compares the rooms againest rooms in use from EventRoom by RoomID. RoomInfo RoomID field is text. It can contain multiple rooms (i.e. 5,6,7) based on room setup type. I had to do it this way so that users could book multiple rooms based on configuration and how many people.
Line 412 is where the time out occurs. Also if I use split on rs2(RoomID) {line 415} then I can't start at 0, I have to start on 1. Which means 1 room is not being checked. I tried to annotate the code as best as possible. The page is zipped so you can download and view it. It will bomb if you try to run it on the server it is being hosted on.
View Replies
View Related
I've done this before but cannot remember how. I have a field (FIELDNAME) in a sql2k environment. I just need to know how many times an "_" appears in that field. I cannot figure it out right now.
View Replies
View Related
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?
View Replies
View Related
I need to be able to display an image if the time is between two times. Here's the code I have, but it doesn't work.
dim strLink1, strLink2, strLink3
dim tcurrent, tstart1, tend1, tstart2, tend2
tcurrent = now()
tstart1 = "3/1/2006 7:00:00 PM"
tend1 = "3/1/2006 8:00:00 PM"
If Now() >= tstart1 OR Now() <= tend1 Then
'if tcurrent > tstart1 or tcurrent < tend1 then
strLink1 = "/images/2.jpg"
else
strLink1 = "/images/1.jpg"
end if
When I look at the page, the image never changes. It just always displays 2.jpg and not 1.jpg. I need help ASAP!
View Replies
View Related
How would I do it for DATE instead of Day of the week?
View Replies
View Related
I am trying to simply print to screen all the data in a colum from a .mdb file. Later I will do more advanced things but for now this would be good.
What I have WORKS, but takes a LONG time to retrieve the first record, if I tell it to retrieve more than one row it will time out. I was hoping to connect to the file directly and not have to create an ODBC connection. The code seems simple enough and the server is no dud (p4 2.4ghz) so do I need to setup a DSN and connect to it that way? Code:
View Replies
View Related
im making the web site for a small internet radio station and would like to add the feature to show which DJs are currently on air. I would like to do this by swaping an image at certain times or even dates.
For instance
dim image
if time = 05:15:00 then image = bob else
if time = 23:30:00 then image = dave
end if
Something along those lines but I dont know the exact code required to do this.
Would be really greatful for any help, I think it would be a nice feature for our listeners.
View Replies
View Related
I'm currently developing on IIS 5, ASP 3 and MySQL 4.1 using the latest ODBC driver from MySQL.
Any time field I have return from the database is returned as the current date. I've tried every table which has a date, created tables which soley keep records on the date.
I've submitted the date from MySQL Query browser using CURRENT_TIME and from an ASP page. Both submit fine.
I've returned the record using a Recordset to move through each and filled an array using GetRows().
View Replies
View Related
My interest is to guarantee that my users never need to logon again. Can’t put a session.Timeout to high because of memory on server. So how can I get the session refreshed before session times out?
View Replies
View Related
I'm sure you've seen them all over the place. Before downloading a file, it tells you the size of the file and the approximate download timedepending on your connection.
I have found a lot of javascript calculators out there where you input the size of the file and it calculates the time you need. These provide the end result I need, but 1) I hate javascript with a passion and 2) I want the download times to be displayed automatically when you select a file to download.
As a last resort, I can spend some time re-writing it for ASP, pulling the file info directly from the file in question (which would be a variable) rather than requiring an input of the size; but I'm wondering if anyone has an ASP version already done. Save me some time and hassle that way.
View Replies
View Related
I am creating a news page for a fun website just to learn, it has a simple html form that lets me post new news items to a MSSQL database.
The thing I am trying to do now is have the loop only run about 5 times, so that it displays only the last 5 news items from the database, I will then create an archive page which will display them all.
I have a book that I read and I found the for..next statement and I t would work nicely from what I am reading,
View Replies
View Related
I ported a script I made over to SQL Server 2k from Access and went from queries that took a tenth of a second to up to 30 seconds! Typically they are between 5-10 seconds.
All I can think of is I screwed something up in the connection procedure, and here that is:
Code:
set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout=30
objConn.Open "Driver={SQL Server};" & _
"Server=ipaddress;" & _
"Address=ipaddress,1433;" & _
"Network=DBMSSOCN;" & _
"Database=databasename;" & _
"Uid=userid;" & _
"Pwd=userpass"
set recordset=server.createobject("adodb.recordset")
View Replies
View Related
I'm almost finished creating a simple events calendar that will allow users to book rooms and see at a glance, which rooms are booked, and at what times. Unfortunately I've hit a brick wall with the final stages of development.
I've created a screen shot of what I would like to display on the screen (see below). I can't for the life of me figure out how I'm going draw each cell and populate it with the database information (should it require populating).
View Replies
View Related
I have a project where I want an email to be sent at a certain time, say 10 PM every night if there are new hits to my site. The email will be only going to my email address. does any one know of a way to do this?
View Replies
View Related
I have an html page with standard contact us type form. This when posted goes to an asp page which stores the data and then sends an email to me. It then redirects back to the original email form with a message thanking the user for the contact.
The problem is I am getting multiple spoof emails which are being generated form the asp page. Some one is accessing and then just refershing the page so it generates numerous emails.
Is there a way of either hiding the asp page in the original HTML form or checking that the page has been called by the html form rather than just refreshed.
View Replies
View Related
The object I have is a barcode:
<%
RMABarCode = Session("rmaID")
IF Len(RMABarCode) Then
response.write "<img src='barcode.asp?code=" & RMABarCode &
"&height=25&width=1&mode=code39'>"
End If
%>
But I need to be able to display that barcode multiple times.
Say the user needs 4 displayed, he/she will enter the number and it
shows that many.
View Replies
View Related
