I am currently working on a realtime chat project using ASP. In my system a User lets say 'X' has to request for a chat session with say a user 'Y' and Admin checks it and Approves if a valid response.
Now my problem is if user X is from Time Zone 'A' and if user Y is from another Time Zone, My system is gonna have a bad time. So if any one previously worked in such projects please advice me how to handle this situation. Please advise how to time Zone Calculations also.
I need to know how can I inster dates and hours according to the time zone where the user is. For example, I'm on Argentina but the server is at the US. So I'd like to know how to save the time & hour, just like the now function, but in Argentina, although the server is in the US.
I have an ASP app that works as an online time clock. The user logs in and clocks in and out and the app records the time punches in an access 2000 database. My problem is this. I just setup a user in the central time zone and they have reported that when they use the online time clock, it saves the time as eastern time instead of central. How can I make the software know which time zone the user is in?
I was wondering if anyone knows how to get the current time of the user's timezone in an asp page. Currently I am trying to do some frequency capping in an advertising system i am working on and i want a cookie to expire at the end of the day, in Pacific Standard time.
What is happening now is the cookie is expiring whenever the day ends on the users computer, but i want it to expire when the day ends in our time zone. Any ideas on hwo to do this?? Is there a function i can call to get the users current time based on their timezone?
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.
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time. for example, if computer date/time is two months or 2 weeks before the database date/time do something
Currently working on a ASP for a friend, which requires the date and time on it. It pulls in entries from an Access Database with dates and times in the format of:
"Fri Oct 17 18:02:46 2003" However my date and time on the ASP page is displayed as: "Friday, October 17, 2003 18:02:46" using the script: "<%Session.LCID = 1033%> <%=FormatDateTime(Date(), vbLongDate)%> <%Session.LCID = 2057%> <%=time()%>"
Anyone know how to change this script, fully or partly to produce the date and time on the format that's in the access database i.e. "Fri Oct 17 18:02:46 2003" Code:
I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.
When the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.
I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?
I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.
CODE:
nowtime=now() deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM" response.write "NOW: " & nowtime & "<BR>" response.write "Deadline: " & deadlinetime & "<BR>" if nowtime<deadlinetime then response.write "can send out today" end if if nowtime>deadlinetime then response.write "must send out tomorrow" end if
RESULTS: NOW: 1/18/2007 8:51:43 AM Deadline: 1/18/2007 8:30:00 AM can send out today
As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.
i want to calculate the total time between to dates and time.
Example: Total time elapsed from date 1 time 1 to date 2 time 2.
27/09/2004 11:00 - 28/09/2004 10:30
The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.
I am writing an XML file with lots of Data and it takes time but before the operation can be finished I get this error
Quote:
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
Would anyone know if there is an easy and clean way of presenting maybe a time control field in html in an .asp page that allows a user to specify a certain time of the day? Currently using an <input name="SpecifyTime" type="Text"field but was wondering if there was a better way of doing this as to where users won't mistype in entering non time related characters?
Would it be a stupid idea to use the Log Util component to retrieve the UTC date/time? It appears that the DateTime property could be used for this, but I'm not really sure how it searches through the log file.
I am using ADO to connect to SQL 7.0. At times the connection timeout expires. Is there any way to inrease the default time out? I think currently its 60 secs. Here is the code that I use to establish ADO connection.
i have two rows in data base with similar data except the time coloumn , the time coloumn is the only one with differnt times ex: 08:00am in one row and 9:00am , form the sql query when i taken the results where name='"&name&"' themn i am getting only one name . how can i compare the time with system time and get them login accordingly.
I'm developing in ASP/VBScript using DreamweaberMX, w/ an Access 2000 DB as the data source. The source of the data is coming from a third party, which I get as a CSV and import into the database, updating it weekly.
Since I have no control over how the data is collected, I'm not sure how to fix this problem, but here it is.
This is a database of movies and among the many fields I import is one for the movie's length, expressed in HH:MM:SS. This comes into the Access DB as a Date/Time format, which means all the dates, displayed raw in the DB, look like "12:09:52 AM". Through data formatting, however, displaying it to the client as HH:MM:SS is no problem. (Display "12:36:00 AM" as military time (00:36:00) tells me the movie is 0 hrs, 36 minutes, 0 seconds long. Follow?)
But in an update form, which we'll use to correct errors (and there always seem to be errors in the running times of movies), I can't figure out how to display it in the HH:MM:SS format in an INPUT field and have it submit without throwing a data type mismatch error. It seems to want to display as "12:36:00 AM"
Converting the field to a text type is out of the question at this point, so I know I need to do some type of string manipulation prior to update. However, I'm lost ...
I have a message that scrolls across the top of the page, it can work, refresh, work, refresh, fail, refresh, work, etc etc I dont have any control of the permissions, web server etc just my code and database file.
I can see any reason why it will work 4 out of 5 times. Any thoughts ? Code:
Can someone offer some clarity on the issue of session time out. If I understand correctly the default is set to 20 minutes and is reset to 0 each time a call is made to the database - which could simply be a different page request (?).
I seem to be frustrating a number of users because they tend to linger on one page for a long time - in some instances reading info and in others writing, and re-writing, and scrutinizing their submissions on a couple of forms. Because I check (via an include file) for an active userID on every page....
they can complete their form and submit, but are then requested to log back in to the system...and the info they added IS in the database...but NOT associated with them due to the session time out. Of course, this creates some nasty data issues.
I'm looking for a better way to approch this issue. On the forms pages I've changed the session time out to 30...but wonder if that controls more than the page it is on? Dont know. And it does nothing to solve the issue of data entered and not being associated with a user.
Is there a way to offer a 'warning' to the user that their session is about to time out? Or should I be looking to refresh something within the page at certain intervals - my concern there is - can i refresh part of the page an not others - if a user is filling in a form - would a refresh to that page automatically clear the form?