[cfaussie] Re: Getting users who haven't made an entry today

2008-08-21 Thread Seona Bellamy
2008/8/22 Barry Beattie <[EMAIL PROTECTED]>: > > would it be more a simpler way to do a straight query? > > > select * from users where userID not in > (select userId from those that posted today) > Oh yeah. *slaps forehead* I didn't even thing of doing it that way. That works just fine. And so s

[cfaussie] Re: Getting users who haven't made an entry today

2008-08-21 Thread Andrew Scott
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

[cfaussie] Re: Getting users who haven't made an entry today

2008-08-21 Thread Brett Payne-Rhodes
I'm not sure how efficient this might be but something like this should work... select u.emailaddress, u.firstname, u.surname from user where rec_id NOT in ( select distinct bdi_usr_id from body_diaries where entrydate > startDate and entryDate < endDate )

[cfaussie] Re: Getting users who haven't made an entry today

2008-08-21 Thread Barry Beattie
would it be more a simpler way to do a straight query? select * from users where userID not in (select userId from those that posted today) On Fri, Aug 22, 2008 at 11:54 AM, Seona Bellamy <[EMAIL PROTECTED]> wrote: > > Hi all! > > Have a system that people are supposed to log into every day

[cfaussie] Getting users who haven't made an entry today

2008-08-21 Thread Seona Bellamy
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 t

[cfaussie] Taken two years, but time for a change

2008-08-21 Thread Andrew Scott
In the last 2 years I have been wanting to make my blog somewhat more pleasing than what it did look like, well the time has come to have done so. The new code base is a new framework, and uses some known frameworks to help achieve the results. Anyway, as it used blogCFC in the past. I have kep

[cfaussie] [Ann-Syd] Tools of the Trade: Maven, An Introduction

2008-08-21 Thread Chris Velevitch
Monday, 25th August at 6pm for 6:30 start James Dumay of Atlassian (http://www.atlassian.com) will introduce us to Maven, a build management tool that is a free open source Apache project. Whether you are a Flash, Flex or Coldfusion developer, you'll find that Maven has been designed to take muc

[cfaussie] Re: Adobe Contribute and CF

2008-08-21 Thread bryn
They would see the content of the snippet file, which would be part of the page they are editing. Basically, on the main page you would have something like . ... surrounding html ... ... surrounding html ... . And in the myeditablecontentfile file would contain the content that you want to be

[cfaussie] Re: Passing HTML Code

2008-08-21 Thread KNOTT, Brian
Thanks guys I knew it was easy but its late in the day and the brain is not what it should be Brian Knott ext 61984 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pepperman Sent: Thursday, 21 August 2008 5:13 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re:

[cfaussie] Re: Passing HTML Code

2008-08-21 Thread Kevin Pepperman
also. There are mailer.cfc components already built. I use this one from Sebtools. http://www.bryantwebconsulting.com/blog/index.cfm/2006/10/11/mailercfc_10 I hope that helps. On Thu, Aug 21, 2008 at 3:12 AM, Kevin Pepperman <[EMAIL PROTECTED]>wrote: > You can use cfsavecontent > > > >

[cfaussie] Re: Passing HTML Code

2008-08-21 Thread Kevin Pepperman
You can use cfsavecontent Order number #url.id# is in FX4YOU system and needs to be processed. Email sent #timeformat(now(),'h:m tt')# #dateformat(now(),'d mmm ')# Thank you #session.fx4aus_full_name# On Thu, Aug 21, 2008 at 2:56 AM, KNOTT, Brian <[EMAIL PROTECTED]>wrote:

[cfaussie] Re: Passing HTML Code

2008-08-21 Thread Ricardo Russon
Brian, Try CFSaveContent http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-a29.htm hope that helps Ric. On Thu, Aug 21, 2008 at 4:56 PM, KNOTT, Brian <[EMAIL PROTECTED]>wrote: > I want to create an email cfc so I just pass the arguments that I require > through and it sends an em