Selling ColdFusion License?
Hi, If we purchased a copy of ColdFusion 10 license, is there any issues if we sell it to another body? Thank you, Richard ~| 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:359905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Selling ColdFusion License?
Thanks Andy! great info http://helpx.adobe.com/x-productkb/policy-pricing/transfer-product-license.html I think Adobe used to be particular picky about this, but EU law meant their issues could never be held to account in Europe anyway. Ultimately, no, there shouldn't be any issues. Andy On 6 January 2015 at 15:15, Richard White rich...@re-base.net wrote: ~| 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:359908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Opening Local Files
Hi, We have created an online database program. I have a requirement for a user to store links to files contained on their local machines, then at the click of a button it will open the file. If we were to store these files on our server I know we could use cfheader and cfcontent to open the file. However, seeing as the files are stored on their local machines how can I achieve this? I have read this is not possible. There MUST be a way of ding it though! Thanks for your help. Richard ~| 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:359189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Opening Local Files
Thanks Dave, although I don't quite follow. So can I program our CF application to work with a specific local application? If so do you have any recommendations? Thanks, Richard We have created an online database program. I have a requirement for a user to store links to files contained on their local machines, then at the click of a button it will open the file. If we were to store these files on our server I know we could use cfheader and cfcontent to open the file. However, seeing as the files are stored on their local machines how can I achieve this? I have read this is not possible. There MUST be a way of ding it though! You'll need local applications to manipulate local files. This is not possible with a CF web application by itself. Those local applications will need to be downloaded and installed by the user, but they can otherwise be very lightweight - for example, Java applets. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:359191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Data for Parameter but which one?
thanks guys, bit sounds good! Actually, the error is telling you exactly what is wrong. You are sending a string value of false to a field that only allows a maximum of 1 character. More than likely, you are trying to send a true/false value to a char(1) field. Try either converting your true/false value to 1/0. Also, I do believe that if you use cfqueryparam (which you should be already) and specify the sql type for the field is bit, it will properly convert your true/false values to 1/0 for you. ~| 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:359048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Encrypting Zip File
Hi, What is the best way to encrypt a zip file in ColdFusion? Many thanks, Richard ~| 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:359049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Invalid Data for Parameter but which one?
Hi, I received the following error within a query 'Invalid data value false exceeds maxlength setting 1.' I understand the error but I need to trace which parameter is having this issue as there are lots. Is there any way of getting coldfusion to tell me? Thanks, Richard ~| 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:359025 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Very Strange Bug
Hi, OK this one has me totally stumped... If I run the following code the first line dumps the contents of var1 yet the second line produces an error saying that var1 doesn't exist. cfdump var=#session.currentUser.var1# cfset var3 = #var2##session.currentUser.var1# / There is no code in between so how is this even possible? Note: this only happens in certain circumstances but I just cannot work out how it exists on one line but not the next. Thanks, Richard ~| 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:357924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Very Strange Bug
OK so it seems like I got up too early and need more sleep! I found the issue was down to something silly elsewhere in my code. Thanks Hi, OK this one has me totally stumped... If I run the following code the first line dumps the contents of var1 yet the second line produces an error saying that var1 doesn't exist. cfdump var=#session.currentUser.var1# cfset var3 = #var2##session.currentUser.var1# / There is no code in between so how is this even possible? Note: this only happens in certain circumstances but I just cannot work out how it exists on one line but not the next. Thanks, Richard ~| 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:357925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Textfield Format
I am using ExtJS 3.3 and found a good example here: http://www.sencha.com/forum/showthread.php?136002-Mask-for-TextField Carl, You should really review the documentation on the ExtJS site, for the version you are using. You do not need additional plugins for this type of thing. Ext allows you to define default empty text, masked input, and you can put a listener on the field's render event, to place the cursor on focus. The Ext forums, on the Sencha site, are a good place for this sort of info... Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 2/25/2014 3:38 PM, Carl Von Stetten wrote: Richard, You'll need to do some JavaScript magic to accomplish that. There are some widgets and jQuery plugins out there that seem to fit the bill: http://digitalbush.com/projects/masked-input-plugin/ (jQuery plugin) http://jquery-plugins.net/tag/masked-input (a list of jQuery plugins) http://jasny.github.io/bootstrap/javascript/#inputmask (Bootstrap plugin) -Carl V. On 2/25/2014 12:13 PM, Richard White wrote: Hi, This is not really a CF question but rather seeking general code advise. I want to create a textfield using ExtJS and would like the user only to have access to alter parts of the text... For example, I want to populate the textfield with 'CP - - U' When the user clicks on this textfield I want the cursor to start blinking next to the P (in the position of the empty space). Then as the user types I would like the textfield to replace the empty spaces. When they get to a dash it automatically skips the dash and keeps typing where the next underline is. Is there a special kind of textfield or formatting that can be used to achieve this? Many thanks for any advise. Richard ~| 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:357781 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Textfield Format
Perfect! Thanks Carl. Richard, You'll need to do some JavaScript magic to accomplish that. There are some widgets and jQuery plugins out there that seem to fit the bill: http://digitalbush.com/projects/masked-input-plugin/ (jQuery plugin) http://jquery-plugins.net/tag/masked-input (a list of jQuery plugins) http://jasny.github.io/bootstrap/javascript/#inputmask (Bootstrap plugin) -Carl V. On 2/25/2014 12:13 PM, Richard White wrote: ~| 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:357775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Textfield Format
Hi, This is not really a CF question but rather seeking general code advise. I want to create a textfield using ExtJS and would like the user only to have access to alter parts of the text... For example, I want to populate the textfield with 'CP - - U' When the user clicks on this textfield I want the cursor to start blinking next to the P (in the position of the empty space). Then as the user types I would like the textfield to replace the empty spaces. When they get to a dash it automatically skips the dash and keeps typing where the next underline is. Is there a special kind of textfield or formatting that can be used to achieve this? Many thanks for any advise. Richard ~| 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:357760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Setting Cookie Secure, Domain, Path
Thanks for the info Pete, I will investigate further! Richard Hi Richard, Normally you can switch between J2EE and CFID/CFTOKEN cookies without problem unless something in your application code is relying on one or the other. It may be easy to change that or it may be quite involved, it depends quite a bit on how your application is coded. If you want to use J2EE sessions then you have to edit the jrun-web.xml file http://livedocs.adobe.com/jrun/4/Programmers_Guide/techniques_servlet13.htm#1154030but this is server wide so it will be the same for all sites / applications on the server. Another option would be to use the web server to add the appropriate flags to the web server, here's an example of how you do this on IIS7+ using the IIS rewrite module: http://www.petefreitag.com/item/817.cfm -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://hackmycf.com - Is your ColdFusion Server Secure? http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10 minutes On Thu, Feb 20, 2014 at 2:39 PM, Richard White rich...@re-base.net wrote: ~| 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:357761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Setting Cookie Secure, Domain, Path
Thanks Pete, this does seem to work by adding it to the application.cfc. However, when i first open the browser and go to the site it shows an error that the session.cfide does not exist. The culprit is in the onSessionStart method as shown below. If I reload the window then its all fine as I suppose at this point the session.cfide has been created. Would you know how to resolve this? cffunction name=onSessionStart cfcookie name=CFID value=#session.cfid# httponly=true secure=yes cfcookie name=CFTOKEN value=#session.cftoken# httponly=true secure=yes /cffunction 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:357711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Setting Cookie Secure, Domain, Path
Hi Pete, yes although if i disable this my login stops working and appears the session variables that i use throughout the application cease to function. Thanks, Richard Hi Richard, do you have Use J2EE session variables checked in the CF administrator? -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://hackmycf.com - Is your ColdFusion Server Secure? http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10 minutes On Thu, Feb 20, 2014 at 5:41 AM, Richard White rich...@re-base.net wrote: ~| 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:357719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Thanks Carl, that helped alot! So, I'd just to like check, if I run the hotfixes for 9.0.1 do i need to do them one at a time, or does the latest hotfix have all the previous hotfixes bundled in? Many thanks, Richard 9.02 is not an update - it is a full install (see Charlie Arehart's blog entry for an excellent explanation http://www.carehart.org/blog/client/index. cfm/2013/8/19/understanding_ColdFusion_9.0.2_a_FAQ). As such, it cannot be installed over the top of 9.0 or 9.0.1. -Carl V. On 2/13/2014 9:19 AM, Richard White wrote: Just to double check, is it OK to install 9.02 update instead of all the 9.01 hot fixes. I am sure 9.02 will contain all the fixes but just wanted to make sure thanks Richard Some of those updates in CF 9 were pretty tricky. I would checkout the cfUpdater project for RIAForge. It can handle a lot of that craziness for you. http://cfupdater.riaforge.org/ Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Setting Cookie Secure, Domain, Path
Hi, Is there a way to set the secure, domain and path values for session CFID and CFTOKEN cookies in the application.cfc page of CF9? I have done some searches but cannot seem to find an answer. Many thanks, Richard ~| 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:357694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Setting Cookie Secure Domain and Path
Hi, How would I set the the CFID and CFTOKEN secure, domain and path attributes for a specific application in the cfapplication.cfc file? I have done some searches but cannot seem to find how to do it. Many thanks Richard ~| 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:357696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
OK thanks Steve, I'll give it a go and hopefully it will overcome the initial issue. Thanks Most of them say they are cumulative, but I've always found it best to do them one at a time. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Thanks Steve, it worked when I applied them one at a time! Most of them say they are cumulative, but I've always found it best to do them one at a time. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Upgrading CF9 Hotfixes
Hi, I am having a lot of problems trying to upgrade hot fixes. I currently have 9.01 installed. I have downloaded 9.01 hot fix as described here: http://helpx.adobe.com/coldfusion/kb/security-hotfix-coldfusion-8-8.html. However, after applying the changes the CF Admin stops working and just shows a blank page. I have followed the instructions diligently so wondered what else may be going wrong. I tried to apply the 9.02 update but again the CF admin stopped working and showed an error: 'Class not found: coldfusion.security.ESAPIUtils' I am lost as to what to try next and what the issue is. I think there were 4 hot fixes for 9.01? Do I need to load them one at a time in order, and then apply the 9.02 update? Thanks for any help or pointers, Richard ~| 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:357670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Thanks all. Yes I am installing the correct hot fixes and not renaming the jar files. I will try the cfupdater. Thanks again Richard Hi, I am having a lot of problems trying to upgrade hot fixes. I currently have 9.01 installed. I have downloaded 9.01 hot fix as described here: http://helpx.adobe. com/coldfusion/kb/security-hotfix-coldfusion-8-8.html. However, after applying the changes the CF Admin stops working and just shows a blank page. I have followed the instructions diligently so wondered what else may be going wrong. I tried to apply the 9.02 update but again the CF admin stopped working and showed an error: 'Class not found: coldfusion.security.ESAPIUtils' I am lost as to what to try next and what the issue is. I think there were 4 hot fixes for 9.01? Do I need to load them one at a time in order, and then apply the 9.02 update? Thanks for any help or pointers, Richard ~| 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:357681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Just to double check, is it OK to install 9.02 update instead of all the 9.01 hot fixes. I am sure 9.02 will contain all the fixes but just wanted to make sure thanks Richard Some of those updates in CF 9 were pretty tricky. I would checkout the cfUpdater project for RIAForge. It can handle a lot of that craziness for you. http://cfupdater.riaforge.org/ Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hash SHA-512 equivalent in JS
Thanks for the help guys Hi, We store user passwords as a hash value with a salt phrase using CF. However, we have recently had a penetration test done on our servers and they have advised that when the password gets sent to the server, the actual password gets stored in the browser memory. They have suggested adding the salt phrase and hashing using javascript before we send it to the server. However, I am wondering: 1) is this best practise as if the salt phrase is contained within Javascript it will be easy for anyone to see what it is 2) if this is best practise then how can i obfuscate the salt phrase and also is there a JS equivalent to coldfusions SHA-512 hash function? Many thanks, Richard ~| 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:357633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Hash SHA-512 equivalent in JS
Hi, We store user passwords as a hash value with a salt phrase using CF. However, we have recently had a penetration test done on our servers and they have advised that when the password gets sent to the server, the actual password gets stored in the browser memory. They have suggested adding the salt phrase and hashing using javascript before we send it to the server. However, I am wondering: 1) is this best practise as if the salt phrase is contained within Javascript it will be easy for anyone to see what it is 2) if this is best practise then how can i obfuscate the salt phrase and also is there a JS equivalent to coldfusions SHA-512 hash function? Many thanks, Richard ~| 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:357608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Cross-site Scripting
Hi, What methods do you guys use to prevent cross-site scripting in a CF9 and JavaScript application? I have seen the scriptprotect attribute in the administrator, but have also seen that this doesnt fully protect. Thanks, Richard ~| 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:357610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Secure application code from host
Hi, We have an online web application built using CF. We completely host and manage our software and provide users with an annual subscription. A large client would like to use the software in a country that has limited internet connection. Therefore, we have the possibility of providing them with the software to host on their internal networks. However, there is obviously a lot of IP within the code itself. I wouldn't want anyone to have access to the code to see how it works or allow them to tailor it. Is there a way we can package it so that it is not possible for them to access the application code? Many thanks, Richard ~| 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:357498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Secure application code from host
Thanks guys for your suggestions, i will take a look into your suggestions. BW Richard Hi, We have an online web application built using CF. We completely host and manage our software and provide users with an annual subscription. A large client would like to use the software in a country that has limited internet connection. Therefore, we have the possibility of providing them with the software to host on their internal networks. However, there is obviously a lot of IP within the code itself. I wouldn't want anyone to have access to the code to see how it works or allow them to tailor it. Is there a way we can package it so that it is not possible for them to access the application code? Many thanks, Richard ~| 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:357504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can not read response from server. Expected to read 4 bytes...
Hi, we are receiving the following intermittent CF error a lot recently and wondering if you could help diagnose this issue... Message: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. Detail: Communications link failure The last packet successfully received from the server was 256,215 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. This always seems to occur on a query that queries multiple tables in multiple database - specifically it is collecting user email addresses from 73 databases on our server. Our hosting provider has stated this seems to be a CF error and advised us to uncheck the 'Maintain connection' options for each datasource. They recommended this on the basis of reading the following post: http://www.cjboco.com/blog.cfm/post/coldfusion-error/ Before I try this I wanted to double check this was in fact the right advice and whether this would cause any additional problems? Thanks for your advice Richard ~| 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:355649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can not read response from server. Expected to read 4 bytes...
Thanks Dave, good idea. Ill setup the separate database for this query. Yes unfortunately this query specifically collects data from all databases. I used to have it as a single query per database inside of a loop but this caused an error signifying too many connections. The query is as follows: cfquery name=userExistsInDatasource datasource=rebasedb_manage cfloop index=i from=1 to=#getAllDatasources.recordcount# !--- ENSURE ALL THE SELECT STATEMENTS GET ADDED TOGETHER --- cfif i gt 1 UNION /cfif SELECT #getAllDatasources.datasourceid[i]# as datasourceid, userid FROM rebasedb_#getAllDatasources.datasourceid[i]#.users !--- add the where clause which applies the filters entered into the grid --- WHERE email = cfqueryparam value=#session.currentUser.email# cfsqltype=cf_sql_varchar maxlength=50 /cfloop /cfquery we are receiving the following intermittent CF error a lot recently and wondering if you could help diagnose this issue... Message: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. Detail: Communications link failure The last packet successfully received from the server was 256,215 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. This always seems to occur on a query that queries multiple tables in multiple database - specifically it is collecting user email addresses from 73 databases on our server. Our hosting provider has stated this seems to be a CF error and advised us to uncheck the 'Maintain connection' options for each datasource. They recommended this on the basis of reading the following post: http://www.cjboco.com/blog.cfm/post/coldfusion-error/ Before I try this I wanted to double check this was in fact the right advice and whether this would cause any additional problems? I'm unclear on what you're actually doing. You're running a single query that's querying 73 separate databases? If so, that seems like the problem you need to fix, rather than disabling the maintain connections option in your CF data sources. Disabling JDBC connection pooling will usually significantly degrade performance. If you're unable to change or fix that query, I'd recommend creating a separate CF data source that you use just to run that query, and disabling maintain connections for just that one data source. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:355651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Optimising SQL Statement
Hi, I am sure there must be a way to restructure this query to bring the time down but i cannot see it. Any pointers at all would be greatly appreciated. Hi, We have a problem with one of our MySQL statements and wondering if you guys can help point us in the right direction. Basically the following statement is taking 5 seconds to run. We have diagnosed it is down to the join of two select statement. When the select statements are run individually they take only 0.2 seconds but when combined with the JOIN it takes 5 seconds. WE have been told then when MySQL performs a join it creates temporary tables in the background. Is this correct? Is there anything you can see that we are doing wrong or can you see a better way? code start -- SELECT temp_4.primaryid, temp_1.`subjectID` , temp_4.`testOccasionID` , `studyNumbers` ,`testDate` FROM ( SELECT * FROM ( SELECT primarys.primaryid , q_1 AS `subjectID` , q_2 AS `studyNumbers` FROM primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid = questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL GROUP BY primaryid) AS maintable_1 GROUP BY `subjectID` ) AS temp_1 JOIN (SELECT * FROM (SELECT primarys.primaryid , q_1 AS `subjectID` , q_4 AS `testOccasionID` , DATE_FORMAT(q_5, '%m/%d/%Y') AS `testDate` FROM primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid = questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL AND q_4 IS NOT NULL GROUP BY primaryid) AS maintable_4 GROUP BY `subjectID` ,`testOccasionID` ) AS temp_4 ON temp_1.`subjectID` = temp_4.`subjectID` code end -- Many thanks Richard ~| 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:355601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL on CFquery
Thanks Russ, ill take a look into this You don't, afaik ypu simply need the client cert in the java keystore. See this http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html There is a handu cfadmin extension on riaforge.org for managing your keystore. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Apr 16, 2013 5:33 PM, Richard White rich...@re-base.net wrote: ~| 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:355509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
java.lang.ArrayIndexOutOfBoundsException
Hi, I am getting the following error but no information as to where the error is occurring. java.lang.ArrayIndexOutOfBoundsException This is a massive function. I am prepared to walk through the code step by step to find the error but wondering why it wasn't giving me the line of code that is causing the error and if there is anyway to find out. Thanks, Richard ~| 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:355510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: java.lang.ArrayIndexOutOfBoundsException
Hi Will, I just checked the log and it doesn't provide a message or stack trace. The only thing is says is: The specific sequence of files included or processed is: #url for file# Have you checked the log files? Got a stack trace? On 19 April 2013 13:58, Richard White rich...@re-base.net wrote: ~| 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:355513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SSL on CFquery
Hi, We have a windows server for our CF application and a Linux server for our database. We are setting up a self-signed SSL between the two servers. Our hosting company have said we need to reference the SSL in the connection string but how can I do this in a cfquery? Many thanks Richard ~| 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:355424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL on CFquery
Perfect! Many thanks Russ :) Do the following to enable SSL connection: 1. In the ColdFusion Administrator, go to Data Services Data Sources. 2. Select the data source to enable SSL Connection. 3. In the data source page, click Show Advanced Settings. 4. In the Connection String text box, specify the connection properties as per the SSL requirements. you can find detail son the connection properties here http://help.adobe.com/en_US/ColdFusion/9. 0/Admin/WS50260aa90e50c24b-32f8955c122c2720693-8000.html On Tue, Apr 16, 2013 at 12:58 PM, Richard White rich...@re-base.net wrote: Hi, We have a windows server for our CF application and a Linux server for our database. We are setting up a self-signed SSL between the two servers. Our hosting company have said we need to reference the SSL in the connection string but how can I do this in a cfquery? Many thanks Richard ~| 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:355426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL on CFquery
Hi, We have a further issue with this. The hosting company have installed the SSL certificate on the database and provided us with the details of where the certificate is stored. However, in the CF connection string it asks to provide the url of the certificate. I am confused about how to get this to work. How would i instruct coldfusion to use the certificate on the database server? Thanks, Richard Hi, We have a windows server for our CF application and a Linux server for our database. We are setting up a self-signed SSL between the two servers. Our hosting company have said we need to reference the SSL in the connection string but how can I do this in a cfquery? Many thanks Richard ~| 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:355442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Optimising SQL Statement
Hi, We have a problem with one of our MySQL statements and wondering if you guys can help point us in the right direction. Basically the following statement is taking 5 seconds to run. We have diagnosed it is down to the join of two select statement. When the select statements are run individually they take only 0.2 seconds but when combined with the JOIN it takes 5 seconds. WE have been told then when MySQL performs a join it creates temporary tables in the background. Is this correct? Is there anything you can see that we are doing wrong or can you see a better way? code start -- SELECT temp_4.primaryid, temp_1.`subjectID` , temp_4.`testOccasionID` ,`studyNumbers` ,`testDate` FROM ( SELECT * FROM ( SELECT primarys.primaryid , q_1 AS `subjectID` , q_2 AS `studyNumbers` FROM primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid = questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL GROUP BY primaryid) AS maintable_1 GROUP BY `subjectID` ) AS temp_1 JOIN (SELECT * FROM (SELECT primarys.primaryid , q_1 AS `subjectID` , q_4 AS `testOccasionID` , DATE_FORMAT(q_5, '%m/%d/%Y') AS `testDate` FROM primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid = questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL AND q_4 IS NOT NULL GROUP BY primaryid) AS maintable_4 GROUP BY `subjectID` ,`testOccasionID` ) AS temp_4 ON temp_1.`subjectID` = temp_4.`subjectID` code end -- Many thanks Richard ~| 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:355292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Now() offset by 1 hour
Hi, Since the clocks went forward in GMT the now() function is returning an incorrect time (-1 hour to what the server clock reads). I have searched over the internet and found several references to this but not solution. Has anyone found a way to fix? I am using CF9 Thanks Richard ~| 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:355226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Now() offset by 1 hour
Hi Will, thanks for your suggestion i just updated to the latest JVM 7, update 17. No change unfortunately This could be caused by an old JVM version. Which version JVM are you running? Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 2, 2013, at 12:48 PM, Richard White rich...@re-base.net wrote: ~| 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:355228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Now() offset by 1 hour
Yes, it is reporting the correct timezone. I have tried forcing the change to a different timezone, restarting the server and changing it back again but it is still reporting the incorrect time. It could well be a bug in 1.7 although I thought others may have reporting this too yet haven't seen anything. On rare occasion I've had a JVM refuse to get onto the correct timezone, while new and having the correct timezone data and the server having the correct timezone data and even reporting the correct time. 1. Make sure the JVM is reporting the correct timezone. 2. if its not, you can force it with this JVM arg in jvm.config -Duser.timezone=America/New_York If it's reporting the correct timezone, then I think we need to start looking for bugs with JVM 1.7. Unsure about that though. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 2, 2013, at 1:03 PM, Richard White rich...@re-base.net wrote: Hi Will, thanks for your suggestion i just updated to the latest JVM 7, update 17. No change unfortunately This could be caused by an old JVM version. Which version JVM are you running? Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 2, 2013, at 12:48 PM, Richard White rich...@re-base.net wrote: ~| 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:355230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Now() offset by 1 hour
Thanks guys. After running this code I can see I am running 1.6 Please excuse my ignorance but i have been searching on how to upgrade to 1.7 and have found no instructions on where to download it or upgrade. I have downloaded the JVM 7 Update 17 but it appears this isnt the same thing thanks for any guidance It may be worth double checking that you are using the version you think you are using: This will tell you: #CreateObject(java, java.lang.System).getProperty(java.version)# ~| 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:355233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Now() offset by 1 hour
I have downloaded the latest version although when I amend the jvm.config and attempt to restart CF it does not restart correctly, very odd! Download it here and install. http://www.oracle. com/technetwork/java/javase/downloads/index.html I keep my JVM Install for ColdFusion separate from the default Java that the OS is using. Typically I change the default location of the install to be in a top level folder named /java/ So c:\Java or D: java on Windows. On Linux I use the /opt folder because ColdFusion is installed in /opt so it would be /opt/java/ Then you need to edit your jvm.config file and point the java.home= to the new path of your newly installed JVM. Be sure to backup your jvm.config. So the JVM config line might look something like this. You'll have to make sure you get the path correct for your OS. java.home=C:/java/jvm_16xxx/jre Regards, Wil Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 2, 2013, at 3:26 PM, Richard White rich...@re-base.net wrote: Thanks guys. After running this code I can see I am running 1.6 Please excuse my ignorance but i have been searching on how to upgrade to 1.7 and have found no instructions on where to download it or upgrade. I have downloaded the JVM 7 Update 17 but it appears this isnt the same thing thanks for any guidance It may be worth double checking that you are using the version you think you are using: This will tell you: #CreateObject(java, java.lang.System).getProperty(java. version)# ~| 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:355236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Now() offset by 1 hour
Yes, looks like i need to update. Thanks Wil Which version of ColdFusion are you using? All you said was 9. 9 and 9.0.1 with NO updates will not work on JVM 7. You need to fully update/patch ColdFusion 9. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 2, 2013, at 4:22 PM, Richard White rich...@re-base.net wrote: I have downloaded the latest version although when I amend the jvm. config and attempt to restart CF it does not restart correctly, very odd! Download it here and install. http://www.oracle. com/technetwork/java/javase/downloads/index.html I keep my JVM Install for ColdFusion separate from the default Java that the OS is using. Typically I change the default location of the install to be in a top level folder named /java/ So c:\Java or D: java on Windows. On Linux I use the /opt folder because ColdFusion is installed in /opt so it would be /opt/java/ Then you need to edit your jvm.config file and point the java. home= to the new path of your newly installed JVM. Be sure to backup your jvm.config. So the JVM config line might look something like this. You'll have to make sure you get the path correct for your OS. java.home=C:/java/jvm_16xxx/jre Regards, Wil Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 2, 2013, at 3:26 PM, Richard White rich...@re-base.net wrote: Thanks guys. After running this code I can see I am running 1.6 Please excuse my ignorance but i have been searching on how to upgrade to 1.7 and have found no instructions on where to download it or upgrade. I have downloaded the JVM 7 Update 17 but it appears this isnt the same thing thanks for any guidance It may be worth double checking that you are using the version you think you are using: This will tell you: #CreateObject(java, java.lang.System).getProperty(java. version)# ~| 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:355238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating a knowledge base
Thanks for your reply Adam. I did have a search around and couldn't find anything. I found a mysql table, cfcollection, cfindex and cfsearch using solr engine works perfectly! The first thing I'd do is make sure I'm not simply re-inventing the wheel. Have you checked to see if someone hasn't already done this sort of thing already as an OSS project? -- Aam On 10 March 2013 12:06, Richard White rich...@re-base.net wrote: ~| 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:355140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating a knowledge base
In fact this has led me to wondering something else... We have lots of search bars for various different things all over our application. We have developed features that natively search columns in the relevant mysql columns. After seeing the capabilities of solr and cfsearch on mysql tables I fear we have re-invented the wheel with our search features. I am thinking of creating a cfcollection for each of the tables we provide search features on. Would you guys see any problem to this? Is there something against creating lots of collections and using cfsearch instead of native mysql searches? Many thanks Richard The first thing I'd do is make sure I'm not simply re-inventing the wheel. Have you checked to see if someone hasn't already done this sort of thing already as an OSS project? -- Aam On 10 March 2013 12:06, Richard White rich...@re-base.net wrote: ~| 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:355141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Creating a knowledge base
Hi, I am tasked with creating a knowledge base for our web application. I have been given lots of FAQs and wondering the best way to implement it. Would The best way be to use cfcollection or to build it natively using the database (add the FAQ data into a database and search as normal) I havent much experience with coldfusion collections but are they mainly used if the FAQs were in a bunch of documents? Thanks for any support and guidance. Best wishes, Richard ~| 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:354919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IsValid Integer 40+ and numeric argument???
Hi, I have noticed that the isvalid('integer',value) function return true for the value 40+. Whereas if i pass 40+ to a cfargument numeric type an error is displayed saying invalid numeric value. Strange discrepancy! I actually need the isvalid function to return false if the sign is on the right. is there a way to do this? 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:351929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thousand Separator ONLY
Hey Jason, yes tried it but it adds a decimal to numbers that were previously integers, or with numbers that have 5 decimals for example it rounds it to one decimal Did you try numberFormat(myNum, ,9.9) ? On 6/27/2012 1:34 PM, Richard White wrote: ~| 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:351735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thousand Separator ONLY
Thanks Claude that works perfect, muchos gracious! Try this: (Note that for the last one you will get 0s at the end of the integer part, this is probably because of an overflow error. If you really have such large numbers, a function that works exclusively on the string will be needed.) CFSCRIPT function thSepar(n) { var integerPart = numberFormat(listFirst (n, .), ___,___); if(listLen(n, .) GT 1) return integerPart . listLast(n, .); return integerPart; } /CFSCRIPT CFOUTPUT #thSepar(11)#BR #thSepar(1.1)#BR #thSepar(11.11)#BR #thSepar(1.1)#BR #thSepar(1.)#BR /CFOUTPUT ~| 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:351736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Thousand Separator ONLY
Hi, is there any way to take any integer or float and add thousand separators without having to specify or change the decimal places 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:351716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thousand Separator ONLY
I haven't been able to spot anything in the mask that does that. If i do not specify the decimal places then it returns an integer, whereas i need it to pass back the exact same value (whether it was an integer or float) but with thousand separators included thanks Should be able to do that with a number format mask http://livedocs. adobe.com/coldfusion/8/htmldocs/help.html?content=functions_m-r_08. html Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Richard White [mailto:rich...@re-base.net] Sent: Wednesday, June 27, 2012 12:21 PM To: cf-talk Subject: Thousand Separator ONLY Hi, is there any way to take any integer or float and add thousand separators without having to specify or change the decimal places 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:351718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thousand Separator ONLY
thanks for your help Robert although that didnt work as it returns lots of zeros after the decimal place. for example: 112221.111 got changed to 112,221.111000 thanks I believe you do your own format mask? I don't know the length of your number, but I think NumberFormat(myvar,__,___. __) would work to cover most any number you throw at it. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter. com/austin_ ~| 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:351722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thousand Separator ONLY
thanks Jason, although this strips off all the decimals numberFormat(myNum, ,9) thanks for your help Robert although that didnt work as it returns lots of zeros after the decimal place. for example: 112221.111 got changed to 112,221.111000 thanks com/austin_ ~| 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:351725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thousand Separator ONLY
thanks Chris, i get an error when using the regular expression that says the number 112221.111 cannot be converted to a number this looks to be an interesting challenge for all of us! :) Kinda thought that's what the DecimalFormat function was all about. But now I am reminded that the DecimalFormat function always returns the two decimal places, in addition to the thousands separators. So, I would just run that result through a REReplace and be done with it: cfset FormattedValue = REReplace(DecimalFormat(InputNumeric), \.00$, )) -Chris ~| 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:351726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thousand Separator ONLY
I think i may need to be clearer on what i am trying to achieve: I have any form of number, they could be integer or floats and with varying decimal places such as: 11 1.1 11.11 1.1 1. etc I need to have a function that simply adds the thousand separators and returns exactly how they were, such as: 11 11,111.1 11.11 1.1 111,111,111,111,111,111,111. i was hoping there was an existing function that would handle this but its looking like i am going to have to develop a custom function that handles this as the number either handles integers OR floats but not both? thanks Then try numberFormat(myNum, ,9.9) thanks Jason, although this strips off all the decimals numberFormat(myNum, ,9) thanks for your help Robert although that didnt work as it returns lots of zeros after the decimal place. for example: 112221.111 got changed to 112,221.111000 thanks com/austin_ ~| 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:351728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone use/used Flinthosts in the UK?
I used them almost 3 years ago. I found their support to be very good however they didn't have great 24 hour support. If I had a problem at the weekend I wouldn't get an answer till Monday morning. The nature of our business requires very responsive support which is why we had to switch. They could have changed in the last 3 years of course! Hi, A friend is considering using Flinthosts in the UK for hosting his ColdFusion sites. He's got 4 and their 'Professional' account looks like it would take all of them as they're not high bandwidth. Has anyone used Flinthosts and are they / were they any good? Thanks Paul -- Paul Silver Freelance Web Developer Tel: 01273 906020 (UK) http://www.paulsilver.co.uk and http://webpositioningcentre.co.uk ~| 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:351604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Apologies for the ExtJS Question: change column align dynamically
Hi, Apologies for posting an ExtJS 3.3 question on a CF forum. I have searched over the internet, had no responses on Ext forum and am about to give up so id thought id give it one last effort and hopefully one of you guys may be able to help me out :) When i load my ExtJS 3.3 grid I set the alignment of the text. I need to be able to change the alignment of the column contents after it has already loaded. Would anyone know how to do this? Thanks for any help Richard ~| 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:351605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Converting this java code into cfscript?
Thanks Leigh, made a lot of sense and works perfect!! See http://pastebin.com/M5CNshBp . Looks like my post got cut off again ... -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:351553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modify Excel Spreadsheet
Yes, although the problem i am experiecing is this... I read the spreadsheet With cfspreadsheet which puts it into a query but at this point it has lost all the formatting (bold, font size, colours, images etc) so if I try to use cfspreadsheet to update or write to a spreadsheet all that formatting is lost. Therefore i was looking for a way to directly modify the spreadsheet. Is using the poi library the best option for this? Thanks Have you looked at cfspreadsheet? Sent from my Samsung Galaxy SII On Jun 8, 2012 2:43 AM, Richard White rich...@re-base.net wrote: ~| 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:351519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Converting this java code into cfscript?
Hi, I am having difficulty understanding how i would change the follower Java code into cfscript... specifically the 'new CellRangeAddress' section: CellRangeAddress cellRangeAddress = sheet.getMergedRegion(i); CellRangeAddress newCellRangeAddress = new CellRangeAddress(newRow.getRowNum(), (newRow.getRowNum() + (cellRangeAddress.getFirstRow() - cellRangeAddress.getLastRow())), cellRangeAddress.getFirstColumn(), cellRangeAddress.getLastColumn()); thanks for your help ~| 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:351520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modify Excel Spreadsheet
Hi, does anyone have any feedback on whether its possible to open, modify and close excel spreadsheets with CF tags/functions, or would i need to use the underlying POI? 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:351502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Modify Excel Spreadsheet
Hi, I have a feeling I am missing something simple! I have an excel spreadsheet template that includes images, cell formatting etc... I need to open the spreadsheet, insert the data where required, save and close the document. Do i need to use POI for this? I was trying to read the spreadsheet with cfspreadsheet, make the changes and update the document however it is losing all formatting. I was hoping to use cf tags to accomplish this without having to tap into the underlying poi Thanks for your guidance Regards, Richard White BSc (Hons), MBCS Co-founder Business Development Director Re-Base Ltd Supporting the data management needs of Scientific Research Contact Details: Email: mailto:rich...@j7group.net mailto:rich...@re-base.net rich...@re-base.net http://www.j7group.net/ Website: http://www.re-base.net/ http://www.re-base.net/ www.re-base.net Tel: +44 (0)207 111 7768 Mob: +44 (0)7564 841 344 Personal LinkedIn: http://uk.linkedin.com/in/richardswhite http://uk.linkedin.com/in/richardswhite Re-Base LinkedIn Group: http://www.linkedin.com/company/re-base http://www.linkedin.com/company/re-base Follow us on Twitter: http://www.twitter.com/Re_Base http://www.twitter.com/Re_Base You Tube: http://www.youtube.com/ReBaseOnline http://www.youtube.com/ReBaseOnline Re-Base Ltd 5 Wormwood Street London EC2M 1RQ UK Company Number: 05613376 VAT Number: 924 9392 93 - This e-mail is confidential and privileged. If you are not the intended recipient please accept our apologies; please do not disclose, copy or distribute information in this e-mail or take any action in reliance on its contents: to do so is strictly prohibited and may be unlawful. Please inform us that this message has gone astray before deleting it. Thank you for your co-operation. ~| 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:351473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Editing MS Word Documents with ColdFusion
OK thanks Claude, will have a play around with this require me to replicate the rows many times depending on the amount of records in the database. Not trivial, but feasible. I have done some work where I generate congress badges with many fields and even images like logo and photographs. Open Office is definitely not a solution. I've never seen a Word document it was able to render properly. ~| 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:351454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Editing MS Word Documents with ColdFusion
Great suggestions guys, thanks. I will give open office a try... Hi, Last year i asked a question about the best way to open an MS Word document and edit the contents + formatting with ColdFusion. I was told at the time that the best way to do it was using a Word. Application object. I am finding this object extremely slow in writing and reformatting the documents. Has there been any new technology that will allow me to do this in a different way? Or has CF 10 come out with new methods to allow me to do this Many thanks Richard ~| 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:351417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Editing MS Word Documents with ColdFusion
thanks for the links Gerald. I have usually only worked purely with CF, are there any guides on general rules on converting Java to CF? or how to use Java with CF? thanks That is a good idea. Open Office *is* written in Java. I was curious so I looked around on the web for some code examples and the ones I found were in Java. So, in theory at least, you can create the Java objects in CF and use the code examples as a guide. Here are some examples that I found http://weblogs.java.net/blog/tchangu/archive/2005/12/open_office_jav. html http://openofficejava.blogspot.com/2009/05/openofficeorg-api.html And there is a OO developer Guide. http://wiki.services.openoffice. org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide G! On Fri, Jun 1, 2012 at 3:40 PM, Russ Michaels r...@michaels.me.uk wrote: I believe you can also use open office just install it on the server and call objects or it may have an api. Might be faster than using msword On Jun 1, 2012 7:32 PM, Eric Roberts owner@threeravensconsulting. com wrote: Look at the Apache Jakarta project's POI java classes. I believe they have ways to mod word docs. They are mostly well known for excel...but the POI classes can handles all office docs if I am not mistaken. -Original Message- From: Richard White [mailto:rich...@re-base.net] Sent: Friday, June 01, 2012 11:59 AM To: cf-talk Subject: Re: Editing MS Word Documents with ColdFusion Alternatively is there any creative ideas to read in the contents of a word document along with its formatting, and then replicate it with additional content in a different format such as PDF? thanks for any suggestions Hi, Last year i asked a question about the best way to open an MS Word document and edit the contents + formatting with ColdFusion. I was told at the time that the best way to do it was using a Word. Application object. I am finding this object extremely slow in writing and reformatting the documents. Has there been any new technology that will allow me to do this in a different way? Or has CF 10 come out with new methods to allow me to do this Many thanks Richard ~| 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:351418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Editing MS Word Documents with ColdFusion
Maybe there is another way around this: basically clients are saying they want to create the look-feel and layout of reports for themselves. We were thinking they could do this in Word and then upload the file, our application would search the document and insert the data in the spaces they have indicated (which could also be in grid format). Can you see any other easier way we could achieve this? thanks Hi, Last year i asked a question about the best way to open an MS Word document and edit the contents + formatting with ColdFusion. I was told at the time that the best way to do it was using a Word. Application object. I am finding this object extremely slow in writing and reformatting the documents. Has there been any new technology that will allow me to do this in a different way? Or has CF 10 come out with new methods to allow me to do this Many thanks Richard ~| 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:351419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Editing MS Word Documents with ColdFusion
excellent idea. although some fields may be in a grid and require me to replicate the rows many times depending on the amount of records in the database. Can you see any other easier way we could achieve this? Yes: identify each field with some string, Close the document in RTF format which is a pure text file, then read the file and search-replace the fields by their values. The result is readable under MS Word. ~| 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:351426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Editing MS Word Documents with ColdFusion
Alternatively is there any creative ideas to read in the contents of a word document along with its formatting, and then replicate it with additional content in a different format such as PDF? thanks for any suggestions Hi, Last year i asked a question about the best way to open an MS Word document and edit the contents + formatting with ColdFusion. I was told at the time that the best way to do it was using a Word. Application object. I am finding this object extremely slow in writing and reformatting the documents. Has there been any new technology that will allow me to do this in a different way? Or has CF 10 come out with new methods to allow me to do this Many thanks Richard ~| 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:351404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Editing MS Word Documents with ColdFusion
Hi, Last year i asked a question about the best way to open an MS Word document and edit the contents + formatting with ColdFusion. I was told at the time that the best way to do it was using a Word.Application object. I am finding this object extremely slow in writing and reformatting the documents. Has there been any new technology that will allow me to do this in a different way? Or has CF 10 come out with new methods to allow me to do this Many thanks Richard ~| 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:351375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Reading and writing text document sdvice
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:347868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Reading and writing text document sdvice
hi, unfortunately am unable to go down the Google Docs route as some of the data will be sensitive information and, due to regulations, needs to remain on our servers Ok thanks, didn't realise it was all XML based! Will give it a shot 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. 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... ~| 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:347871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Reading and writing text document sdvice
Hi, Ours users have several pre-built MS Word templates. I need to open these documents and replace certain parts of the text with data from the database. There are literally thousands of different designed templates so i cant directly use the CF report builder. The way i tried to do it was to use the Word.Application COM however it seems to be extremely slow both in readingand writing the document (especially grid data!!!). the other issue is that i have to purchase an MS Word license to install on the server just to get it to run. I am now wondering whether this is the best option. My users wont mind storing their templates in some other format such as rich text, or some other form. so I'm wondering if anyone has any alternative suggestions. Any suggestion welcome, 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:347864 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
I have found the word.application *extremely* slow when adding rows to a table and populating the cells with data. Has anyone else found this and know of anyway to speed it up? it is taking up to 5 minutes just to write about 50 rows! thanks 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:347853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF and Word.Application
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:347782 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
SQL grrr
Hi, i know this is probably a simple answer and i probably drunk too much coffee! given the following sql data: ID value 1 A 1 B 1 C 2 A 2 B 3 A 3 B 3 C i need to run a query that says return me the ids that are linked to values A and B and C. so this query on the above data would return IDs 1 and 3 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:347711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
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:347712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
thanks, works perfect! Hi, i know this is probably a simple answer and i probably drunk too much coffee! given the following sql data: ID value 1 A 1 B 1 C 2 A 2 B 3 A 3 B 3 C i need to run a query that says return me the ids that are linked to values A and B and C. so this query on the above data would return IDs 1 and 3 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:347720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Standard License
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:347679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ORM overhead
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:347685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Standard License
Hi, Am i right in understanding that the only places to get CF9 Standard licenses are from Adobe or hosting companies? Our hosting company doesn't resell them and we looking for the most competitive pricing! 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:347636 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 for the info guys. no unfortunately i need cf9 :) although if your cf8 is done so cheap that i can merely upgrade to cf9 which would save some dollar then i would be interested ;) Hi, Am i right in understanding that the only places to get CF9 Standard licenses are from Adobe or hosting companies? Our hosting company doesn't resell them and we looking for the most competitive pricing! 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:347666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Exact pixel hex color
Hi, I need a function that is passed an image and gets the precise color of a specified pixel. I have seen Ben Nadel's ImageUtils on riaforge and use the GetPixel function. However, it doesnt always get the exact colour. For example if i pass it a png image that has the color: R-204,G-97,B-0 it returns a color of R-255,G-0,B-0 Does anyone have any ideas how i can achieve this 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:347384 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
no it was my understanding of image processing! it returns color of bmp files fine. Hi, I need a function that is passed an image and gets the precise color of a specified pixel. I have seen Ben Nadel's ImageUtils on riaforge and use the GetPixel function. However, it doesnt always get the exact colour. For example if i pass it a png image that has the color: R-204,G-97,B-0 it returns a color of R-255,G-0,B-0 Does anyone have any ideas how i can achieve this 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:347385 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 solution 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 thanks Ray, I know that but how many others will? when dealing with x and y, most know that it its the number across and number down. Why confuse them more with words most will not know? Then consider it an opportunity to learn something. ;) Seriously - aren't we OT now? Hopefully this will solve Richard's problem. Richard - you said you tried ImageUtils at RIAForge and it didn't work properly. Did you file a bug report so we (ImageUtils is worked on by a few folks) can track it? It sounds like you said it worked for BMP but not PNG ~| 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:347391 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
also just filed the bug report :) Ray, I know that but how many others will? when dealing with x and y, most know that it its the number across and number down. Why confuse them more with words most will not know? Then consider it an opportunity to learn something. ;) Seriously - aren't we OT now? Hopefully this will solve Richard's problem. Richard - you said you tried ImageUtils at RIAForge and it didn't work properly. Did you file a bug report so we (ImageUtils is worked on by a few folks) can track it? It sounds like you said it worked for BMP but not PNG ~| 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:347392 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
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:347395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Build drag and drop interface?
thanks for the replies, its more like a drag and drop form builder, where items can be snapped into positions... i suppose similar to ExtJS Designer but one that our software can manage internally... basically our spec is that our clients have various fields in their databases. they want to design their own forms with these fields. our software must then be able to convert their designs into html to display in coldfusion pages and either populate their forms with existing data, or allow them to add new records... hence this is much the same as fields are built up in access. was hoping there would be some way in ExtJS or similar thanks Hi, We use CF as our server side technology and ExtJS as the client technology. Our clients want the ability to create their own 'forms' via drag and drop within our software (much like forms are created in MS Access) does anyone know of any means to achieve this? 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:347213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF licenses monthly?
Hi, does anyone know of any way to get CF licenses by monthly payments instead of full payment upfront? 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:347175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF licenses monthly?
OK thanks for the replies Hi, does anyone know of any way to get CF licenses by monthly payments instead of full payment upfront? 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:347181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Build drag and drop interface?
Hi, We use CF as our server side technology and ExtJS as the client technology. Our clients want the ability to create their own 'forms' via drag and drop within our software (much like forms are created in MS Access) does anyone know of any means to achieve this? 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:347182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Build drag and drop interface?
Hi Matt, sounds interesting, sorry i use houseoffusion site directly and have never seen a way of pinging people direct :/ do you see my details and mind pinging me? thanks Richard, Ping me off-list, please. I may have something of interest to you. :-) ~| 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:347211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Management API?
Hi, i am creating a management API to manage my clients' software. The benefit is that at a click of it will setup or delete the clients databases etc... what do you guys think of the security of this as i am presuming this would need to have root access into MySQL as it needs to have the ability to create and delete databases, set grants etc... is it wrong from a security point of view to have a cf data source that accesses the root user in MySQL? 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:347057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Management API?
thanks Russ :) this is how all hosting control panels work, and tools like PHPMyadmin, so it is quite normal. Obviously you would need to make sure that the API itself is secure and password protected. ~| 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:347060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
QoQ Cast Order By
Hi is there a way to use the cast function in the order by clause, e.g: Select x from query order by cast(x as date) it shows an error saying cast cannot be used. Does anyone know a way around it? 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:346893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: QoQ Cast Order By
thanks ray! Try select cast(x as y) from query order by y ~| 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:346898 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF document and form text area
Hi, we are creating a PDF to display in the browser using the cfdocument tag. However when the PDF displays in the browser we want it to include a text area where the user can simply add text and then print the PDF document (note: we don't need to save the text they enter) is this possible? 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:346745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
QuotedValueList and column reference
Hi, How can i reference a column in a QuotedValueList? For example: the following works fine: - QuotedValueList(theQuery.id) However, i need to reference the column instead of hard-coding it, the following have all failed: cfset columnName = 'id' / - QuotedValueList(theQuery['#columnName#']) - QuotedValueList(theQuery.#columnName#) cfset queryColumn = 'theQuery.#columnName#' / - QuotedValueList(queryColumn) 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:346407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: QuotedValueList and column reference
managed to get it working with the following: - Evaluate(QuotedValueList(theQuery. columnName )) Hi, How can i reference a column in a QuotedValueList? For example: the following works fine: - QuotedValueList(theQuery.id) However, i need to reference the column instead of hard-coding it, the following have all failed: cfset columnName = 'id' / - QuotedValueList(theQuery['#columnName#']) - QuotedValueList(theQuery.#columnName#) cfset queryColumn = 'theQuery.#columnName#' / - QuotedValueList(queryColumn) 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:346408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm