i have some lines of codes.. probably i'll make it a function..
i want the function to be executed every 24 hours or some other stated time.how do i do that?
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. ?
What I would like is during the time the event actually occurs I want the field in the table to change colour and return to it's original colour when the time to expires.
I've written some ASP to do this, and it half works, but instead of colouring one event, it colours everything (because I use a repeat region i think). Code:
How does one return records in a recordset based on a time/date field. If todays date is 8/25/04, how could i return all those records from 8/25/04. Mind you, i have long date format ex. "8/25/2004 4:46:45 pm"
I dont want to user a form for this i simply just want these time- sensative records to be returned in the recordset .
I am attempting to design a maintenance program which includes a series of recurring tasks. I would like for the user to be able to assign their tasks to recur similar to the way Outlook does.
I have been searching on the web for quite a while and have been unsuccessful with getting ideas on how to start this. I would like to use ASP VB or JavaScript.
Does anyone have any suggestions or links that could point me in the right direction?
I'm trying to work out a recurring date by asking the user to select the new date by selecting an option of: First, Second, Third, Fourth or Last week of the month. What I already know is the specific date which I need to add the new dates to.
My dilema is that I don't know how to work out First, Second, Third..etc. I'm thinking that when I work out the first part I will just need to use the DateAdd function, but in this case I'm not sure about that either.
I initially tried building a coded system where numbers 1 through 10 referenced a certain type of recurring appointment, and would then call a specific function for each, but as more appointments were added things began to slow down quite a bit.
I've taken a different approach since, and decided to create a single record for each recurring appointment, but this has problems as well due to the fact that I have to search each time slot going all the way out to the specified end date/time.
What is the most efficient way to create recurring appointments using ASP and SQL Server?
I want to make a function that connects to my mysql database and ranks the users who have achieved the most points during that day. How would I structure something like this?
I guess a web server can be configured in many different ways around the Globe, I know the Date() Function can show several different shapes. But will the Time() Function in vbs always return 6 numeric characters, like 15:12:04.
(Hours:Minutes:Seconds.) If this is so then I could rely on this in my code right? Or should I expect Seconds:Minutes:Hours, or perhaps 4:3:12. I know I can use the FormatDateTime Function if the answer to my question is negative.
Can anyone think of a short piece of code which does he following: ------------------------------------- if Current Time is LESS THAN 19:30 then Write: Open For Business
Else
Write: Sorry - Closed ------------------------------------- and ------------------------------------- if Current Time is Between 12:00 and 14:00 then Write: Away to Lunch Else Write: Open For Business -------------------------------------
It's actually for a call centre app, just the above scenario is much easier to explain.
What i'm looking for is an asp function which automatically runs every day at e.g. 12:00 AM and then updates a database. So no user or external event is involved to trigger the function. It operates stand alone. Hope there are some code examples available.
I have an asp page in which I use the �time() function but that just gives the time at the moment the page is loaded. I need to reload/refresh the page once every second so the seconds increase by one continuously.
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.
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.
it appears that my ISP is blocking port 1433 which means i can no longer connect to my sql db on the web. had been using an access project or another program called WinSQL. so i'm forced to go with a web-based solution and i don't really have time to build one from scratch. the host this site is on still hasn't installed the .net framework so i have to go with a classic asp solution.
I want to do on my site and if anyone can tell me it can/can't be done that would be great. If it can be done, is it difficult or is there already code available and I can just *plugin* the info that pertains to my site? Code:
I need to open recordset and select one record based on some value? I need some script which will select random record based on the some percent or some number from 1-10, for example.
Its banner rotation system i have made, and it select randomly record, but I need some percent or some number(1-10) for selecting recordset based on that number.
banner1 10 banner2 70 banner3 40
...so every will be selected based on value from DB.
i found a flash based mp3 player for my myspace that pulls the playlist from an xml file. my question is this... i want to be able to change the playlist (add, delete songs, change play order, etc...) without having to change the xml. here's my idea and i'm not sure how exactly to do all of it, but let me know if there is an easier way.if i create a db that stores the information i need (filename, song title, and track number) i can create an html form that will allow me to change the track number (i know how to delete and add songs). my question is how to i update the xml file at the same time it updates the db. in other words, how to i send the data in the db to an xml file.
How ca I write a asp page that will handle web based Install? Is it possible or I need to go for some 3rd party Software for this, If Yes what is the Best to use with ASP? My requirement is: I have one Software that I wanted to install in Customer PC directly from Webpage instead of allowing the user to download the Software and Install.