Do you have the ability to add to the database? If so, create another table with a mapping (maybe) fieldname inside the user table is just as good. Simply just flag that field as false, then when a user makes an entry, fire an event to set to true.
The run your query against that flag, and reset the flag to false. Provided you have the ability to change the database. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Seona Bellamy Sent: Friday, 22 August 2008 11:54 AM To: CFAussie Subject: [cfaussie] Getting users who haven't made an entry today Hi all! Have a system that people are supposed to log into every day and make an entry. I've been asked to created a scheduled task that every evening will look for all of the users who haven't made an entry today and send them a reminder email, but I'm having trouble getting me head around how to get that information. I have the following query, called "qReminders", that gets all of the entries: SELECT u.emailaddress, u.firstname, u.surname, u.rec_id, bde.bde_entrydate FROM users u INNER JOIN body_diaries bd ON u.rec_id = bd.bdi_usr_id INNER JOIN body_diary_entries bde ON bd.bdi_id = bde.bde_bdi_id WHERE u.user_level = 1 ORDER BY u.rec_id, bde.bde_entrydate So then I thought I'd do a query-of-query on this one to get the details of all the people who haven't made an entry today, but I can't figure out what the filtering clauses would be. Just getting the records that aren't today's won't work. I need a way to say "where bde_entrydate does not include today's date in one of the records returned for this user". Is this even a good way to go about it? I'm concerned that doing an initial query that gets everything could become quite stupidly large over time. Cheers, Seona. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---