473,811 Members | 3,057 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

perform an operation when certain conditions are true

49 New Member
Is it possible to add code into the database, so that it monitors certain value and performs an operation when certain conditions are true?

I have a table with research in each having a completion time stamp. When this time stamp matchs the current time or has passed I want it to get removed from that table and another table to be edited. Whats the best way of doing this? Im cautious not the have a script checking it too often as it may effect the database traffic. But I dont really want the detection of the timestamp expiring to be out by any more say 5 seconds.

Thanks
May 1 '08 #1
2 1407
Atli
5,058 Recognized Expert Expert
Hi.

The best way to do something like this would be to set up a cront-job (or something similar). There is really no other way. Nothing happens unless something triggers it.

I understand you concerns about the extra load, but by timing your checks correctly and optimizing your queries you should be able to keep that in check.

MySQL 5.1 offers Triggers, which kind of works like cron-jobs, but only for MySQL. It's worth checking out if you are using 5.1.
May 5 '08 #2
ronverdonk
4,258 Recognized Expert Specialist
Please provide a meaningful title to a thread. The one you used until now will not arouse much curiosity and attract many members.

Thread Title changed to better describe the problem scenario.
Please read here: Use a Good Thread Title

I changed your title from 'Maintenence' to the current one.

moderator
May 5 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
2115
by: Ryno Rijnsburger | last post by:
I am busy packaging our product as a standard Setup project in VS.NET that uses a bunch of merge modules (basically, a merge module for every key infrastructure component in our system). Part of the installation needs to "dump" a bunch of files (third party product's project files) to the user's system. These files are transient in nature in that the user may choose
4
14663
by: erikpaulmiller | last post by:
I am trying to open up a blank email message by using the mailto: url. I have noticed that it will work for any value under 2013 characters, but once I have a To: list longer than 2014 chars then I get this IE error "Could not perform this operation because the default mail client is not properly installed". I know that this is not the ideal solution to have this many people in a To list, but it is a requirement that Outlook open up with...
9
31933
by: Maksim Kasimov | last post by:
Hello, my programm sometime gives "Segmentation fault" message (no matter how long the programm had run (1 day or 2 weeks). And there is nothing in log-files that can points the problem. My question is how it possible to find out where is the problem in the code? Thanks for any help. Python 2.2.3 FreeBSD -- Best regards,
5
2533
by: Uday Deo | last post by:
Hi everyone, I am looping through 4 nested loops and I would like to break in the inner most loop on certain condition and get the control on the 2 nd loop instead of 3rd loop. Here is briefly what I am trying to accomplish. //Loop 1 For each lp_1 in Loop1 // Certain conditions
2
2416
by: Jakub Bednarczuk | last post by:
Hi everybody I am trying to find the solution for the problem stated in the topic, but so far without any result. Let's see the problem. I have set of conditions and the description (logical sentence) how should be these conditions connected with each other. See how does it look in xml
3
4326
by: ssg31415926 | last post by:
I'm getting the error: "Unable to open the Web 'http://blah/blahblah'. You are not authorized to perform the current operation". I have changed a few things recently but I can't change them back as I need them. I can't find anything about it using searches. Yesterday, I removed the "Enable anonymous access" option from my web (within the Default Web Site). The web has Integrated Windows authentication checked. The site must check AD...
3
5865
by: aydeejay | last post by:
I'm trying to troubleshoot an issue where users are not able to bind with LDAP via "GetObject" through our ASP Classic Intranet if they stay logged in overnight (beyond their allowed login hours). The problem does not occur when performing the same bindings using a logon script. So, the user logs in, is able to perform queries all day, and then fails to log out at the end of the day. We'd prefer that they did log out nightly, but it...
1
4038
by: sandeeprmenon | last post by:
Combining bit & peices from different discussion forums, I created this program (see below) to send meeting invitation from Lotus Notes using VBA. Program successfully sends the invitation to all required parties but throws the following error when I try to process meeting counters or if I try to cancel the meeting from my calendar. "Unable to send mail; multiple matches found in Name & Address Book(s)" I removed all entries in my local...
17
10363
by: govolsbaby | last post by:
Is there a way to leave the button forecolor unchanged when it is disabled? I have multiple buttons on the form and depending on various user inputs, some will or will not be enabled but I'd rather their text not go to gray. Thanks.
0
9726
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10384
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10395
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10130
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6887
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5553
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5692
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3865
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3017
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.