Automated Date Check
I have a booking system that allows a user to book a room for a set time period of a day, what i want to do is on the day that the room is booked for is send an email to the person that booked it.
I can already send an email thats not an issue i have all the other information other than the ability for the site to on its own with no user input send an email so when it comes to the day they have the room booked for at 8.30 am i want the site to check all bookings and email the person responsible, make sense?
View Replies
ADVERTISEMENT
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
View Replies
View Related
We have two tables EmpProfile and holidaysrequest tables.
EmpProfile has fields
EmpNo
Firstname
Lastname etc
HolidayRequests has fields
EmpNo
FromDate
ToDate
holiday requests table stores the dates employees have booked as holidays.
I want to write a query which will be used by ASP page to display everyone
who have not booked 29th - 31st Dec as days off.
View Replies
View Related
Is this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
View Replies
View Related
I want to develop a little application for my intranet. There is a person who is on-call, and this person changes once a week. Rather than having the person remember to change him/herself in the system so that they are reflected as the new "person who is on-call" for their week.
Instead, I would like to automate the process by developing an application that would read a series of ID's (that reflect the people who are in the database) who will sequentially be "on-call".
My question is, how can I (through ASP/VBscript on an IIS 5.0/Win2K Platform) automatically run a set of ASP without invoking the page (so that it can automatically change the person who is "on call" every weekend.)?
View Replies
View Related
I need to send an automated email each day (Member expiration notices). The data sits in an SQL Server but SQL Mail is not available.
Building an .asp page that makes this happen isn't a problem, but that page would have to be loaded each day for the process to run....
View Replies
View Related
I need to send a set of Emails from my application (reminders) each month
1st. Is there anyway in ASP scripts to trigger an event to run
automatically? I have no dedicated server, so no DLLs or Scheduler scripts
can be used. Also adding the trigger script in the application object may
not send emails in time, as we have not enough visitors to that application.
Is there any way other than 'Clicking a Send button'
View Replies
View Related
How do I create an app that will send out emails automatically based on some criteria? Is it possible? I have some projects in a db and I would like to send emails at the end of the day to certain people in the project if that project has been update.
These emails would be sent some time between the end of a business day and beginning of another but only if the project has been updated that day. That is if someone updates project1 today, I need to send an email out sometime between today and tomorrow only for project1 but not for project2, project3, etc. I would like this to be some automated app.
Update: I have created a report in Crystal Reports that contains the reports I need to send. If anyone can direct me somewhere I can find out how to do this in either plain old ASP, ASP.Net by itself of using CR it would be great.
View Replies
View Related
i want automated translation of Classic ASP to ASP.Net?Any software out there to do this?
View Replies
View Related
My team would like to use an ASP script to have an automatic transfer of files to our live server happen each evening at a predetermined time. I was looking on the web for a script but all I could find is user driven upload scripts.
Is there anything out there that will facilitate automatic uploads of several folders and files via ASP scripts?
View Replies
View Related
I am design an web application that requires information mation to be created from tables once a day, once this information has been created it is stored temporarily in another table until the folowing day. The problem is that to creat this information a seperate .asp page has to run.
I would like this page to run early in the morning when no one is in the building and accessing the servers. I have tried using windows scheduler... this works but still needs a user to press ok on the internet security password screen we have set up. Is there any other way to get the page to run without using the browser, or to change the page into a dfferent format??
View Replies
View Related
Ok, this is a true testament to the fact that "If you work more on the design process, you spend less time in the development process."
Anyways, I am looking for an ASP based solution (ideas, I like writing the code!) for the following situation. I have read multiple articles saying that "You should never store passwords unencrypted in a database", in as much what I do is store the passwords in one way Hash MD5 encryption (can't decrypt it)
So after working for 5 hours on a getting a nice automated system that emails the user their username and password depending on the username/email address they supplied, I noticed in the email that I sent myself, that the password was a MD5 hash.
Great; all that for nothing.
When I've lost my passwords, I've seen "reactivate your account" links in emails where the user clicks on a HUGE links (the querystring is the big part) and it takes them to a page where they can do something in order to have some random password override their old password, which they can then of course log back into their control panel and change it to something more memorable (I wuv my control I made)
Anyways, you guys got an ideas how they do this, or by what method I should use to get the safest and most secure results.
I want to make sure that through both information/password changes (should I automate it and let user change PW or should they always request that change from me) and with automated pw recovery / account reactivation, that I never accidentally lock them permanently out of their accounts.
View Replies
View Related
How do I put a carriage return in the body of an email sent from the asp? Also I am
getting an error with this test code:
sendFrom="LoanerPool"
SendTo=Request.Form("NTechOut")
strSubject="Automated Checkout Response (do not reply)"
strBody="This is an automated response from the loanerpool."
set MailObject = Server.CreateObject("CDO.Message")
MailObject.From = sendFrom
MailObject.To = sendTo
MailObject.Subject = strSubject
MailObject.HTMLBody = strBody
MailObject.Send
The error is:
Error: The "SendUsing" configuration value is invalid.
View Replies
View Related
I have one registration form with "submit" button. I don't know how to make protection from automatic submit (with picture and security code)?
View Replies
View Related
when we register a email account, it hv a picture that got few words inside, n ask us to write the word to prevent automated registration attack. wat is this techinque called ? n anybody got this sample code ?
View Replies
View Related
i am sending automated mails once a person registers to the site using CDONTS, but this mail does not reach persons with msn or rediff maild's , i have tried using CDOSYS, even this is of no help.
View Replies
View Related
most websites make use of CAPTCHA to prevent automated Form submission. give me examples of how automated Form submission can be achieved? It's not that I intend to do some nefarious activities; rather I don't understand how can automated Form submission be done other than the website developer coding it (for e.g. using JavaScript to automatically post a Form, say, after 2 minutes).
View Replies
View Related
Is there any way I can call an ASP script (script.asp) on a regular basis? There are several catches:
I have no access to the server setup
I might have access to the global.asa (but might not)
I have no SQL Server
If this is one of those things that are just impossible, is there a service out there that will call a URL on a regular basis for low cost? It's not a very intense operation, basically it is called once a day.
View Replies
View Related
How I can send an automated email from ASP. In case if I want a report on the inventory of a shopping Cart Database ebveryday on aparticular time hw I can made it possible thru ASP.
I am familiar witH CDONTS and CDO.How will I initiate or set the server code to set such scedules using ASP.
View Replies
View Related
I am developing a automated website creation process for our members. They are being walked through a series of pages that gather input and make template selections etc... The problem I have is when the scripts execute I get permission denied on the section of code that connects to IIS and creates the new site.
The only way around this so far is to set IIS directory security (on the folder that has the scripts) to log in automatically with a domain admin account. I of course do not want that to be the case. Here is the line of code that bombs out.
set objservice = getobject("IIS://venus/w3svc")
The script pages are located on the same server. I have tried using a local admin account (not good either) with no luck.
By the time this line is run the directory has been created the appropriate files copied over and database has been filled with appropriate info. This seems to be my last issue to overcome.
View Replies
View Related
I'm trying to write a Function/Subroutine to send e-mail. I want it to create this to be used as an Include file so I can just give it the info and it will send the e-mail.
The following code works, but is now portable:
<!--METADATA TYPE="typelib" UUID="CD000000-8B95-11D1-82DB-00C04FB1625D" NAME="CDO for Windows 2000 Library" -->
<!--METADATA TYPE="typelib" UUID="00000205-0000-0010-8000-00AA006D2EA4" NAME="ADODB Type Library" -->
<% @LANGUAGE="VBSCRIPT" %>
<%
Option Explicit
Response.Expires = 0
%>
.........
View Replies
View Related
How can I write a program to send automated email to user's email address after they registered to my site.
I want my email has HTML format or even links. Not just one sentence.
Once the user click on the link or reply this email, their registration will be complete.
I am using ASP with Access Database.
View Replies
View Related
how to create automated MailMerge which creates a form letter using SQL connection using ASP?
View Replies
View Related
Could anyone provide asp.net code that would generate an automated email containing a users password from a database when they submit there email address. Any good sites on the subject either!
View Replies
View Related
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies
View Related
sql = "UPDATE Marknad SET" _
& " Typ ='" & Typ & "'" _
& ", Modell ='" & Modell & "'" _
& ", Arsmodell ='" & Arsmodell & "'" _
& ", Beskrivning ='" & Beskrivning & "'" _
& ", Stad ='" & Stad & "'" _
& ", Prisidé ='" & Priside & "'" _
& ", Fornamn ='" & Fornamn & "'" _
& ", Efternamn ='" & Efternamn & "'" _
& ", Telefon ='" & Telefon & "'" _
& ", Epost ='" & Epost & "'" _
& ", Datum ='" & Datum & "'" _
& " WHERE (((Marknad.Annonsnr)=" & Request.QueryString("id") & "))"
DatabaseConnection.Execute sql
---
Above does work as I want it to do BUT it inserts 1/8/2006 instead of 8/1/2006 as it should!
The best thing would be to exclude the date from updating at all, but when taking away the line:
& ", Datum ='" & Datum & "'" _
It gives an error... how do I solve this?
I forgot, you might want to see this:
Datum = date
View Replies
View Related
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
View Replies
View Related
I am trying to compare two dates. My problem is no matter what the value of mydate, it is still fall in the first IF statement condition (even if mydate is 10/10/2004). Any advise for this matter?
mydate = "6/6/"&year(date)
IF date() <= mydate THEN
response.write "first half of the year"
ELSE
response.write "second half of the year"
END IF
View Replies
View Related
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
View Replies
View Related
I would like to modify this so that the first available date that can be selected is five BUSINESS days out. The script only shows Mon-Fri so if the date is Tue Jul 13, 2004, Tue Jul 20, 2004 needs to be displayed. Code:
View Replies
View Related
I am trying to compare a date in my database to the current date. MySQL statement is:
sqltemp5="select * from users where dateclosed <= '" & date & "'"
What I am trying to accomplish is exclude records where the dateclosed field is older than todays date. Such as if dateclosed = 6/30/2004 then today being 08/25/2004 that record should be excluded.
View Replies
View Related
In a connection string, I have the following:
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)
View Replies
View Related
"SELECT id, title FROM Businesses WHERE Date_Added >= " &
Request.Form("Since_Date")
This SQL string returns all records from the table Businesses and does
not seem to be able to recognise Request.Form("Since_Date") as a valid
date. The Since_Date value is entered into a form field as
"01-Jan-2005" and appears to be treated as a date; when viewing the
SQL statement(with a response.write) it shows the date as 1/1/2005
even if it is entered into the form as 2005/1/1
I've also tried CDate(Request.Form("Since_Date")) with no luck,
although this was the treatment that worked when the SQL statement was
running in an .idc file.
Date_Added is a regular DateTime field in an Access 2000 database
Any suggestions please ?????
View Replies
View Related
