Return Server Time
In ASP, how can I quickly return the server time + 2 hours, using VBScript?
With TIME(), I've found functions for date arithmetic, but I can't find anything for
time arithmetic.
ADVERTISEMENT
Server Time Local Time Convert
I'm trying to do a very simple code that converts the server time into a time zone of your choice.
<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>
but obvisouly i'm having trouble with the time zone convert.
Remote_addr Will Return My Web Server Ip Address
I have a web server with a firewall. The problem is that when i use request.servervariables("remote_addr") the ip i get is my server's ip.
Is there any other way to retrieve my visitor's ip?
Looks like the firewall cought the visitor's request and then request's
this page from the web server-and send it back to the visitor.(but still i
am not sure if this is what happens)
If i have to reconfigure my firewall can you give me some info on how to do
this and if this is secure!!
Server Text Return Recordset
I've got a SQL Server database, and am pulling records from it via ASP.Everything works fine, apart from the field which is stored as 'text' data type in SQL Server.If I change this data type to 'varchar' it works fine, but I need more than 8000 characters, so really I need the data type to be 'text'.Can anyone suggest why this might be happening, and how it could be resolved?
View Replies View RelatedASPPop3 (Server Objects) Fails To Return Email Details
Can anyone tell me why this code doesn't work? The original came from
an example in this group, but was modified slightly when the original
failed to return message details.
I am able to connect to the server and see the number of messages on
the server, but message details (sender, subject, body, etc.) are not
returned....
Time() Value For Sql Server
I'm porting an access to sql. In a few tables i have a Time field whic is set to Time() when the data was inserted. It doesn't get modified.
In sql the time now displays as 1/1/1900 23:45:03.
The Default value is set to (convert(datetime,convert(varchar,getdate(),14),14 )).
SQL Server Time Out
I have a time out error from my asp application thought my connection timeout is 6000 sec but when i execute my page it gives me error after 30 sec.Is there any mothod to fix it
View Replies View RelatedServer Time Out
I am updating a value in DB by the following command.
strSQL3 = "Update Click_Count Set Click='1'"
objConn1.Execute(strSQL3)
The data type for click in DB is nvarchar. I've also tried int and numeric but none of them works. The web page processes for a while and then says "time out".
Server Time
I have the date displaying at the top of a page using this code: Code:
<% Response.write(WeekDayName(DatePart("w", Date())) & " " & DatePart("d", Date()) & " " & MonthName(DatePart("m", Date())) & " " & DatePart("yyyy", Date())) %>
Unfortunately there is a big time difference (about 18 hours) between the server and the site and I need to make it display the local time.
Getting Server Time With Asp
i want to get the server time with asp code. i'm getting only the local machine time with
<%response.write time()%>
Get Date And Time On The Server
How can I get date and time on the server. I want to log the date and time on the server when the ASP page is accessed.
View Replies View RelatedServer Time And Date
I'm looking for a script that will call up the date and time on the server. The scripts I've gotten so far seem to use my computers time and date If I change them on my pc they will change allong.how to call up the servers time and date, if possible.
View Replies View RelatedRedirect On Server Time
I want to be able to redirect clients based on the server time. This is to direct clients from different parts of the world to different pages. Have seen a Javascript thta does this based on the clients time but can't find anything that does it using the server time.
View Replies View RelatedServer Time And Date Seperately
I now know how to call up the server time and date, but can this also be done for just the hours, minutes, seconds, weekdays, year, month, days. Each of the individually.
I'm looking for the server numbers not the ones from the users pc.
Date Time Field In ASP/SQL Server
suggest the correct way to store the date & time in SQL Server? I want to store the date and time a record was created. What should the field type be in SQL Server? How can I insert the current date/time into the table using SQL? I used to have date/time field type in access and use the following code
currTime = Now()
SQL="Insert into <table> (id, recDate) Values (" & sId & ", #" & currTime &
"#)"
conn.execute(SQL)
what the field type I should be using in SQL Server to store this date and also what should I replace the line currTime=Now() to?
Server Side Includes & Processing Time
I've been using SSIs for a while now. I'm now using them in a menu system. I'm trying to use multiple SSIs, that is SSIs within SSIs, but I'm just wondering if this will slow the pages down, and put too much strain on the server. I'll try to illustrate what I'm doing.
This is a dropdown menu system. Rolling over Link1 will reveal Link1-a, Link1-b and Link1-c, and likewise with Link2 and Link3: Code:
My Server Hangs For A Long Time After I Run This Page
My server hangs for a really long time after I run the following code...
It is to serve up 3 types of files: a picture, a word document, and an mp3 file from a directory "/uploads" that is not accessible through the URL. The script works perfectly for the picture and doc file, but nothing loads when it is used for the audio files. The files are a few megs large, but after I run it I can't access ANYTHING on the site for quite some time.
What's wrong? Is it something wrong with M@rco's script? Did I impliment it wrong?
I don't mind if it simply takes a long time for it to load the audio file, but it is killing the entire server it seems like. Code:
ASP Wait Some Time And Redirect Without Loading Server
Do you know any way to load a page, wait for 5 seconds IN SERVER PROCESS, and then redirect in the server side, - not using javascript?
What I pretend is to show a page that loads a .GIF file that appears to be loading something, and after 5 seconds redirect to results page, so users apparently think that a backend proccess has occoured.
Is It Possible To Determine The Client's Time Zone On The Server?
I was wondering if anyone knew how to determine how to determine the
client's time zone from within an ASP page?
Can ASP Get A List Of Databases And Tables Of SQL Server At Run Time?
When we want to get data access, we need to specify the datasource name and
table name in ASP page. I want to know if we can get the list of databases
and tables of SQL Server at run time? i.e. The user can choose the database
or table to open, and get the records of the table?
File Creation On Server, Without Wasting Client Time
I have a chunk of code, where based on the user's selections, it goes through a database and selects all of the records from the database and writes them to a text file (the database contains nearly 600,000 records), currently, the file is written and the user would end up having to wait for it to be written, before continuing.
Is there a way that this file could be kind of.... tagged or something, so that the server creates it in the background, instead of while the user waits, so the user can continue doing other things, rather then having to wait for the text file to be created.
The files can be quite large, as they can end up being anywhere from 1 - about 600,000 records with between 4 - 10 fields each. Here is a sample of the code that creates the text file. Code:
Time Calculation :: Difference Between Login And Current Time
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.
ASP To Re-load Page From Time To Time To Reset Varaibles
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:
Comapring Database Time And Computer Date/time
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
Time/Date Format And Changing Time To GMT
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:
Time Convert String To OdbcType.Time
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.
View Replies View RelatedLocal Machine Time To Eastern Time
How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies View RelatedTime Function Returns Wrong Time
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. ?
How To Get Asp Execution Time And Database Connection Time ?
Any some tools or sample codes drop down asp script execute time and
database connection time ?
Compare The NOW Time With A Deadline Time
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.
Time Calculation :: Between Two Dates And Time
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.
Return From ASP.NET To ASP
I updated to aspx last three month,after developing serveral
applications,Idecided to downgraded to asp, following is my reasons:
1.in ASPX,the page format is hard to control,in ASP u can change every html
as u like ,but in aspx, a aspx control decide the page format,and its hard
to change the format.
2.ASPX is said to be faster that asp, but it is based on too-often
communication back to the server,for example,u click a radio a button,there
is new page request, but in reality,such a communication is
bandwidth-consuming and time-consuming. the user only need to submit the
form, and the exchange between IE and Server was minimazed.
the Speed of ASPX is not useful for most sites, for bigger sites, the speed
increase is singnificant,but for small sites with less traffic, the speed of
ASP is quite enough.
3.ASPX is based on Object Orinted Programming, but in most small sites,
Procedure orinted programming is used, we never build objects, and POP is
more efficient.ASPX is for three-tiered structure with a single layer of
business logic component, but in reality, most of us used two-tier
structure,that is Presetation layer and Datalayer, we can layout the page
and change the database in a single page, quite effienct too.
404 Return
I want to return a 404 response from an ASP script (IIS 5).
Response.Status lets me set the response string, but if I don't include any
HTML text myself, the result is an empty page.
Is there a way to 'redirect' it to the server's default 404 response, as if
the URI really doesn't exist, but without really redirecting it so the URL
isn't replaced in the browser's address bar?