Re: Java to CF translation
Andrew, Are you saying that I can almost directly copy and paste that java example into a cfscript block? What you have in this email seems to be a copy of the wiki example... Duncan, This is off the top of my head, but you would be best to do it this way, and remember cfdump is your friend here too. script for ( Iterator entries = logEntries.iterator( ); entries.hasNext( ) ; ) { logEntry = entries.next( ); WriteOutput( - ); WriteOutput(revision: + logEntry.getRevision( ) ); WriteOutput( author: + logEntry.getAuthor( ) ); WriteOutput( date: + logEntry.getDate( ) ); WriteOutput( log message: + logEntry.getMessage( ) ); if ( logEntry.getChangedPaths( ).size( ) 0 ) { WriteOutput( ); WriteOutput( changed paths: ); /script On 3/9/07, Duncan [EMAIL PROTECTED] wrote: ~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java to CF translation
Sorry - on closer examination that isnt the case. I will get back to you and we can see if this is more on the right lines. Andrew, Are you saying that I can almost directly copy and paste that java example into a cfscript block? What you have in this email seems to be a copy of the wiki example... ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java to CF translation
andrew, Thanks for the push here is what I ended up with: cfif f.getChangedPaths().size() gt 0 cfset changedPathsSet = f.getChangedPaths().keySet() cfset changedPaths = changedPathsSet.iterator() cfloop condition=changedPaths.hasNext() cfset t=changedPaths.next() cfset QueryAddRow(Q) cfset Q.Message[Q.RecordCount]=f.getMessage() cfset Q.Date[Q.RecordCount]=f.getDate() cfset Q.Author[Q.RecordCount]=f.getAuthor() cfset Q.Revision[Q.RecordCount]=f.getRevision() cfset Q.Path[Q.RecordCount]=t /cfloop /cfif Duncan, This is off the top of my head, but you would be best to do it this way, and remember cfdump is your friend here too. script for ( Iterator entries = logEntries.iterator( ); entries.hasNext( ) ; ) { logEntry = entries.next( ); WriteOutput( - ); WriteOutput(revision: + logEntry.getRevision( ) ); WriteOutput( author: + logEntry.getAuthor( ) ); WriteOutput( date: + logEntry.getDate( ) ); WriteOutput( log message: + logEntry.getMessage( ) ); if ( logEntry.getChangedPaths( ).size( ) 0 ) { WriteOutput( ); WriteOutput( changed paths: ); /script On 3/9/07, Duncan [EMAIL PROTECTED] wrote: ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMAIL and Bulk Email Strategies
FYI and also if someone might be able to give me some info. We are using CF 4.5 and we send out 3 newsletters a week. As a realestate agent we send lists of properties to buyers who specify properties in price, beds, baths, area etc. The approach we take to this is to run 2 scheduled tasks. 1) makes up the list of properties we will send to the client, basically the mailing list. We do this now because it is the most intensive bit for CF and SQL. 2) actually pulls the property and its info, compiles the email then sends it all out. We are looking at about 20k emails twice a week. The problem we have is that we get a bottle neck. Take last week, CF generated about 8000 mails into the spool file and it took nearly 24 hours to clear them. We think this is unusually slow, and are looking at ways of getting the speed up, but I cant put my finger on the reason for the lack speed. CF 4.5 has a spool session every 15 seconds, the fastest it can go. But how many mails should it be trying to send in that spool session? Last Fridays analysis of our mail server shows it was sending 12 mails a minute. The mailserver in the meantime sent out another 1000 emails in the same time. Is there anything we can do / alternative that wil get these mails out of CF faster? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183677 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Report Generation
I am looking into a nicer way of generating reports with CF. Currently we generate Property lists with 10 on a page grouped by region. http://www.mcgrath.com.au/renting/printsummary/complete.cfm?requesttimeout=1200 We want to make these reports neater, and define a standard header and footer for each page. Currently there is a lot of counting of rows and other messy things going on to try and make sure we get the pagination right. these reports and variants that are required for printing can take half a day to code in CF. THERE MUST BE A BETTER WAY!!! We are wondering if there may be something available, like Crystal Reports, that we can shove out a data template, header and footer, and section headers and then it will handle all the pagination for printing?? Thanks in advance. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183678 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMAIL and Bulk Email Strategies
You can see where I'm going here: Yeah, it's slow, and something is wrong, but would fixing it actually change _any_ real world results? I agree - if its really not that important, dont try and fix something that works adequately. In this case, Yes it will make a difference, we provide open house times for the weekend, and reasonably we can assume a large proportion of users put in their work address and/or wont check their email after 5pm on a Friday night. So thats why we run it on Thursday night - to get the email to them in plenty of time before they leave work (and therefore their internet access) for the weekend. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54