[cfaussie] Passing HTML Code
I want to create an email cfc so I just pass the arguments that I require through and it sends an email. Only issue I have is passing HTML code. How do I set a variable to equal a block of code. e.g. cfset content = font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id#/b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font Thanks Brian Knott MIS Specialist | Pricing and MIS CFO Banking | CFO Retail Banking ext 61984 ph 07 3836 1984 fax 07 3835 5455 This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Passing HTML Code
Brian, Try CFSaveContent cfsavecontent variable=content html code here /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 email. Only issue I have is passing HTML code. How do I set a variable to equal a block of code. e.g. cfset content = font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id#/b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font Thanks *Brian Knott* MIS Specialist | Pricing and MIS CFO Banking | CFO Retail Banking *ext* 61984* ph* 07 3836 1984* fax* 07 3835 5455 * * This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Passing HTML Code
You can use cfsavecontent cfsavecontent variable=content cfoutput font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id#/b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font /cfoutput /cfsavecontent On Thu, Aug 21, 2008 at 2:56 AM, 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 email. Only issue I have is passing HTML code. How do I set a variable to equal a block of code. e.g. cfset content = font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id# http://url.id/#/b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font Thanks *Brian Knott* MIS Specialist | Pricing and MIS CFO Banking | CFO Retail Banking *ext* 61984* ph* 07 3836 1984* fax* 07 3835 5455 * * This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -- anything you say can/will be used against you-- --nothing you say can/will be used to help you. -Professor James Duane --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Passing HTML Code
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 cfsavecontent variable=content cfoutput font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id# http://url.id/#/b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font /cfoutput /cfsavecontent On Thu, Aug 21, 2008 at 2:56 AM, 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 email. Only issue I have is passing HTML code. How do I set a variable to equal a block of code. e.g. cfset content = font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id# http://url.id/#/b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font Thanks *Brian Knott* MIS Specialist | Pricing and MIS CFO Banking | CFO Retail Banking *ext* 61984* ph* 07 3836 1984* fax* 07 3835 5455 * * This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -- anything you say can/will be used against you-- --nothing you say can/will be used to help you. -Professor James Duane -- anything you say can/will be used against you-- --nothing you say can/will be used to help you. -Professor James Duane --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Passing HTML Code
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: Passing HTML Code You can use cfsavecontent cfsavecontent variable=content cfoutput font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id#http://url.id/b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font /cfoutput /cfsavecontent On Thu, Aug 21, 2008 at 2:56 AM, KNOTT, Brian [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: I want to create an email cfc so I just pass the arguments that I require through and it sends an email. Only issue I have is passing HTML code. How do I set a variable to equal a block of code. e.g. cfset content = font face=Verdana, Arial, Helvetica, sans-serif size=2 Order number b#url.id#http://url.id//b is in bFX4YOU system/b and needs to be processed.brbr Email sent #timeformat(now(),'h:m tt')#nbsp;#dateformat(now(),'d mmm ')#brbr Thank youbrbr #session.fx4aus_full_name# /font Thanks Brian Knott MIS Specialist | Pricing and MIS CFO Banking | CFO Retail Banking ext 61984 ph 07 3836 1984 fax 07 3835 5455 This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.auhttp://suncorp.com.au/. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -Professor James Duane --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Adobe Contribute and CF
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 ... cfinclude template=myeditablecontentfile.cfm ... surrounding html ... . And in the myeditablecontentfile file would contain the content that you want to be editable. Cheers On Aug 20, 11:41 pm, Andrew [EMAIL PROTECTED] wrote: Hi bryn, If you use a snippet file, does it still look to the user like they are editing the parent page? Or do they just see the part they are editing? Hopefully that makes sense! Many Thanks, Andrew. On Aug 19, 5:18 pm, bryn [EMAIL PROTECTED] wrote: Here are some alternatives: 1/. Put your editable text into an XML file and allow then access to that file via contribute (and then parse etc to include the text in the main file) 2/. Put your editable area into one or more snippet file that you cfinclude in the main page and allow then edit access only to the snippet file(s) via contribute. In both cases the editable files would be placed into a folder that only stores the editable files and to which you can then apply the appropriate permissions. Cheers, Bryn On Aug 18, 9:44 am, Andrew [EMAIL PROTECTED] wrote: Hi, Is anyone else on the list using Adobe Contribute with a CF site? I would like to make a couple of blocks of text within a CF page editable to some of my content managers, but am not sure how to lock down what they can edit to just certain areas of a page. If anyone has experience with this and would be willing to share it would be greatly appreciated. Many thanks, Andrew.- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] [Ann-Syd] Tools of the Trade: Maven, An Introduction
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 much of the hard work out of the build process. Maven uses a declarative approach, in which the project structure and contents are described, rather than the task-based approach used in Ant or in traditional Makes files or shell scripts. Maven also strongly promotes the use of standard directory structures and a well defined build lifecyle. We'll be meeting at a venue courtesy of Rocketboots (http://www.rocketboots.com.au). Details and registration on http://apugs2008august.eventbrite.com Please RSVP if you want to get food and drink provided courtesy of Adobe Note: In order to be eligible for the major software prize, valued at $US2100, drawn at the November meeting you must have attended at least 3 meeting since the June major software prize draw. Previous major software winners within the last 2 years are ineligible. Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au Adobe Platform Users Group, Sydney August meeting: Tools Of The Trade: Maven, An Introduction Date: Mon 25th August 6pm for 6:30 start Details and RSVP on http://apugs2008august.eventbrite.com. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Taken two years, but time for a change
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 kept and migrated the data, as well as kept those who do feed of the site. Well when there is content J Have kept the same entry points for reading and syncing feeds. So, if you are one of those people who has subscribed, I would like to hear back from you on any problems getting a feed from this site without changing anything on your end. Feature wise, more is coming. But for now I just wanted to get the blogging side of the code out there. -- Senior Coldfusion Developer Aegeon Pty. Ltd. http://www.aegeon.com.au/ www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[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 FROMusers 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Getting users who haven't made an entry today
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 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 FROMusers 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Getting users who haven't made an entry today
I'm not sure how efficient this might be but something like this should work...
cfset startDate = createDate(yy,mm,dd)
cfsert endDate = dateAdd('d',1,startDate)
cfquery ...
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
)
/cfquery
Cheers,
Brett
B)
Seona Bellamy wrote:
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
FROMusers 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.
--
Brett Payne-Rhodes
Eaglehawk Computing
t: +61 (0)8 9371-0471
m: +61 (0)414 371 047
e: [EMAIL PROTECTED]
w: http://www.yoursite.net.au
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---
[cfaussie] Re: Getting users who haven't made an entry today
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 FROMusers 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Getting users who haven't made an entry today
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 simple! :) Thanks to Brett and Andrew for your suggestions, too. 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 -~--~~~~--~~--~--~---
