I am trying to replicate the Unix Timestamp,specifically the function
mktime() in Vbscript, ASP. I have the following so far:
ThisTime = DateSerial(2004, 9, 27) + TimeSerial(0, 0, 0)
response.write DateDiff("s", "12/31/1969 00:00:00", ThisTime)
This returns the timestamp: 1096329600, and when you decode that it comes
to: 27 Sep 2004 20:00. I want to set the time too, ie. show for example: 27
Sep 2004 16:15
I am trying to store the current date to an ms access database on my server.
I set it up with a dsnless connection.
Here is the statement:
Insert Into employees(timestamp) Values ('" & date() & "')"
the timestamp field is of type date/time in the ms access database.
I get an error saying the insert statement is invalid. Cannot get you the
exact error, my server is down.
But it seems that the syntax is correct.
I have an asp form which is capable of entering a Now() datetime stamp. Can anyone show me how I can then use this information to let change some text once 48 hours has passed? I.E. compare the now() time stamp with time now. As yet I've tried to use Date() but this does not count to exactly 48 hours after the initial time stamp.
View Replies View RelatedIm looking for a simple app with a start and stop button that when clicked
will add a time and date stamp into a database (and add it up on a weekly
basis)i wanna keep track of my time on a particular project for the next few weeks
I'd like to stamp a field (Visitors_FulfilmentDate) with the current Date/Time (it is SQL2000 - smalldatetime datatype).
Using ASP - would like to set Visitors_FulfilmentDate to whatever is the current date/time. Tried using Now() but it doesn't work ("[Microsoft][ODBC SQL Server Driver][SQL Server]'Now' is not a recognized function name. ") :
strSQL = "UPDATE Visitors SET Visitors_Fulfilled = 1, Visitors_FulfilmentDate = Now() WHERE Visitors_ID = "& strFulfilmentCode ....
i have some vars throughout an application that has a time stamp in the format:
8/30/2006
at the end of the app in a few places, its required that the stamp be like this format: YYYY-MM-DD
i'm trying to change this and am having no luck, any suggestions:
varDate = "8/30/2006"
Replace(varDate, inStr(Left(varDate "/", 2)&"/"), Right(varDate, 4)&"-")
I have been working on a form that updates an access database via a SQL statement. I believe I have the SQL part correct as when I do the response.write SQL I get what I believe to be correct. Code:
View Replies View RelatedMy customers webpage sends emails to everyone in the members database using
CDONTS. The customer is on the west coast, the server is on the east coast.
The email has Eastern time on it, 3 hours ahead of Pacific time. Is there
any way to set the sent time that goes out with an email??
How to insert time stamp data into Access Database when insert other data together in ASP/.
View Replies View RelatedI'm a complete beginner when it comes to ASP (CF and PHP are my regulars) and am trying to help a friend out with a very basic form on his site. It's your standard issue "fill this out for more info" HTML form, which will be processed by an ASP script, and then spit out a "thank you" page at the end. The thank you page will not have to display any information about the request.
The entire form is working great, collecting the visitor's name, e-mail address, phone number, and info from some radio buttons. But we'd like to add an automatic time/date stamp so that when the form is submitted and then received by the site's owner at the other end via e-mail, it also shows the date and time it was sent. I imagine we'd use some sort of hidden field? I'm of course open to any ideas.
The format of a sample e-mail could then be:
Date/Time Submitted: 2003/04/26, 11:03 pm
Name: bob joe
E-mail: bob@joe.com
Phone Number: 000-000-0000
I need to do is display results of a command I run in UNIX, for example:
In the ASP page I'd have a textbox in which the user would type an UNIX command like "cat unixFile", after the user hits the "Execute Button" the results would be displayed in another textbox.
Basically my question is, how can I login to an UNIX server from ASP, send UNIX commands and capture the result?
Is there a way to create directories using vb or jscript in IIS to a unix machine? I want to have the aility to upload files through my Win2k Web Server, and have those files stored on my Mac OS X Server under new directories based on date and Upload ID's from the Db.
View Replies View RelatedSimple quesion: Can you run ASP pages on a Unix server?
I am trying to learn "include files" and before I go any further I need to know if it can be used on a Unix server. IF NOT, what would be my options?
I have a guestbook and want to add a date field. I want the date field to be automatically stamped as it were when someone submits a new entry to the guestbook, how can I do that? My database is Access by the way.
View Replies View RelatedI'm working on a proof of concept for ASP. I've already done it using Windows 2k server, IIS, using open source [no initial cost involved]. I'm looking to doing the same using a linux box. Does anyone know if this can be done without buying any additional tools?
View Replies View Relatedi have got someone who is interested in moving a ASP site to my hosting setup but my host is a UNIX platform. Actually i can see no reason for his site to be ASP cause it looks like a flat html site with .asp encoded pages.I just wondered what the experts think of running ASP on UNIX.
View Replies View RelatedI am having lots of trouble creating a login stamp in the database to keep a record of when users sign in. The database is Access.
View Replies View RelatedIn my pages i have to read a text file which is created in Unix format through my asp code. The problem is that the readline command reads the whole file and not line by line as the file is in Unix format. Is there a way to convert it using asp code and then read it or any other solution to this problem?
As the file is created by an application not controlled by myself it is impossible to force the application developer to do this job so i have to do it during runtime. So what are your suggestions?
Please tell me how to execute a unix shell script from ASP?
Is it possible to pass the user id and password for the unix server as call parameters?
Will ASP run on Unix/Linux software like Apache or Red Hat? If so what needs to be done to do this?
View Replies View RelatedI need to access a database on a MS SQL Sever from my unix apache web server.I would preferably want to continue to use ASP rather than go to PHP or Perl - I know that I need to build unixODBC on the web box, but do I need to do anything else other than reference the SQL server in unixODBC?
Has anyone used unixODBC? The console & CLI seem fairly self-explanatory... Do you need extra drivers to connect to a MS SQL box? Can I still use the same server.createobject & ADODB statements in my ASP code? Or do they need to change? Syntax etc?
I'm new to ASP so please forgive my ignorance. Our IT department says that there is no way that what I suggest can be done. I disagree because it should be possible (if not there is a massive hole in the market), but don't have the technical knowledge to back myself.
We have an Windows/IIS web server for our public website. Internally for our intranet we have a Unix box with and Oracle database. What I want to know is: Is it possible to query that database from the windows server using ASP? Are there any clients/COM/APIs etc that this would require? Can anyone direct me to a webpage that has more info?
I currently use ADO (adoConn.Provider = "ADSDSOObject") to access user information in the domain Active Directory. I want to expand my application to be able to access user information in other LDAP compatable user lists (LINUX or UNIX for example). I did some
searching on deja.com (google groups) and microsoft's newsgroups, but couldn't find anything.
Unless you declared those session variables earlier, they have no data in them. Assuming this information is coming from a form, try using request.form("fieldname") instead of the session variables.
If this doesn't address your problem, give more detail about what "isn't working"
i'm trying to use an odbc driver to connect from an asp page to a data source (dbase) on unix sunsolaris. is this poss?
the driver is installed though i cant seem to do it through dreamweaver ultradev - can i do it through the ftp connection?
what would i input as the source on the following to initiate the connection in the asp page?
"Provider= "MSDASQL"; Data Source= server name ?
"Database=test;User ID=sa;Password=blabla"
or how would i do it using the followign as an include 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 ?