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 )).
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.
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 RelatedI 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".
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.
i want to get the server time with asp code. i'm getting only the local machine time with
<%response.write time()%>
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 RelatedI'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 RelatedI 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 RelatedIn 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.
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.
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?
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 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:
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.
I was wondering if anyone knew how to determine how to determine the
client's time zone from within an ASP page?
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?
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:
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.
View Replies View RelatedHow will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies View RelatedWhen 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. ?
Any some tools or sample codes drop down asp script execute time and
database connection 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.
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 have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _
"Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
View Replies View RelatedI'm getting the error,
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/pdf_project/form1.asp, line 19
Invalid class string
I'm trying to submit the data in my pdf form to the web server.I've written the .asp code for it but it has been giving me this error.
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
What do I need to do to enable CDONTS om my macine to make it working
I'm testing the code:
Dim objCDO
Set objCDO = Server.CreateObject("CDONTS.NewMail")
objCDO.To = "xyz@xxxxx.com"
objCDO.From = "zyx@zzzzz.com"
objCDO.Subject = "TESST CDONTS MAIL"
objCDO.Body = "SOME TEXT TO SEND OVER"
objCDO.Send
Set objCDO = Nothing
It gives me an error after Set objCDO =
Server.CreateObject("CDONTS.NewMail")
Server object, ASP 0177 (0x800401F3)
Invalid class string