Re: ORM overhead
On Mon, Sep 26, 2011 at 9:50 PM, Richard (J7 Group) wrote: I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. I imagined that was the use-case :) Database vendors have specific solutions for multiple identical databases, one for each customer. A popular one is to have separate databases faked by a database server that uses just one database but shows different data based on the customer (login). I believe that is a reasonable approximation of the problem you are facing. One of the vendor buzzwords for that is Virtual Private Database and looking for that shows that the performance problem in having different classes for each customer is solvable if you use Hibernate directly: https://forum.hibernate.org/viewtopic.php?t=940748 I am unsure if ColdFusion exposes sufficient control over the Hibernate session to dynamically switch the datasource or login session in CFML, but if you want to use ORM this is the direction I would recommend exploring. So, the actual objects in the database may vary but only *very* slightly. If you want this to work you are probably going to have to merge those differences into one standard schema. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion
Hi Greg, If they have the same application name, CF will treat it as the same app. The problem is that CF thinks it's a different session, because browsers use different cookies for different domains - you are using servera.org and serverb.org, so user1 may be logged onto servera.org with cookie x, then you are directed to serverb.org and are logged out with cookie y. If you are logged onto both domains then cookie x and y are both logged in; remember that CF keeps track of sessions via cookies. If you have different cookies, it's like going onto the same server with different browsers. You can implement something like OpenID but you will still need to log-in when switching servers, but you can use the same credentials. The way I would do it, I would pass a use-once/short-expiration token when switching between domains that the receiving domain needs to authenticate against the domain that I am coming from. This authentication should be server side, like via CFHTTP or checking the DB. - Rex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
Thanks for the detailed responses. Database vendors have specific solutions for multiple identical databases, one for each customer. I'm so used to using MySQL maybe its time to look at some more powerful ones for this situation :) and the great thing about ORM as was mentioned is its portability thanks for the help I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. I imagined that was the use-case :) Database vendors have specific solutions for multiple identical databases, one for each customer. A popular one is to have separate databases faked by a database server that uses just one database but shows different data based on the customer (login). I believe that is a reasonable approximation of the problem you are facing. One of the vendor buzzwords for that is Virtual Private Database and looking for that shows that the performance problem in having different classes for each customer is solvable if you use Hibernate directly: https://forum.hibernate.org/viewtopic.php?t=940748 I am unsure if ColdFusion exposes sufficient control over the Hibernate session to dynamically switch the datasource or login session in CFML, but if you want to use ORM this is the direction I would recommend exploring. So, the actual objects in the database may vary but only *very* slightly. If you want this to work you are probably going to have to merge those differences into one standard schema. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
If you like MySQL then try MariaDB http://mariadb.org/ If you are thinking of moving to something else altogether then try Microsoft SQL Server, the express edition is FREE. On Tue, Sep 27, 2011 at 12:01 PM, Richard White rich...@j7is.co.uk wrote: Thanks for the detailed responses. Database vendors have specific solutions for multiple identical databases, one for each customer. I'm so used to using MySQL maybe its time to look at some more powerful ones for this situation :) and the great thing about ORM as was mentioned is its portability thanks for the help I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. I imagined that was the use-case :) Database vendors have specific solutions for multiple identical databases, one for each customer. A popular one is to have separate databases faked by a database server that uses just one database but shows different data based on the customer (login). I believe that is a reasonable approximation of the problem you are facing. One of the vendor buzzwords for that is Virtual Private Database and looking for that shows that the performance problem in having different classes for each customer is solvable if you use Hibernate directly: https://forum.hibernate.org/viewtopic.php?t=940748 I am unsure if ColdFusion exposes sufficient control over the Hibernate session to dynamically switch the datasource or login session in CFML, but if you want to use ORM this is the direction I would recommend exploring. So, the actual objects in the database may vary but only *very* slightly. If you want this to work you are probably going to have to merge those differences into one standard schema. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ORM overhead
Thanks for the links Russ, will take a look -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 27 September 2011 12:10 To: cf-talk Subject: Re: ORM overhead If you like MySQL then try MariaDB http://mariadb.org/ If you are thinking of moving to something else altogether then try Microsoft SQL Server, the express edition is FREE. On Tue, Sep 27, 2011 at 12:01 PM, Richard White rich...@j7is.co.uk wrote: Thanks for the detailed responses. Database vendors have specific solutions for multiple identical databases, one for each customer. I'm so used to using MySQL maybe its time to look at some more powerful ones for this situation :) and the great thing about ORM as was mentioned is its portability thanks for the help I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. I imagined that was the use-case :) Database vendors have specific solutions for multiple identical databases, one for each customer. A popular one is to have separate databases faked by a database server that uses just one database but shows different data based on the customer (login). I believe that is a reasonable approximation of the problem you are facing. One of the vendor buzzwords for that is Virtual Private Database and looking for that shows that the performance problem in having different classes for each customer is solvable if you use Hibernate directly: https://forum.hibernate.org/viewtopic.php?t=940748 I am unsure if ColdFusion exposes sufficient control over the Hibernate session to dynamically switch the datasource or login session in CFML, but if you want to use ORM this is the direction I would recommend exploring. So, the actual objects in the database may vary but only *very* slightly. If you want this to work you are probably going to have to merge those differences into one standard schema. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
One thing to note is that an ORM bean can map to a database view. We've used this technique with great success in an Oracle db, keeping zero sql in our client application. Sure, we're using a tiny subset of ORM features because of this, but it has kept complexity down for us. Dominic On 26 September 2011 21:35, Russ Michaels r...@michaels.me.uk wrote: It is a pretty easy test. make 2 pages. 1 that uses cfquery 1 that uses ORM get them both to do the same heavy database work compare the execution times. ORM is clearly going to have some overhead by its very nature, so you have to measure whether the convenience and portability outweighs the performance hit. ORM has multiple uses, it is a RAD framework the same as CFML allowing you to do complex tasks easily without underlying knowledge of the database structure, it also creates portability so that the same code will work on multiple database platforms. For many ORM removes too much control as you are limited to the confines of what ORM can do so you may find yourself unable to do certain complex or dynamic queries without dropping back into regular SQL. There is also the fact that you are moving all your data abstraction into the application layer, the stored proc advocates who prefer to keep data abstraction within the database would say this is a bad thing. It is really a case of weighing up the pros and cons of each method and choosing which best suits you and your application. It you are concerned with squeezing every cycle of speed and performance out of your app, then ORM is probably not for you. But overall I would say that most developers use CFML because of its RAD speed and convenience, so ORM is really just an extension of that so the performance hit is acceptable. On Mon, Sep 26, 2011 at 8:50 PM, Richard (J7 Group) rich...@j7is.co.uk wrote: Thanks for your reply Jochem. This is some excellent advice and we will def look into it. I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. So, the actual objects in the database may vary but only *very* slightly. The only real issue we have here is not that the objects will vary but how do I get ORM to point to purely a different data source name - but use the same set of objects. -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: 26 September 2011 20:22 To: cf-talk Subject: Re: ORM overhead On Mon, Sep 26, 2011 at 8:07 PM, Richard (J7 Group) wrote: Performance overhead, especially in an application that could be linked to thousands of data sources? I think an application with thousands of datasources is so far out of the experience of other users that we will have no way of answering your question. I do have a few questions that may be helpful in finding the right questions and answers yourself. 1. What would you consider an acceptable overhead in terms of GB of RAM? 2. What would you consider an acceptable overhead ni terms of seconds delay of application startup? Once you have answered that, run the following experiment: 1. For one database, generate the CFCs for the tables using a code generator (such as the plugin to CF Builder). 2. Add the database to the orm configuration in application.cfc 3. Add the CFC folder to the orm configuration in application.cfc. 4. Measure startup time. 5. Repeat step 1-3 for 9 more databases. 6. Measure startup time. 7. Extrapolate. With thousands of datasources even a small number of tables per datasource means on startup CF has to compile and process tens or even hundreds of thousands of CFCs to build all the right relations and objects. I expect that to be prohibitively expensive on startup time (question 2) long before you have a problem with RAM (question1), even if you use HBMXML files to store the relations. Since my experience does not go further then close to 200 tables in one application I have no idea what the result will be and am very interested in what your measurements will tell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
And this of course implies that the db is created first - and that the application is not DB agnostic. This works for us in this particular situation where CF application is secondary to the database (and as such should not control the creation of database objects). On 27 September 2011 13:08, Dominic Watson watson.domi...@googlemail.com wrote: One thing to note is that an ORM bean can map to a database view. We've used this technique with great success in an Oracle db, keeping zero sql in our client application. Sure, we're using a tiny subset of ORM features because of this, but it has kept complexity down for us. Dominic On 26 September 2011 21:35, Russ Michaels r...@michaels.me.uk wrote: It is a pretty easy test. make 2 pages. 1 that uses cfquery 1 that uses ORM get them both to do the same heavy database work compare the execution times. ORM is clearly going to have some overhead by its very nature, so you have to measure whether the convenience and portability outweighs the performance hit. ORM has multiple uses, it is a RAD framework the same as CFML allowing you to do complex tasks easily without underlying knowledge of the database structure, it also creates portability so that the same code will work on multiple database platforms. For many ORM removes too much control as you are limited to the confines of what ORM can do so you may find yourself unable to do certain complex or dynamic queries without dropping back into regular SQL. There is also the fact that you are moving all your data abstraction into the application layer, the stored proc advocates who prefer to keep data abstraction within the database would say this is a bad thing. It is really a case of weighing up the pros and cons of each method and choosing which best suits you and your application. It you are concerned with squeezing every cycle of speed and performance out of your app, then ORM is probably not for you. But overall I would say that most developers use CFML because of its RAD speed and convenience, so ORM is really just an extension of that so the performance hit is acceptable. On Mon, Sep 26, 2011 at 8:50 PM, Richard (J7 Group) rich...@j7is.co.uk wrote: Thanks for your reply Jochem. This is some excellent advice and we will def look into it. I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. So, the actual objects in the database may vary but only *very* slightly. The only real issue we have here is not that the objects will vary but how do I get ORM to point to purely a different data source name - but use the same set of objects. -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: 26 September 2011 20:22 To: cf-talk Subject: Re: ORM overhead On Mon, Sep 26, 2011 at 8:07 PM, Richard (J7 Group) wrote: Performance overhead, especially in an application that could be linked to thousands of data sources? I think an application with thousands of datasources is so far out of the experience of other users that we will have no way of answering your question. I do have a few questions that may be helpful in finding the right questions and answers yourself. 1. What would you consider an acceptable overhead in terms of GB of RAM? 2. What would you consider an acceptable overhead ni terms of seconds delay of application startup? Once you have answered that, run the following experiment: 1. For one database, generate the CFCs for the tables using a code generator (such as the plugin to CF Builder). 2. Add the database to the orm configuration in application.cfc 3. Add the CFC folder to the orm configuration in application.cfc. 4. Measure startup time. 5. Repeat step 1-3 for 9 more databases. 6. Measure startup time. 7. Extrapolate. With thousands of datasources even a small number of tables per datasource means on startup CF has to compile and process tens or even hundreds of thousands of CFCs to build all the right relations and objects. I expect that to be prohibitively expensive on startup time (question 2) long before you have a problem with RAM (question1), even if you use HBMXML files to store the relations. Since my experience does not go further then close to 200 tables in one application I have no idea what the result will be and am very interested in what your measurements will tell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:
Multiple reply-to addresses?
What's the proper method of adding multiple reply-to addresses with cfmail? I've tried a couple of things: cfmail to=#req.emailTO# from=m...@myaddress.com replyto=m...@myaddress.comcfif len(form.additionalreplyto),#form.additionalreplyto#/cfif failto=m...@myaddress.com type=html subject=#form.emailSUBJECT# server=someserver.com Also tried using cfmailparam: cfmailparam name=Reply-Tovalue=m...@myaddress.comcfif len(form.additionalreplyto),#form.additionalreplyto#/cfif or TWO cfmailparam tags: cfmailparam name=Reply-Tovalue=m...@myaddress.com cfif len(form.additionalreplyto)cfmailparam name=Reply-Tovalue=#form.additionalreplyto#/cfif None of these send an email that will go to both addresses when you hit reply. Totally confused at this point. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiple reply-to addresses?
I'm pretty sure that reply-to has to be zero or one addresses because that's just the way email works. Or, I was before I read this question anyway. What happens if you do this...? cfmail to=#req.emailTO# from=m...@myaddress.com replyto=m...@myaddress.com,y...@youraddress.com failto=m...@myaddress.com type=html subject=#form.emailSUBJECT# server=someserver.com On Tue, Sep 27, 2011 at 8:34 AM, Les Mizzell lesm...@bellsouth.net wrote: What's the proper method of adding multiple reply-to addresses with cfmail? I've tried a couple of things: cfmail to=#req.emailTO# from=m...@myaddress.com replyto=m...@myaddress.comcfif len(form.additionalreplyto),#form.additionalreplyto#/cfif failto=m...@myaddress.com type=html subject=#form.emailSUBJECT# server=someserver.com Also tried using cfmailparam: cfmailparam name=Reply-Tovalue=m...@myaddress.comcfif len(form.additionalreplyto),#form.additionalreplyto#/cfif or TWO cfmailparam tags: cfmailparam name=Reply-Tovalue=m...@myaddress.com cfif len(form.additionalreplyto)cfmailparam name=Reply-Tovalue=#form.additionalreplyto#/cfif None of these send an email that will go to both addresses when you hit reply. Totally confused at this point. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiple reply-to addresses?
it is not valid to have multiple reply-to addresses, if you want it to go to multiple users then set the reply-to to a LIST/MRA address. On Tue, Sep 27, 2011 at 2:48 PM, John M Bliss bliss.j...@gmail.com wrote: I'm pretty sure that reply-to has to be zero or one addresses because that's just the way email works. Or, I was before I read this question anyway. What happens if you do this...? cfmail to=#req.emailTO# from=m...@myaddress.com replyto=m...@myaddress.com,y...@youraddress.com failto=m...@myaddress.com type=html subject=#form.emailSUBJECT# server=someserver.com On Tue, Sep 27, 2011 at 8:34 AM, Les Mizzell lesm...@bellsouth.net wrote: What's the proper method of adding multiple reply-to addresses with cfmail? I've tried a couple of things: cfmail to=#req.emailTO# from=m...@myaddress.com replyto=m...@myaddress.comcfif len(form.additionalreplyto),#form.additionalreplyto#/cfif failto=m...@myaddress.com type=html subject=#form.emailSUBJECT# server=someserver.com Also tried using cfmailparam: cfmailparam name=Reply-Tovalue=m...@myaddress.comcfif len(form.additionalreplyto),#form.additionalreplyto#/cfif or TWO cfmailparam tags: cfmailparam name=Reply-Tovalue=m...@myaddress.com cfif len(form.additionalreplyto)cfmailparam name=Reply-Tovalue=#form.additionalreplyto#/cfif None of these send an email that will go to both addresses when you hit reply. Totally confused at this point. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL need to return data even if specific where statement isnt matched
Switch your query around and join the answers to the questions, instead of the questions to the answers. Hopefully that makes sense. On Mon, Sep 26, 2011 at 11:43 AM, Adam Bourg adam.bo...@gmail.com wrote: 've built an extension to a employment application where we can easily add new questions to the form. I need to query to match on both which job they applied to and what application ID it is. I need to return both the answer and the question, the problem is it will return both if both are defined, but I need it to return the question, even if the application isn't defined, but right now it'll only return the question if the answer is defined. Please help! Code: (Note the where uses a Coldfusion variable, so nothing out of the normal) SELECT dbo.mod_employmentAppQuestionAnswers.questionID ,dbo.mod_employmentAppQuestionAnswers.questionDefinitionID ,dbo.mod_employmentAppQuestionAnswers.AppID ,dbo.mod_employmentAppQuestionAnswers.questionText ,dbo.mod_employmentAppQuestionAnswers.questionDate1 ,dbo.mod_employmentAppQuestionAnswers.questionDate2 ,dbo.mod_employmentAppQuestionAnswers.questionBit ,dbo.mod_employmentAppQuestionDefinitions.definitionID ,dbo.mod_employmentAppQuestionDefinitions.jobTitleID ,dbo.mod_employmentAppQuestionDefinitions.title AS QuestionTitle ,dbo.mod_employmentAppQuestionDefinitions.questionTypeID ,dbo.mod_employmentAppQuestionDefinitions.description ,dbo.mod_employmentAppQuestionDefinitions.isActive ,dbo.mod_employmentAppJobTitles.title AS JobTitle ,dbo.mod_employmentAppQuestionTypes.type AS QuestionType FROM dbo.mod_employmentAppQuestionAnswers FULL JOIN dbo.mod_employmentAppQuestionDefinitions ON dbo.mod_employmentAppQuestionAnswers.questionDefinitionID = dbo.mod_employmentAppQuestionDefinitions.definitionID INNER JOIN dbo.mod_employmentAppJobTitles ON dbo.mod_employmentAppQuestionDefinitions.jobTitleID = dbo.mod_employmentAppJobTitles.jobTitleID LEFT JOIN dbo.mod_employmentAppQuestionTypes ON dbo.mod_employmentAppQuestionDefinitions.questionTypeID = dbo.mod_employmentAppQuestionTypes.questionTypeID WHERE (dbo.mod_employmentAppQuestionDefinitions.jobTitleID = cfqueryparam cfsqltype=cf_sql_integer value=#jobTitleID# /) AND (dbo.mod_employmentAppQuestionAnswers.AppID = cfqueryparam cfsqltype=cf_sql_integer value=#applicationID# /) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiple reply-to addresses?
On 9/27/2011 10:06 AM, Russ Michaels wrote: it is not valid to have multiple reply-to addresses, if you want it to go to multiple users then set the reply-to to a LIST/MRA address. Interestingly enough, in Thunderbird I can add multiple reply-to addresses when composing an email, and they will appear in thereceived email header as: reply-to: o...@address.com,t...@address.com ...and indeed, hitting reply will then show both of them as To addresses ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiple reply-to addresses?
On Tue, Sep 27, 2011 at 4:06 PM, Russ Michaels wrote: it is not valid to have multiple reply-to addresses, if you want it to go to multiple users then set the reply-to to a LIST/MRA address. While it is not valid to have multiple Reply-to headers in your email message, RFC 2822 specifically says the one Reply-to header you are allowed to have consists of a list of email addresses. It just happens to be so that that lists usually has a length of 1. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Paypal integration
Buy now button (form submission). Does anyone know if it is possible to use the form to specify a different IPN url? I'm currently using the URL specified in the Merchant Services section of the customer's account, but it would save me a lot of time if I could specify it using the form instead. Thanks in advance, Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -- I am using the free version of SPAMfighter. We are a community of 7 million users fighting spam. SPAMfighter has removed 3037 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Paypal integration
You can specify notify_url as a hidden form element: Here's the docs on the form elements that you can use: https://cms.paypal.com/us/cgi-bin/?cmd=_render-contentcontent_ID=developer/e_howto_html_Appx_websitestandard_htmlvariables Keep in mind that the hidden fields could be modified by the user, that's why using the paypal button api, or the paypal website are the best solutions, but depending on what you are doing you might be able to do sufficient validation in the IPN. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Tue, Sep 27, 2011 at 11:44 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Buy now button (form submission). Does anyone know if it is possible to use the form to specify a different IPN url? I'm currently using the URL specified in the Merchant Services section of the customer's account, but it would save me a lot of time if I could specify it using the form instead. Thanks in advance, Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -- I am using the free version of SPAMfighter. We are a community of 7 million users fighting spam. SPAMfighter has removed 3037 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ORM overhead
Thanks, another good strategy for us to consider! -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 27 September 2011 13:11 To: cf-talk Subject: Re: ORM overhead And this of course implies that the db is created first - and that the application is not DB agnostic. This works for us in this particular situation where CF application is secondary to the database (and as such should not control the creation of database objects). On 27 September 2011 13:08, Dominic Watson watson.domi...@googlemail.com wrote: One thing to note is that an ORM bean can map to a database view. We've used this technique with great success in an Oracle db, keeping zero sql in our client application. Sure, we're using a tiny subset of ORM features because of this, but it has kept complexity down for us. Dominic On 26 September 2011 21:35, Russ Michaels r...@michaels.me.uk wrote: It is a pretty easy test. make 2 pages. 1 that uses cfquery 1 that uses ORM get them both to do the same heavy database work compare the execution times. ORM is clearly going to have some overhead by its very nature, so you have to measure whether the convenience and portability outweighs the performance hit. ORM has multiple uses, it is a RAD framework the same as CFML allowing you to do complex tasks easily without underlying knowledge of the database structure, it also creates portability so that the same code will work on multiple database platforms. For many ORM removes too much control as you are limited to the confines of what ORM can do so you may find yourself unable to do certain complex or dynamic queries without dropping back into regular SQL. There is also the fact that you are moving all your data abstraction into the application layer, the stored proc advocates who prefer to keep data abstraction within the database would say this is a bad thing. It is really a case of weighing up the pros and cons of each method and choosing which best suits you and your application. It you are concerned with squeezing every cycle of speed and performance out of your app, then ORM is probably not for you. But overall I would say that most developers use CFML because of its RAD speed and convenience, so ORM is really just an extension of that so the performance hit is acceptable. On Mon, Sep 26, 2011 at 8:50 PM, Richard (J7 Group) rich...@j7is.co.uk wrote: Thanks for your reply Jochem. This is some excellent advice and we will def look into it. I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. So, the actual objects in the database may vary but only *very* slightly. The only real issue we have here is not that the objects will vary but how do I get ORM to point to purely a different data source name - but use the same set of objects. -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: 26 September 2011 20:22 To: cf-talk Subject: Re: ORM overhead On Mon, Sep 26, 2011 at 8:07 PM, Richard (J7 Group) wrote: Performance overhead, especially in an application that could be linked to thousands of data sources? I think an application with thousands of datasources is so far out of the experience of other users that we will have no way of answering your question. I do have a few questions that may be helpful in finding the right questions and answers yourself. 1. What would you consider an acceptable overhead in terms of GB of RAM? 2. What would you consider an acceptable overhead ni terms of seconds delay of application startup? Once you have answered that, run the following experiment: 1. For one database, generate the CFCs for the tables using a code generator (such as the plugin to CF Builder). 2. Add the database to the orm configuration in application.cfc 3. Add the CFC folder to the orm configuration in application.cfc. 4. Measure startup time. 5. Repeat step 1-3 for 9 more databases. 6. Measure startup time. 7. Extrapolate. With thousands of datasources even a small number of tables per datasource means on startup CF has to compile and process tens or even hundreds of thousands of CFCs to build all the right relations and objects. I expect that to be prohibitively expensive on startup time (question 2) long before you have a problem with RAM (question1), even if you use HBMXML files to store the relations. Since my experience does not go further then close to 200 tables in one application I have no idea what the result will be and am very interested in what your measurements will tell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/
RE: Paypal integration
Many thanks, Peter .. also found the answer on www.x.com ... -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: 27 September 2011 17:26 To: cf-talk Subject: Re: Paypal integration You can specify notify_url as a hidden form element: Here's the docs on the form elements that you can use: https://cms.paypal.com/us/cgi-bin/?cmd=_render-contentcontent_ID= developer/e_howto_html_Appx_websitestandard_htmlvariables Keep in mind that the hidden fields could be modified by the user, that's why using the paypal button api, or the paypal website are the best solutions, but depending on what you are doing you might be able to do sufficient validation in the IPN. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Tue, Sep 27, 2011 at 11:44 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Buy now button (form submission). Does anyone know if it is possible to use the form to specify a different IPN url? I'm currently using the URL specified in the Merchant Services section of the customer's account, but it would save me a lot of time if I could specify it using the form instead. Thanks in advance, Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -- I am using the free version of SPAMfighter. We are a community of 7 million users fighting spam. SPAMfighter has removed 3037 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Paypal integration
There was a presentation at NCDevCon by Sidney Maestre of PayPal. The url to all the presos is http://go.ncsu.edu/ncdevcon2011 You will need Silverlight to view them. Click on the Web presentations and look for his talk if you want some inside on current and new features. -- LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Google+: https://plus.google.com/117357905892731200369 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
jQuery Font Resize
Hello I am trying to implement this jquery and it only works when I remove the attached CSS. Any suggestions? http://www.shopdev.co.uk/blog/font-resize.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiple reply-to addresses?
FYI, A list is valid for most of the email headers, thus why I suggested that :-) TO, CC,BCC,Reply-To, fail-to etc. however don't use BIG lists as that will usually get flagged as spam. On Tue, Sep 27, 2011 at 4:42 PM, Jochem van Dieten joch...@gmail.com wrote: On Tue, Sep 27, 2011 at 4:06 PM, Russ Michaels wrote: it is not valid to have multiple reply-to addresses, if you want it to go to multiple users then set the reply-to to a LIST/MRA address. While it is not valid to have multiple Reply-to headers in your email message, RFC 2822 specifically says the one Reply-to header you are allowed to have consists of a list of email addresses. It just happens to be so that that lists usually has a length of 1. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jQuery Font Resize
I don't think you can attach files to HOF emails. You'll have to just paste the css in the body of your message. On Tue, Sep 27, 2011 at 2:37 PM, Torrent Girl moniqueb...@gmail.com wrote: Hello I am trying to implement this jquery and it only works when I remove the attached CSS. Any suggestions? http://www.shopdev.co.uk/blog/font-resize.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Exchange 2010 via EWS Java API
I'm attempting to retrieve a list of contacts from a mailbox on an Exchange 2010 server. Here's the code I'm using. cfset service = CreateObject(java,microsoft.exchange.webservices.data.ExchangeService).init() cfset credentials = CreateObject(java,microsoft.exchange.webservices.data.WebCredentials).init(user account name@domain name,password) / cfset returnValue = service.setCredentials(credentials) / cfset returnvalue = service.getCredentials() / cfset uri = CreateObject(java,java.net.URI) / cfset returnValue = uri.init(https://ExchangeServerName/ews/Exchange.asmx) cfset returnValue = service.setUrl(uri) / cfset WellKnownFolderName = CreateObject(java,microsoft.exchange.webservices.data.WellKnownFolderName) / cfset ViewResults = service.findItems(CreateObject(java,microsoft.exchange.webservices.data.FolderId).init(WellKnownFolderName.Contacts, CreateObject(java,microsoft.exchange.webservices.data.Mailbox).init(mailbox email address,SMTP)),CreateObject(java,microsoft.exchange.webservices.data.ItemView).init(1000)) / cfdump var=#ViewResults# The error message I'm receiving is as follows: The request failed. Could not read value from START_ELEMENT.Could not find CHARACTERS with stack trace of the following: microsoft.exchange.webservices.data.ServiceRequestException: The request failed. Could not read value from START_ELEMENT.Could not find CHARACTERS at microsoft.exchange.webservices.data.SimpleServiceRequestBase.internalExecute(Unknown Source) at microsoft.exchange.webservices.data.MultiResponseServiceRequest.execute(Unknown Source) at microsoft.exchange.webservices.data.ExchangeService.findItems(Unknown Source) at microsoft.exchange.webservices.data.ExchangeService.findItems(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at coldfusion.runtime.StructBean.invoke(StructBean.java:511) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2300) at cfscribble2ecfm14055155.runPage(C:\path to cfml template:57) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: microsoft.exchange.webservices.data.ServiceXmlDeserializationException: Could not read value from START_ELEMENT.Could not find CHARACTERS at microsoft.exchange.webservices.data.EwsXmlReader.readValue(Unknown Source) at microsoft.exchange.webservices.data.EwsXmlReader.readElementValue(Unknown Source) at microsoft.exchange.webservices.data.EwsXmlReader.readElementValue(Unknown Source) at
Re: cfquickdocs.com down?
Hi Guys, Several years ago I created http://cfdocs.org which had CF 5,6,7 docs - I just updated the site with CF9 docs, I'm also testing out hosting it on Amazon CloudFront CDN to provide even faster response times for all of you, but I have a few kinks to iron out before I flip the switch on that. The main reason I created the site back in the day was so you could do a url shortcut like http://cfdocs.org/cfqueryparam to get to the cfqueryparam docs. You can do this with any tag or function, and here are a few other handy shortcuts: http://cfdocs.org/tags - all tags http://cfdocs.org/functions - functions by category http://cfdocs.org/application-cfc - Application.cfc reference Let me know if you find any problems with the new site. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Mon, Sep 26, 2011 at 6:09 PM, Alan Rother alan.rot...@gmail.com wrote: If you guys ever get hold of him, I'd be happy to act as a mirror. It would be nice to have a few of those out there... =] On Mon, Sep 26, 2011 at 3:03 PM, Josh Nathanson joshnathan...@gmail.com wrote: Through some digging I was able to connect it to Jacob Munson, who I believe is on this list, or at least was at one time. Jake you out there?? We need CFQuickDocs! -- Josh On Mon, Sep 26, 2011 at 11:36 AM, Kumar Shah shahku...@gmail.com wrote: http://cfquickdocs.com/ seems to be down (since yesterday) I believe. Anybody know who maintained this/can reach out to them? Has proved to be really useful for looking things up. Thanks -- Kumar Shah http://www.coldfusion-ria.com/Blog/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347757 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jQuery Font Resize
You'll have to just paste the css in the body of your message. Or post them to pastebin http://pastebin.com/ The weird thing about your situation is that the JS is manipulating the existing Font size attribute. Off the top of my head... You might want to enclose the font you want to change with a div or a span and use the ID or class to define the text you want to change so So instead if using the HTML attribute $('html') you could use .pixels class define the text to change like so: $(.increaseFont).click(function(){ var currentFontSize = $('.pixels').css('font-size'); var currentFontSizeNum = parseFloat(currentFontSize, 10); var newFontSize = currentFontSizeNum*1.2; $('.pixels').css('font-size', newFontSize); return false; }); div class=pixels This div's class has a font-size property defined in pixels./div On Tue, Sep 27, 2011 at 3:09 PM, Michael Grant mgr...@modus.bz wrote: I don't think you can attach files to HOF emails. You'll have to just paste the css in the body of your message. On Tue, Sep 27, 2011 at 2:37 PM, Torrent Girl moniqueb...@gmail.com wrote: Hello I am trying to implement this jquery and it only works when I remove the attached CSS. Any suggestions? http://www.shopdev.co.uk/blog/font-resize.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquickdocs.com down?
Bookmarked already Peter. It looks very nice. A couple of comments though. I looked at a random set of tags and one thing that made things a bit difficult what the lack of differentiation in the attributes tables. How about adding some striping there if possible, or at least use a border. Also one thing I've found very useful with cfquickdocs was the cfquickdocs search widget you could add to firefox. (the search field in teh upper right corner). If you could set something like that up cfdocs would really kick butt. Otherwise its looks great. Many thanks, larry Hi Guys, Several years ago I created http://cfdocs.org which had CF 5,6,7 docs - I just updated the site with CF9 docs, I'm also testing out hosting it on Amazon CloudFront CDN to provide even faster response times for all of you, but I have a few kinks to iron out before I flip the switch on that. The main reason I created the site back in the day was so you could do a url shortcut like http://cfdocs.org/cfqueryparam to get to the cfqueryparam docs. You can do this with any tag or function, and here are a few other handy shortcuts: http://cfdocs.org/tags - all tags http://cfdocs.org/functions - functions by category http://cfdocs.org/application-cfc - Application.cfc reference Let me know if you find any problems with the new site. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm