I have a website which has to send e-mail notification to its MEMBERS daily/weekly/monthly!
How do i do it:
1) Use ASP (but it will require a visitor to visit the ASP Page!)
2) Use .exe? (what if i dont have permission on WEBHOST for executing .exes?!)
HOW DOES DEVSHED SEND WEEKLY NOTIFICATIONS.
For a project I am doing I would like to offer customers the chance to recieve notifications of an order by e-mail, SMS or MSN messenger. Is this possible using asp and without spending any money!
View Replies View Relatedwhat i'm trying to do, is to create table identical to "faults" and move all of last months entries into the new archive table.
the current SQL i have is
SQL = "CREATE TABLE "
SQL = SQL + Left(Date, 2) & ":" & Left(Right(Date, 7), 2) & ":" & Right(Date, 4)
SQL = SQL + " AS(SELECT *"
SQL = SQL + " FROM Faults"
SQL = SQL + " WHERE (((Month([DateAdded]))=Month(Date())-1));"
the error that appears is... "Error 3290 - Syntax Error in CREATE TABLE statement"
can you work out whats wrong?
I would like to have a dropdown box that dynamically populate the month and year?
View Replies View Relatedmy question is regarding using ASP to loop through the results of a sql query and calculate a monthly total based on a date field.
I am using the following query to total the number of train rides for a given branch by day type (weekday, Sat., Sun.) and create a 3 month rolling avg. (to diminish large fluctuations in the data). I am using Oracle 9i to store the data.
Please see below for the database query, the query output, and the desired output using ASP to sum the rides for each month. Code: