1. I need to convert the local-time of the server on which I run my website
to UTC and I don't want to rely on the server local time and timezone (i.e.
I don't want to hardcode the timezone information), is there a generic way
to do this?
2. Is there a general for converting time between timezones in ASP?
How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies View RelatedI'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.
Do we have any function in ASP that will convert US time(which is captured in the database) to IST
View Replies View RelatedI need to convert seconds into time since for a message board application.
"minutes ago, hours ago and days ago" etc.
I have capture the time of the original post and compared it to the time now getting seconds but having a little trouble working out the seconds into time. Have used calculations (/60 minute), (/3600 hour), and (/86400 hour) but the time remaining is bugging me.
i use this code to convert the date format throw asp. so it could work well with me sql server Db Code:
strSQL="select * from Visit where convert(datetime,visitdate,103) = convert(datetime,'" & date() &"',103) ORDER BY visittime"
rs.Open strSql
but u try to convert the tme form also in the same way but it doesnt work , so anybody have any idea how could this be done? 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 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 ?
Is there anyway I can get the information about a file on the local machine of a user that is reading pages from my web site? Scripting.FileSystemObject does not have permission to do this, and I want to check the size of a file before I try to get it uploaded.
View Replies View RelatedAn application runs on server, and is used for Hour-registration. Now I want to run the application local, I use SQL Server 2005, and managed to fix connection changes.
But now, I get this error everytime I run the application:
Microsoft VBScript runtime error
Error Code :0x800A01CA
Error source :
Error Description :Variable uses an Automation type not supported in VBScript
Any solution please?
The webserver I'm using (which I can't make any changes to) has a
Dutch-localsettings. When doing simple calculations the decimal-symbol in
ASP is a , (komma). Is it possible to force IIS to use a . as decimal symbol
by code? (IIS5)
I would like to evaluate some shopping cart software to use on my next project. I am new to asp and as yet my hosting does not support it. Before I go ahead and upgrade my hosting I wanted to see how the various packages work.
I am running XP Pro SP2 and have installed IIS. The folders seem to be where they should be and I have access to the settings through the Administrative Tools.
When I put a htm file in the wwwroot folder it loads fine if I type http://localhost but the asp files are either downloaded or opened in dreamweaver.
Do I need to do something special to enable asp files to open on my local machine??
I'm not a networking/IT guy, but I was put in charge of figuring out how to use ASP to tap into an Oracle db for my office. I am using a windows 2000 laptop, and I want to be able to run ASP code on my local desktop (without being plugged into a network).
I need a lot of help here. I know I have to turn my computer into a webserver, but I'm not certain what I need to do with the IIS. What do I need to do in general to make my computer a webserver? In addition, I will be using a local Oracle database. So I wasn't sure what I would need to do to make that db available for querying with ASP. What is the best way to make that connection?
Anyone who can point me to useful documentation.
I am running this code on my local IIS and everything works fine. The code detects the file I select using the INPUT TYPE=FILE. The problem is that when I move this code up to my host’s web server, it never works as in it never finds the file. It is the exact same code so why is it working on my local IIS but not on the web server? It is ASP code.
Code:
set fso = createobject("Scripting.FileSystemObject")
If fso.FileExists (strValue) then
'File exists continue with code
Else
Response.Redirect("aspError.asp")
End if
I need to setup my home computer to view ASP files like I veiw PHP files through Apache2Triad or some other similar installer package.
I'm using Windows XP Home,is this possible?
I am trying to set up an internet page on our intranet that contains logoff/shutdown and restart buttons.This needs to work in a remote desktop situation which rules out various options.
Next stage is to call this .exe from a webpage...which I'm struggling with. My test code (to test a reboot) is below but doesn't seem to work. Can anyone help remembering this needs .exe needs to run on the local machine and not the server.
I have a computer running Windows XP home edition and i would like to have a local web server for testing my classic asp pages.
View Replies View RelatedHow do I execute a users program from a web page? When a user goes to a webpage - I want a link on that page that will execute a program on the users local hard drive - like say...notepad.exe . Everything I have tried will only execute it on the server.
View Replies View Relatedhave an SQL DB which clients access via asp pages through the internet, in the case of a power outage I need to write that data automatically in the background to a txt file on their local machine, I would imagine it would involve a script of some kind.
View Replies View Relatedis anybody know how to capture lan id(localhost id ) address in lan. u can check the same under dos using command ipconfig. but i am not geting the same id using bewlo code
<% Response.Write Request.ServerVariables("REMOTE_ADDR") %>
how to get TimeZoneId for Local TimeZone.
View Replies View Relatedi'd like to know if it is possible with asp to launch a local application (exe file like word or any else).
View Replies View RelatedI am wondering if their is a strategy or tool for syncing a local
database with a web-based database? Specifically I have an application
where orders are entered via a web form and the data emailed to my
client who processes the orders. I extract the order information and
update a local "order tracking" database. There are several order
processing steps.
I want to update a web database to reflect the status
of the order as it flows through the local tracking application. I will
send an email to the "orderer" at the major steps, but my client wants
to have a web-based report shows the status of all orders for a company
that has pending orders. In other words a company will enter multiple
orders and will be able to track the status of the orders by signing on
to the web site.
This status report gets its data from the
web-database.....which I must update from the local tracking database.
A pretty long winded explation which I hope mades sense. Has anyone
found a solution to this problem? Any reference or tools you can
suggest?
I'd like to create a series of variables created dynamically, example such
as this...
For i = 1 to 5
TheVariable & i = "blah"
Next
This would during the first loop create a variable called 'TheVariable1'
with a value of 'blah'. Is this possible as so far I'm getting syntax
errors?
While I know within visual studio express 2005 it's easy enough to test and connect to SQL Express 2005 database's I ask can standard ASP connect to this also? I will be attempting from localhost IIS as obviously visual stuido does not host ASP sites.
View Replies View RelatedAm I now setup to view .asp on my local machine, or do I have to "upload" the pages to IIS? If the latter, how do I do this?
View Replies View RelatedHow do I allow users to browse their local machine and upload a file to the server? I'm looking for the pop up window that allows the user to search for a file in their local machine. Also, once the file is in the server and the user needs to delete it, how do I do that?
View Replies View RelatedI have been teaching myself ASP for several months now and seem to have a pretty good handle on it. All along, I have been uploading changed files directly to the website and refreshing to test.
However, today I will be at a location with no internet access and would still like to be able to work and test my programming. How do I go about testing ASP pages on my local computer without an internet connection?
For now I am not worried about testing any databases or anything, just layout and design.
If it is useful, I am running Windows XP Home edition and I use Dreamweaver to write the ASP.