Recurring Time Based Function
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?
View Replies
ADVERTISEMENT
am trying to redirect users based on time using following.It sends no matter what to first url.Code:
if now() > 23 or now() < 08.00 then
response.redirect url1
else
response.redirect url2
Its something simple but I just cant get to grips with it.
View Replies
View Related
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. ?
View Replies
View Related
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:
View Replies
View Related
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 .
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
How do i make time function return 24H time instead PM/AM time ?
View Replies
View Related
If I want a message to show on the 3rd Friday evening and Saturday early morning of each month, is there a better way than the code that I use...
aztime = dateadd("h",-2,now())
If (day(aztime) => 14 and day(aztime) =< 21) and ((varDayOfTheWeek = 6 and dhour => 15) or (varDayOfTheWeek = 7 and dhour =< 2)) then
my message here
end if
The only month it would fail in 2008 would be June, so I was hoping there is code that would just deal with the 3rd Friday or Saturday of the month.
View Replies
View Related
Is there a way to get the Military Time from a function? This
23:07:27
instead of this
11:07:27 PM
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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
View Replies
View Related
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:
View Replies
View Related
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 Related
How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies
View Related
Any some tools or sample codes drop down asp script execute time and
database connection time ?
View Replies
View Related
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.
View Replies
View Related
What's the difference between private and public functions in ASP? When should I use either?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related