RE: Reading and writing text document sdvice
Ok thanks, didn't realise it was all XML based! Will give it a shot -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 02 October 2011 11:24 To: cf-talk Subject: Re: Reading and writing text document sdvice this seems like the bit you want. http://code.google.com/apis/documents/docs/3.0/developers_guide_protocol.htm l#UpdatingDocsAndFiles I have never used it myself but it seems pretty straightforward, get the doc (which is in XML format) make changes, and post it back. On Sun, Oct 2, 2011 at 9:15 AM, Richard White rich...@j7is.co.uk wrote: thanks for the suggestion. this does seem intriguing although i have failed in my search so far to find many good examples of interacting with the documents with ColdFusion. I find even the Google API documentation isn't easy to follow and doesn't offer much java examples. Would you know of any good links to start from. I have seen Ray Camden's work on authenticating in google docs etc... which is brilliant, so i more getting stuck with amending data in a document, such as writing new line, replacing data, adding grid rows etc... thanks it might be worth looking at Google Docs as an easier option. When words docs are uploaded you can have them automatically converted to Google Docs format and then use the Google API to do what you need. ~| 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:347870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and Word.Application
Perfect, thanks!!! -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: 29 September 2011 14:51 To: cf-talk Subject: Re: CF and Word.Application This is oold The code is in ALL CAPS but should get you going. http://www.cfregex.com/cfcomet/word/ HTH G! On Thu, Sep 29, 2011 at 7:05 AM, Richard White rich...@j7is.co.uk wrote: Hi does anyone know of any good examples on writing/editing text in a word document using application.word COM. I am using the MSDN library but tearing my hair out just trying to add new sentences and replace text. Thanks ~| 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:347789 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
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: ORM overhead
Performance overhead, especially in an application that could be linked to thousands of data sources? -Original Message- From: Brian Kotek [mailto:brian...@gmail.com] Sent: 26 September 2011 18:49 To: cf-talk Subject: Re: ORM overhead You're not going to get anything other than anecdotal opinions, but everyone I know switched to ORM as soon as it was available. As far as overhead, I'm not sure what you mean. Coding overhead? Performance overhead? On Mon, Sep 26, 2011 at 1:21 PM, Richard White rich...@j7is.co.uk wrote: to rephrase this question slightly, has there been much take up on the CF9 ORM? i read somewhere it was one of the most welcome enhancements in CF9, but then i also read somewhere else its an overhead too far for many developers Hi, we are looking to restructure our system using ORM but are wondering: firstly, about the general overhead of the CF9 ORM? secondly, the overhead in terms of the following scenario: Our application is generalized and customizes itself and its database around users requirements. The users login to one central application but each client has their own database. So after logging in the system knows which database to use. Therefore, it appears we will have to configure ORM to setup an instance for each individual client. This could obviously spiral into the thousands. Would appreciate your feedback thanks ~| 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:347722 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 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:347727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Standard License
Thanks Russ, good advice -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 September 2011 13:05 To: cf-talk Subject: Re: CF Standard License All the alternatives have their advantages and disadvantages. Well the obvious advantage is that they are FREE. you wont get the proprietary features that are Trademarks of Adobe, but both Railo and OpenBlueDragon have their own unique features that CF doesn't have as well. The best test is to try both and see if your app works on them without issue, and then look at their unique features. On Sat, Sep 24, 2011 at 11:57 AM, Richard White rich...@j7is.co.uk wrote: Russ thanks for your reply on open bluedragon, it certainly seems very intriguing, do you run on this? and if so are there any downsides, or advantages, over directly buying a CF9 Standard license? thanks or open bluedragon ~| 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:347684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Exact pixel hex color
Thanks for the help, I finally got it setup after 5 years on the forum :) -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: 11 September 2011 01:02 To: cf-talk Subject: Re: Exact pixel hex color @ Leigh - That is the coolest off-list post EVAH! :-) @ Richard, There is a setting somewhere on the HoF website (sorry, not sure where as I've not been to the site in many years) where you request emails from the list. Then the posts simply show up in your inbox and you reply by hitting, well, reply. :-) On Sat, Sep 10, 2011 at 6:46 PM, Leigh cfsearch...@yahoo.com wrote: Hi Richard, This is Leigh pinging you off-list ;) Btw: Where did you file the bug report? I checked the project's issue tracker on riaforge and did not see it. -Leigh --- On Sat, 9/10/11, Richard White rich...@j7is.co.uk wrote: From: Richard White rich...@j7is.co.uk Subject: Re: Exact pixel hex color To: cf-talk cf-talk@houseoffusion.com Date: Saturday, September 10, 2011, 10:34 PM sure, can you ping me offline and ill reply with the details. sorry i would send them although i use houseoffusion site to access these lists and cant see an email address i also regularly hear you guys talking about mailing lists and being able to see each others emails. i think i am missing something as i cant figure out how to do that. I would appreciate directions from anyone on how to set that up thanks yes unfortunately it didn't work correctly with PNG files - only randomly though. Although, the test case i found consistently not to work is an image with the rgb mentioned above Do you have a sample image and code that demonstrates the problem? -Leigh ~| 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:347402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Exact pixel hex color
In fact our stories tie well together as about the time you were packing that box I was picking up a CFMX book for the first time lol -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 11 September 2011 02:09 To: cf-talk Subject: Re: Exact pixel hex color Haha. I just unpacked a box of books from my last move. It's got manuals from CF4 to CFMX7 in it. When I packed that box MX7 was the current version. How does this tie together? Sometimes things take a while for us to get around to them. On Sat, Sep 10, 2011 at 9:02 PM, Richard (J7 Group) rich...@j7is.co.ukwrote: Thanks for the help, I finally got it setup after 5 years on the forum :) -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: 11 September 2011 01:02 To: cf-talk Subject: Re: Exact pixel hex color @ Leigh - That is the coolest off-list post EVAH! :-) @ Richard, There is a setting somewhere on the HoF website (sorry, not sure where as I've not been to the site in many years) where you request emails from the list. Then the posts simply show up in your inbox and you reply by hitting, well, reply. :-) On Sat, Sep 10, 2011 at 6:46 PM, Leigh cfsearch...@yahoo.com wrote: Hi Richard, This is Leigh pinging you off-list ;) Btw: Where did you file the bug report? I checked the project's issue tracker on riaforge and did not see it. -Leigh --- On Sat, 9/10/11, Richard White rich...@j7is.co.uk wrote: From: Richard White rich...@j7is.co.uk Subject: Re: Exact pixel hex color To: cf-talk cf-talk@houseoffusion.com Date: Saturday, September 10, 2011, 10:34 PM sure, can you ping me offline and ill reply with the details. sorry i would send them although i use houseoffusion site to access these lists and cant see an email address i also regularly hear you guys talking about mailing lists and being able to see each others emails. i think i am missing something as i cant figure out how to do that. I would appreciate directions from anyone on how to set that up thanks yes unfortunately it didn't work correctly with PNG files - only randomly though. Although, the test case i found consistently not to work is an image with the rgb mentioned above Do you have a sample image and code that demonstrates the problem? -Leigh ~| 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:347404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
