Jeena, "The problem is i cant do anything with database.And i can only work in the application"
Are you saying that you can not insert or update into the database yourself(within an application you created)? Or is the problem that you can't add a new field(if one is required)? If you really have to do it in the application, than you could use a local xml file or something and store some sort of unique identifier for each email(that you would compare to the same value in the database that you apparently can't do anything with... And alone with that unique id you would store the necessary information to implement your post-dated email method. On Nov 26, 1:31 am, "jack me" <[EMAIL PROTECTED]> wrote: > Hi, > > What i understand is : > > There are two ways to do that. > 1. If there is a large amount of the emails like in thousands then you have > to maintain the data base. and you have to make window service which will > check the time of server and will send the emails at appropriate time. But > there is need of resources and think before you start to make window > service. > > To do that we need to install service on server. and some hosts not allowed > this or charge extra. > > 2. Second way is for that if mails are not in big amount. If mails are in > specific amount then On global file just make a cache item and expire after > some interval like 10 seconds and check the status of emails and compare the > time. By doing this way. application will have unnecessary consumption. > > Time can be save if we will save in xml file. > > Regards, > Jack > > > > On Wed, Nov 26, 2008 at 10:44 AM, Jeena Ajiesh <[EMAIL PROTECTED]> wrote: > > Thank you for the replies.But let i tel u one thing. Now the curreent > > process is Based on a character value 'Q'.Along with the data stored in > > database this char value is also inserted.Wen it is inserted in the > > database,it turns to 'S'-for send.The problem is i cant do anything with > > database.And i can only work in the application.So do this suggestion be > > effective in this situation? > > > On Wed, Nov 26, 2008 at 7:20 AM, AstroDrabb <[EMAIL PROTECTED]> wrote: > > >> On Tue, Nov 25, 2008 at 1:20 PM, rhaazy <[EMAIL PROTECTED]> wrote: > > >>> I think you would have to do something like store the emails in a > >>> database with the "date to be sent" column as what you would compare > >>> using a timer in your application that would fire, say, every hour. > >>> Thinking about it though I think storing emails in a database sounds > >>> like a bad idea... Hopefully the proessionals here have a better > >>> suggestion, I'd be very interested in learning how to do this myself. > > >> Well, you could write a "sender" app and then have the main app create > >> Windows Task Scheduler events. Task scheduler is built-in and ready to go > >> and well tested/used. No need to reinvent the wheel. The main app handles > >> just creating task scheduler items and the sender app just sends based on > >> the parameters passed. Or you could use a DB to hold the info to be sent > >> and just pass the sender app a PK of the item to handle. > > >> Many ways to do this simple task. I prefer the don't-reinvent-the-wheel > >> approach myself. The task scheduler also will allow admins to see details > >> of what task failed, etc. > > > Regards > > Jeena- Hide quoted text - > > - Show quoted text -
