|
Hi,
I have an Access database on my website that contains emails and birthdates of my clients. It also has a field for whether or not they want to be emailed my newsletter. I want to be able to automatically run a script daily from my site that will check the database for birthdates and send an email to the address in the table on their birthday. Has anyone ever done this before? 
Thanks so much...;)
Melanie
|
|
|
|
|
mgarvin wrote:
Has anyone ever done this before?
Why not you give a try on it???
I started with nothing,
And I still have lots of it left with me.
|
|
|
|
|
mgarvin wrote:
Has anyone ever done this before?
Yes, most websites find the need to do this.
There are many ways of doing it, none that I know of that use ASP though. Remember an ASP page is only ever activated by an external source. e.g. an IIS request. So it cannot sit there checking date and time every x number of hours/minutes.
Here are three common ways to achieve what you want.
1. Create a Windows Service app. Have it sitting on the server checking the dB and date/time. When it matches what it needs to then it can send off the email.
2. Use the Task Scheduler built into Windows 2000/XP Server to run a Windows app which does the same as the Windows Service app.
3. Create a Job in SQL Server with a recurring date/time. You can send emails from within SQL.
The details of doing the above three can easily be found via Google or even here on CP.
Paul Watson
Bluegrass
Cape Town, South Africa
Christopher Duncan wrote:
Which explains why when Santa asked, "And what do you want for Christmas, little boy?" I said, "A life." (Accesories sold separately)
|
|
|
|
|
Not sure where the best place to ask this is.
I am just trying to experiment with SSL connections and want to get an instance of MS's Certificate server up on a home network. I have 5 machines set up with one being a W2K server and have IIS and the Cert Server installed but not setup. Can any one direct me to a source for some quick and dirty instructions for doing the configuration.
The service manager says it is running but I can not get to it. Obviously I need to set IIS's configuration so the call to the cert address get routed correctly.
I am not really trying to learn how to do a professional setup or administration (not enough hours in the day for me.) Just need the basics running so I can have some programming fun.
"I will find a new sig someday."
|
|
|
|
|
This is just for the record.
I had cleaned up all of the default documents other than index.html for IIS. The CertSrv uses default.asp. Egad  
"I will find a new sig someday."
|
|
|
|
|
I have been trying (unsuccessfully) to pass an array of Variants to a C++ COM component from an ASP page. I wind up getting a 'Type Mismatch' error when the ASP tries to call the COM method.
Below is the ASP and the C++ declarations for what I have tried. Anybody see what I am doing wrong?
Thanks in advance!
Mike Baker
-------------------------
//ASP
Dim MyArray(2)
Dim MyString
Dim MyObj
Dim RC
MyString = "Hello"
MyArray(0) = "One"
MyArray(1) = 2
MyArray(2) = MyString
Set MyObj = Server.CreateObject(" ... ")
RC = MyObj.Method( MyArray )
//C++ #1
STDMETHOD(Method) ( /*[in,out]*/ SAFEARRAY ** pArray,
/*[out,retval]*/ long * pnReturnCode );
//C++ #2
STDMETHOD(Method) ( /*[in,out]*/ VARIANT * pArray,
/*[out,retval]*/ long * pnReturnCode );
|
|
|
|
|
I don't know if you already solved your problem.
I spent a long time with a C++ component called by a ASP page and I remember that the output parameter can only be a VARIANT* (you have long), perhaps the problem isn't in the input parameter but in the output.
Hope it helps.
Michela
|
|
|
|
|
Thanks for the reply. You are exactly correct. The problem is that all of the [out] parms need to be VARIANT*. Now it works fine. Thanks again!
Mike
|
|
|
|
|
Hello,
I recently posted this on the MSDN Newsgroups but with no joy:
"I would like to report that the last version of IE where
the Rich Edit Control as used in Hotmail worked properly
was version 5.01 SP2
Since that time (IE5.5+) when using Hotmail's Rich Text
Editor style page with an application using an IE web-
control, the return button does not move down a line,
neither does enter. Infact no keyboard method seems to
enable a carriage return to be performed. However using
IE itself (not as part of an application via the
webcontrol) the problem does not occur.
Using IE 4 / IE5.0 on a machine with the same application,
the rich-text control in hotmail can be used without any
problems.
If anyone knows any work around or solution to this
problem please email me / reply to this message."
Anyone here have any clues?
Many thanks,
Paul
//////////////////////////////
// Paul Evans, UK.
//////////////////////////////
|
|
|
|
|
Just a stab in the dark, but could it be that some part of the App is catching the enter keypress, and isn't passing it on to the web control?
--
Help me! I'm turning into a grapefruit!
|
|
|
|
|
Good effort, but I don't think so! It's the only control that is effected.
Has anyone else who has developed a IE Webcontrol based app come across similar problems?
Cheers
//////////////////////////////
// Paul Evans, UK.
//////////////////////////////
|
|
|
|
|
I've got an old VB6 app which uses the HTML editor component from dhtmled.ocx, and it works fine on IE5, IE5.5, IE6 and IE6 SP1.
I've also got an app which hosts the webbrowser control to display pages from the Internet, including some with the HTML editor component [clsid:2D360201-FFF5-11d1-8D03-00A0C959BC0A] embeded, and I've never had any problems with it.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
I thought the rich edit control as used on Hotmail was a scripted IFRAME
Technically speaking the dictionary would define Visual Basic users as programmers.
But here again, a very generalized, liberal definition is being employed and it's wrong
- just plain wrong - Tom Archer 5/12/02
|
|
|
|
|
I writing an ASP page to receive data from user, then save as Excel file and send back that Excel file to client.
Please show me the way to solve that problem.
(I intend to use the CGI technique but I start with nothing).
|
|
|
|
|
You have a few choices for this one:
1) Write the data as a .csv text file and stream that back using an Excel mime type. No formatting available this way. This is easy but not very pretty.
2) Automate Excel using Excel on the server. MS does not recommend this as Excel is single threaded and you could have scaling problems with many requests (each request would spawn its own copy of Excel on the server). This works but proceed at your own risk.
3) Use a third party component like SoftArtisans ExcelWriter.
I have done all three and think .csv or ExcelWriter are the best options.
|
|
|
|
|
Actually another sub-option to number 1 is to write an HTML table and stream that back using Excel mime type. Then you can do whatever formatting you like. 
Jeremy
Jeremy Oldham
|
|
|
|
|
I have tried to use the option number 2 for a single request (not many requests at a time which cause many copys of Excel Server).
For example : Server.CreateObject("Excel.Application")
But I can handle that object (?) After having been created, it was closed immediately.
Another automation - Lotus123.Workbook.98 - the problem is I can not close the object once it is created (by all ways... but failed). The IIS will be down if you re-create that object at another time.
Many big problems to me. May you help me ?!
|
|
|
|
|
Hi, everyone!
I want to draw a curve like CPU/MEM monitor in
Windows in an Applet. Where can I find some sample
codes?
Cheers,
George
|
|
|
|
|
|
Thanks, Boctor pal!
Your PHP script gives me a lot of help!
Cheers,
George
|
|
|
|
|
|
Hi,
Anyone have webportal like Codeproject in ASP?
If you have, would you please share it with me?
Many thanks,
-BHKien
|
|
|
|
|
|
How can I get it?
-BHKien
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
