JRUN Intermittent Death
Hi All, A couple of weeks ago I applied the APSB13-13, APSB13-03 and ColdFusion 9.0.2 Cumulative Hotfix 1. After applying this patch however, I've been experiencing intermittent outages where the jrun service seems to spike. I'm not totally confident it was the patches that did it, but that's the only thing I can think of that changed since then. The issue actually started popping up two days after the patches were successfully applied. Do you guys think it could be the patches? I would really hate to un-patch my server. One thing that had occurred to me, is that my server instance of ColdFusion is currently using JVM 1.6. Does anyone thing upgrading to JVM 1.7 would help? What are the pros and cons of using JVM 1.7? Thanks, Paul ~| 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:355878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sessions failing due to multiple CFID / CFTOKEN cookies
We're encountering the following issue with some percentage of IE users (Definitely but not necessarily limited to IE8 8.0.7601.17514 windows 7). Basically their SESSION is failing the same way it might if they're cookies were disabled, however, we are able to set cookies manually using CFCOOKIE. After running several tests, we found that the users request headers include 2 CFID and CFTOKEN cookies. It seems like Coldfusion writes both into the COOKIE scope, then can't translate them into the SESSION so creates a new (third) CFID and CFTOKEN pair, then overwrites the value of both in the COOKIE scope. CGI.HTTP_COOKIES -- CFID=19602005; CFTOKEN=13461642; (other cookies removed); CFID=20907643; CFTOKEN=42056124; (other cookies removed); COOKIES -- struct CFID 20907644 CFID 20907644 CFTOKEN 22098534 CFTOKEN 22098534 SESSION -- struct cfid 20907644 cftoken 22098534 sessionid APPNAME_20907644_22098534 urltoken CFID=20907644CFTOKEN=22098534 Anybody know what could be going on here? Thanks in advance! ~| 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:351997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Maximum Post Variables
Hi All, I'm running into an issue, where when I create over 100 different form elements with different content I get a 500 error. I'd like to increase this number up from 100 however I can't find an area to do this. My original thought was that it was in the ColdFusion Administrator -- settings -- Maximum size of post data however, when I upped this, it had no effect on the number of post variables. I think this setting seems to be the post variable size, as like for file uploads ect... I'm running on ColdFusion 9.0.2 and when I run the code below and hit submit I receive an error. Anyone have any ideas? form action= method=post cfoutput cfloop from=1 to=100 index=i input name=txtBox#i# type=hidden value=txtValue#i# / /cfloop /cfoutput input type=submit name=txtButton / /form ~| 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:351760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Maximum Post Variables
Hi All, I'm running into an issue, where when I create over 100 different form elements with different content I get a 500 error. I'd like to increase this number up from 100 however I can't find an area to do this. My original thought was that it was in the ColdFusion Administrator -- settings -- Maximum size of post data however, when I upped this, it had no effect on the number of post variables. I think this setting seems to be the post variable size, as like for file uploads ect... I'm running on ColdFusion 9.0.2 and when I run the code below and hit submit I receive an error. Anyone have any ideas? form action= method=post cfoutput cfloop from=1 to=100 index=i input name=txtBox#i# type=hidden value=txtValue#i# / /cfloop /cfoutput input type=submit name=txtButton / /form ~| 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:351761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Maximum Post Variables
Hi Wil, This is exactly what I was looking for. Thanks!! Paul There are several blogs that talk about this. It is a 'setting' http://www.cutterscrossing.com/index. cfm/2012/3/27/ColdFusion-Security-Hotfix-and-Big-Forms Here's one. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 29, 2012, at 3:55 PM, Paul Alkema wrote: Hi All, I'm running into an issue, where when I create over 100 different form elements with different content I get a 500 error. I'd like to increase this number up from 100 however I can't find an area to do this. My original thought was that it was in the ColdFusion Administrator -- settings -- Maximum size of post data however, when I upped this, it had no effect on the number of post variables. I think this setting seems to be the post variable size, as like for file uploads ect... I'm running on ColdFusion 9.0.2 and when I run the code below and hit submit I receive an error. Anyone have any ideas? form action= method=post cfoutput cfloop from=1 to=100 index=i input name=txtBox#i# type=hidden value=txtValue#i# / /cfloop /cfoutput input type=submit name=txtButton / /form ~| 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:351764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypt/Decrypt
My preferred encryption algorithm is AES, as this is what the Government uses to encrypt classified documents. :) Paul Alkema http://paulalkema.com http://twitter.com/#!/paulalkema ~| 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:345416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CDN and Coldfusion
Hi Donnie, First off, let me just say I'm no CDN expert but have used CDN's several times and am fairly familiar with them. From what it sounds like, your asking if you can have a CDN run and distribute ColdFusion applications? As far as I know, this isn't a capability of a CDN, that would be more for something like a mirrored server. CDN's are for distributing content like images, css, javascript and any other client based content. One thing worth mentioning though, is that (according to yahoo***) an average of 80% of the front end load time is spent loading what a CDN is capable of distributing. Also, when your server is far away from your client user, the client based content will be slower however the server response time won't slow down. IE; if a page take 5 seconds to load from china and 2 seconds from the US, the server response time will be the same for both users. It is the time taken to load the client content like images and css that will slow the load time, not the server response. Make sense? ***http://developer.yahoo.com/performance/rules.html Thanks, Paul Alkema http://paulalkema.com http://twitter.com/#!/paulalkema On Tue, Jun 14, 2011 at 5:17 PM, Donnie Carvajal donnie.carva...@transformyx.com wrote: Has anyone ever worked with a CDN like Akamai with Coldfusion where the actual content is distributed, not just images and documents? Thanks, Donnie ~| 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:345325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CDN and Coldfusion
Oh yeah! Something else just mentioning is that if your not hooked on Akamai as your CDN, I've found Amazon CloudFront to be reliable and relatively inexpensive. : ) http://aws.amazon.com/cloudfront/ Paul Alkema http://paulalkema.com http://twitter.com/#!/paulalkema ~| 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:345326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CDN and Coldfusion
I think what your describing is more of mirrored servers than a Content Delivery Network. Mirrored servers are a completely different story, he could use mirrored servers if he doesn't mind spending that kind of money. I prefer CDN's. Cheaper, almost as effective and easier to maintain. On Wed, Jun 15, 2011 at 10:52 AM, Dave Watts dwa...@figleaf.com wrote: From what it sounds like, your asking if you can have a CDN run and distribute ColdFusion applications? As far as I know, this isn't a capability of a CDN, that would be more for something like a mirrored server. CDNs can be used with dynamic content, but it gets ... complicated. You can, for example, distribute edge servers, use in-memory database replication, etc, etc. 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:345328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cgi.host_name Security Exploit
Greetings and Salutations My Fellow Programmers! I have recently discovered a security flaw that I have reported to the Adobe team regarding the use of the variable cgi.host_name. As you know, the cgi.host_name is typically the hostname of the server or the websites domain name. I've discovered an exploit that allows a user to basically change this variable to anything they want for the user's current session. This exploit could be spread across sessions in instances where a website is caching absolute links using the cgi.host_name variable. It could also be used to take advantage of applications that assume the cgi.host_name variable is a constant, therefore developed applications don't take precautions to sanitize this variable before inserting it into a database could have issues. Just wanted to give the community a heads up on this. :) Regards, Paul Alkema http://paulalkema.com/ ~| 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:344500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
64-bit ColdFusion 8 Download
Hi, I'm migrating one of our ColdFusion 8 servers to a 64-bit server and was wondering if anyone knows of a place to download the 64-bit version of ColdFusion 8? Thanks, Paul ~| 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:343594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 64-bit ColdFusion 8 Download
Thanks dave. :) -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, April 07, 2011 9:39 AM To: cf-talk Subject: Re: 64-bit ColdFusion 8 Download I'm migrating one of our ColdFusion 8 servers to a 64-bit server and was wondering if anyone knows of a place to download the 64-bit version of ColdFusion 8? You should still be able to get all versions here: https://www.adobe.com/cfusion/tdrc/index.cfm?product=coldfusion8 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:343601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Charge for meetings
Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| 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:341876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd Code Showing up in URL
I've found that a lot of these issues are caused by either bots, or someone linking to a webpage and made a typo. Most likely bots. In your error reporting do you have anything that grabs the user agent of the error? I've found that looking at user agents can sometime help me to determine if it's a bot or not but you have to keep in mind that there are definitely tricky bots out there that emulate real people. One of the websites I maintain has around 800,000 pageviews a month. This website also has an error reporting like yours and I've found that the majority of them are just bots. I would just make sure you take proper security precautions on all of your code and you should be fine. -Original Message- From: David Moore [mailto:dgmoor...@hotmail.com] Sent: Friday, January 14, 2011 12:48 PM To: cf-talk Subject: Odd Code Showing up in URL I recently added an cferror to my websites and it has helped me discover a lot of issues I needed to fix. At the same time, I have some very odd code showing up and didn't know if it is something I should address or is it someone trying to hack into my websites. Here is an example: http://www.oconeemed.org/index.cfm?PageID=21ParentPageID=4NavID=4ServiceI D=-1%27PageText=off You will notice the ServiceID of -1%27 which should be an integer. It also did not come from a Search Engine, which is a whole other issue I have noticed that I did not before. I guess I am asking is if I should be concerned about this or is it just some kind of oddity. I am noticing it showing up on many of the websites I host. Thank you in advance, David G. Moore, Jr. ~| 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:340881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IP Address 1.1.1.1
I don't think this has anything to do with your CGI script. I would say it's most likely just a bot. If it was me, I would just exclude this IP from Google Analytics. I think this would solve your issue. :) http://www.google.com/support/analytics/bin/answer.py?hl=enanswer=55481 Regards, Paul Alkema http://paulalkema.com/ -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, December 07, 2010 11:46 AM To: cf-talk Subject: IP Address 1.1.1.1 On one of our sites Google Analytics is reporting lots of hits from IP 1.1.1.1 as a referral. It's also showing a very high bounce rate from that IP. I looked this up and saw a bunch of differing ideas on this, ranging from a dude in Australia to a bot attack, but one that comment that seemed vaguely possible was about this IP coming from CGI script used within a site. I am using CGI script to do 301 redirects (via CFLOCATION) and I'm wondering if this sounds like that may be the cause. Has anyone seen referrals from IP 1.1.1.1 or know what it may be from? Thanks. Robert Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:339888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Free ColdFusion Hosting
That link looks familiar. ; ) I found one place: http://www.cfmldeveloper.com/ but it's out of country (USA) which, I don't have a problem with, but at the same time I'm hesitant to just go anywhere with the way the world is today. -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Wednesday, November 24, 2010 1:41 PM To: cf-talk Subject: Re: Free ColdFusion Hosting IIRC Russ Michaels has something going to that effect on cfmldeveloper.com HTH G! ~| 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:339516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Free ColdFusion Hosting
Matthew, If it was me, I wouldn't poo-poo it just because it's hosted out of the country. If it's free, I wouldn't expect GREAT honest but it's free right!? I would think as long as your not looking to put anything that you want to keep secure on it IE; credit card data, SSN's, other people's passwords ect, that you'd be fine. If it was me I would just sign up, pay the £1.00 setup fee (don't know if you saw that or not) and if they charge you more than £1.00 than it's credit card fraud, file a dispute with your cc company which is really easy and you get your money back. If you do, do it, make sure you share your experience with everyone so we can see how it worked out for you. ;) Paul Alkema http://paulalkema.com/ ~| 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:339518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Performance Monitoring
Hi All, Does anyone know if there is any performance issues with enabling performance monitoring settings? This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. Is this setting ok to enable in a production environment? Thanks, Paul ~| 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:339451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Detect users based on country???
I've ran into this issue before and have found the best solution to detecting a county is by asking the customer for it via a modal window. EXAMPLES http://www.xerox.com/ http://www.edmundoptics.com/ I know some people really like using geo-location, but I've found this method to be not always accurate. I've found in the US is usually more accurate than overseas. -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Monday, November 22, 2010 5:41 PM To: cf-talk Subject: Re: Detect users based on country??? Use a public geo-location service: cfhttp method=get URL=http://ipinfodb.com/ip_query.php?ip=#cgi.REMOTE_ADDR#; result=response / Then use the response XML tree to extract the country or zip: cfset xmmm = xmlparse(response.filecontent) cfset countryname = xmmm.response.countryname.xmltext cfif countryname neq Canada div id=price#price#/div /cfif I wouldn't actually do it in this order because of the lag in http posts. I've had good luck with this method but it isn't perfect because web services can go down and then your checking system breaks. If the location service isn't working, then don't allow anyone to use the module you've built with the integrated geo-location service. Use cookies as you stated to keep from having to do this every time. ~| 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:339453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Performance Monitoring
I'm on ColdFusion 8. :) -Original Message- From: Wil Genovese [mailto:jugg...@trunkful.com] Sent: Tuesday, November 23, 2010 1:18 PM To: cf-talk Subject: Re: Performance Monitoring Paul, Which version of ColdFusion is running? Some settings in the CF8 and CF9 Enterprise edition may have some performance hit on high load servers. In rare cases the Server Monitor may have a large impact on performance with certain settings (Enable Memory Tracking) enabled. In general the Debug settings should be disabled on production servers be cause there is a performance hit. It's a small one and may never be noticed on minimally used sites. Highly used high load sites may experience performance issues with the Debug settings enabled. In my experience none of them will completely crash the server. Wil Genovese Owner / Sr Web Application Developer / Systems Administrator Trunkful Technologies, inc. http://www.trunkful.com 729 Dodd Road Saint Paul, MN 55107 | m: 651-894-4238 | wilg...@trunkful.com On Nov 23, 2010, at 10:35 AM, Paul Alkema wrote: Hi All, Does anyone know if there is any performance issues with enabling performance monitoring settings? This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. Is this setting ok to enable in a production environment? Thanks, Paul ~| 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:339474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
Hey Sean, Thanks, this doc looks great. It would be nice if we could get an updated version of this doc someday but for now this is a great point of reference. ;) Paul -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: Monday, November 15, 2010 7:44 PM To: cf-talk Subject: Re: Where to put your code On Mon, Nov 15, 2010 at 2:13 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Does anyone out there have any written coding standards or coding documentation that they would be willing to share? I would be interested in seeing what other development teams use as far as coding standards. Here's what my team developed / used back when I was at Macromedia: http://livedocs.adobe.com/wtg/public/ -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:339305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
What makes you think this? It looks to me like most files have a .html extension. I'm sure these html files are dynamic though, perhaps they're rendering ColdFusion in the html pages. http://www.codemonkeysteve.com/blog/2010/03/coldfusion-parsing-coldfusion-in -a-htm-extension-on-iis6/ I do agree that it seems silly to do this though. I would think that if a company is selling a product it seems like they should be using the product themselves and not try to mask that they are or are not using the product. I do know they have a lot of flex integration on the site. :) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, November 17, 2010 10:54 AM To: cf-talk Subject: Re: Where to put your code although a lot of what is adobe.com seems to be moving away from CF I noticed this the other day. Seems like Adobe isn't all that proud of CF. ~| 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:339316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
I think that when working on a team of programmers that are all working on the same applications or the same website that it's important to have a programming standard or a guide. I think this goes with any language be it web or desktop applications. I think that it's ok for programmers to have their own style of programming style and own methods to programming however when multiple programmers get together they should be writing applications in the same style using the same guides or else applications and websites looks and unprofessional. I also think it really helps the programmers to work together and be in sync with one another. Ie; if you have a guide of where to put code you can know exactly the location of a script if your teammate wrote it. Do I really think there is a right of wrong in the discussion of where you should put code? Not really. I just think that when working on a team of developers that it is necessary to have guides like these so that all programmers are working consistently. : ) Paul ~| 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:339230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
Thanks for your feedback. You make some good points. Does anyone out there have any written coding standards or coding documentation that they would be willing to share? I would be interested in seeing what other development teams use as far as coding standards. ~| 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:339240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where to put your code
I second this. : ) On Fri, Nov 12, 2010 at 8:05 PM, James Holmes james.hol...@gmail.comwrote: I'd argue that CF didn't allow for well written applications before CFCs came along. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 13 November 2010 02:16, Dave Watts dwa...@figleaf.com wrote: Functions existed well before CFCs - does that mean that well-written applications predating the use of CFCs are now poorly-written? ~| 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:339179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Where to put your code
Hi All, I recently had a discussion with some other programmers on my team dealing with where to put application code and when. This is a small little guide I wrote that I try to use and I wanted some second opinions on my coding logic. Thanks, Paul - When to put your code where. In my opinion this is the IDEAL location for code. Straight on CFM Page Should Contain: UI or presentation code. HTML, JavaScript, simple ColdFusion (IE; does var.foo exist output etc..). Should Not Contain: Application Logic. Processes or functions. Includes Should Contain: Code should contain same type of code as CFM pages however includes should be used to split large CFM pages into smaller segments. Should Not Contain: Application Logic. Processes or functions. Custom Tags Should Contain: Reusable UI or presentation code. HTML, JavaScript, simple ColdFusion. Code that's going to be used more than once. Should Not Contain: Application Logic. Processes or functions. CFC's Should Contain: Application Logic. Processes or functions. Should Not Contain: UI or presentation code. ~| 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:339132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
Oh yeah. Of course ideally we would be on an MVC framework but we can't do that due to internal reasons. This doc is for those not on an MVC. Don't want any non MVC haters to yell at me. Haha. Paul Alkema ~| 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:339133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
I agree with those additions. Thanks! -Original Message- From: Scott Stewart [mailto:webmas...@sstwebworks.com] Sent: Friday, November 12, 2010 10:46 AM To: cf-talk Subject: Re: Where to put your code I'd only modify it a little: Straight on CFM Page Should Contain: UI or presentation code. HTML, JavaScript, simple ColdFusion to implement UI/Presentation (IE; does var.foo exist output etc..). Should Not Contain: Application Logic. Processes or functions. Includes Should Contain: reusable ui code that doesn't require inputs (IE: headers, footers, sidebars, etc) Should Not Contain: Application Logic. Processes or functions. Custom Tags Should Contain: Reusable, Dynamic UI or presentation code. (IE generic headers that accept passed parameters for customization) HTML, JavaScript, simple ColdFusion. Code that's going to be used more than once. Should Not Contain: Application Logic. Processes or functions. CFC's Should Contain: Application Logic. Processes or functions. should not be dependent on any scoped variables Should Not Contain: UI or presentation code. On Fri, Nov 12, 2010 at 10:23 AM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I recently had a discussion with some other programmers on my team dealing with where to put application code and when. This is a small little guide I wrote that I try to use and I wanted some second opinions on my coding logic. Thanks, Paul - When to put your code where. In my opinion this is the IDEAL location for code. Straight on CFM Page Should Contain: UI or presentation code. HTML, JavaScript, simple ColdFusion (IE; does var.foo exist output etc..). Should Not Contain: Application Logic. Processes or functions. Includes Should Contain: Code should contain same type of code as CFM pages however includes should be used to split large CFM pages into smaller segments. Should Not Contain: Application Logic. Processes or functions. Custom Tags Should Contain: Reusable UI or presentation code. HTML, JavaScript, simple ColdFusion. Code that's going to be used more than once. Should Not Contain: Application Logic. Processes or functions. CFC's Should Contain: Application Logic. Processes or functions. Should Not Contain: UI or presentation code. ~| 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:339139 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
I work on a fairly large team for a large multi-million dollar ecommerce corporation. I can see if your building small application for small websites and you're not on a team of people working on the same website how it might not be ideal to have guidelines set up like these. I think in a team environment in order to avoid coding inconsistencies on large websites at least general guidelines are a must. :) -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, November 12, 2010 12:20 PM To: cf-talk Subject: Re: Where to put your code You cannot really apply such rules to everyone. If someone just has a very simple mostly flat, then using mvc frameworks and CFC's will probably be overkill and create 10 x more code is actually required. In those situations you are probably just going to use some cfm pages and maybe a few cfincludes for header, footer and menu etc. For large code-centric applications and when working within teams your rules work fine though. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.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:339142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where to put your code
Hm, I respectfully disagree with putting functions in cfm pages entirely no matter how it's being pulled. I think there's a place for functions and that's in cfcs. You say you have a lot of utility functions that don't need to be in a cfc. If you have a lot of them, why not just create a cfc called utility and stick them all in one cfc? Also, if you stick functions and include them most likely your talking to that function using scoped variables which as other have mentioned is usually a bad practice to do using functions. Paul -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Friday, November 12, 2010 12:54 PM To: cf-talk Subject: Re: Where to put your code My only exceptions to these would be: Includes Should Not Contain: Application Logic. Processes or functions. A lot of times (depending on the app) I stick functions (UDFs) in an include. I have a lot of utility functions that (arguably) don't really need to be in a cfc. Custom Tags Should Contain: Reusable, Dynamic UI or presentation code. (IE generic headers that accept passed parameters for customization) I generally use custom tags as views for encapsulation purposes. What happens in Vegas, stays in Vegas. Then I stick the aforementioned functions in the request scope or a stuct and/or array to pass into the views. G! -- Gerald Guido http://www.myinternetisbroken.com Wait. We can't stop here. This is bat country. -- HST ~| 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:339146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF (8.0.0) performance vs PHP (5)
I think the cfexecute tag is definitely not the faster cf tag ever. As an ex php programmer and a current ColdFusion programmer I do have to say that there is usually a speed benefit to php over ColdFusion however, I do have to say that I think the overall benefits to ColdFusion far outweigh the cons to ColdFusion over php. I personally have had very, very few server or speed issues on my ecommerce site, which receives over a million page views a month. Check out my article about php vs ColdFusion. http://paulalkema.com/post.cfm/php-vs-coldfusion Paul Alkema ~| 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:338871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion Search
Anyone have any ideas on this? -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Monday, November 01, 2010 4:46 PM To: cf-talk Subject: Coldfusion Search Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example pIf I searched for this text, It would return a result/p cfset variables.foo = however, If I search for this text it wouldn't return any results. / Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index. cfindex collection = fileIndex action=refresh type=path key=d:\my-websites-location\ urlpath=http://mywebsite/; extensions=.cfm, .cfml, .cfc recurse=Yes This is my search. cfsearch name = testSearch collection = fileIndex type=internet criteria = variables.foo / Any ideas? Thanks, Paul : ) ~| 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:338761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Search
Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example. pIf I searched for this text, It would return a result/p cfset variables.foo = however, If I search for this text it wouldn't return any results. / Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index.. cfindex collection = fileIndex action=refresh type=path key=d:\my-websites-location\ urlpath=http://mywebsite/; extensions=.cfm, .cfml, .cfc recurse=Yes This is my search. cfsearch name = testSearch collection = fileIndex type=internet criteria = variables.foo / Any ideas? Thanks, Paul : ) ~| 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:338731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: hostek.com - is anyone else experiencing extreme downtime today
My site seems to be doing well. I think my site's gone down maybe twice in the last two years. Which I think it pretty good considering I pay like 5 bucks a month and. -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Wednesday, October 27, 2010 7:53 AM To: cf-talk Subject: Re: hostek.com - is anyone else experiencing extreme downtime today On Wed, Oct 27, 2010 at 5:24 AM, Mike Little m...@nzsolutions.co.nz wrote: several of our sites have been down for at least 4 hours now. we think the problem appears to be their connection to mysql. even their own faq page has been down for ages with the following error... My sites seem to be OK. ~| 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:338613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: left outer join in query of query
Hi Nathan, Both cf8 and cf9 allow for left outer joins when doing normal queries however as far as I know query of query's does not support joins. On a side note though, my general rule of thumb is if I need to use a query of queries for anything other than changing the order of my structure, than I really need to evaluate my original SQL query and looped query of queries are big programming no no. Just my 2 cents.. : ) Paul Alkema http://paulalkema.com/ -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Monday, October 25, 2010 1:53 PM To: cf-talk Subject: left outer join in query of query All: I am on CF 8 now. Does anyone know if CF 9 supports left outer join in query of query? CF 8 doesn't allow left outer join. Nathan Chen ~| 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:338526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: left outer join in query of query
You may find this article useful. http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of .html Paul Alkema http://paulalkema.com/ -Original Message- From: Mahcsig [mailto:mahc...@mahcsig.com] Sent: Monday, October 25, 2010 4:43 PM To: cf-talk Subject: Re: left outer join in query of query You can actually use the old SQL syntax to do inner joins in a qoq, haven't gotten a left join to work though. this fails: cfquery dbtype=query name=tmp SELECT * FROM t1 inner join t2 ON t1.id = t2.id /cfquery this works though: cfquery dbtype=query name=tmp SELECT * FROM t1, t2 WHERE t1.id = t2.id /cfquery ~Mahcsig On Mon, Oct 25, 2010 at 1:35 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi Nathan, Both cf8 and cf9 allow for left outer joins when doing normal queries however as far as I know query of query's does not support joins. On a side note though, my general rule of thumb is if I need to use a query of queries for anything other than changing the order of my structure, than I really need to evaluate my original SQL query and looped query of queries are big programming no no. Just my 2 cents.. : ) Paul Alkema http://paulalkema.com/ -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Monday, October 25, 2010 1:53 PM To: cf-talk Subject: left outer join in query of query All: I am on CF 8 now. Does anyone know if CF 9 supports left outer join in query of query? CF 8 doesn't allow left outer join. Nathan Chen ~| 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:338529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cant access cf administrator
I know on windows server you have to set up a virtual directory to C:\inetpub\wwwroot\CFIDE called CFIDE in order for the administrator to be viewed. Paul -Original Message- From: Jay Birdsell [mailto:john_birds...@hotmail.com] Sent: Tuesday, October 19, 2010 11:33 AM To: cf-talk Subject: cant access cf administrator HI I have just installed CF9 on a Solaris 10 box with weblogic 11g, when i try to log into cf administrator, I get a 500 error, cf itself is running as I can pull the log in pages for all my apps, of course when actually log in i get an error, as expected, because I have not configured anything. anyone have an idea what could be causeing the 500 error? tia jb ~| 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:338321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF jQuery Grid
I LOVE ColdFusion! But.. I think that the code in asp.net is usually easier to look at than ColdFusion as with asp.net by default the user interface and the domain logic are separated. I know CF has MVC's that help with this, but I'm talking CF out of the box here. That's my 2 cents. :) Paul Alkema http://paulalkema.com/ -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Friday, October 15, 2010 11:44 PM To: cf-talk Subject: Re: CF jQuery Grid God asp is ugly to look at. ??? ASP.net looks just like imported CF custom tags , C# looks just like cfscript and VB looks just like... well.. VB looks like VB. Actually working with COM objects with CF reminds me of VB. G! On Fri, Oct 15, 2010 at 8:04 PM, Michael Grant mgr...@modus.bz wrote: God asp is ugly to look at. On Fri, Oct 15, 2010 at 7:16 PM, Andrew Scott andr...@andyscott.id.au wrote: That is very true about IE9, however ExtJS doesn't have any problems with IE9 at this stage. jQuery I don't use enough of to make a judgement call. As for being outside of the .Net world I mean with the likes: http://demos.telerik.com/aspnet-ajax/controls/examples/default/defaultcs.asp x Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Saturday, 16 October 2010 10:10 AM To: cf-talk Subject: Re: CF jQuery Grid Given that IE9 was first released in a public beta exactly one month ago, I think that Dojo can be forgiven for not supporting it yet. I'm also not sure what you mean by outside the .Net world. If you are looking at javascript, .Net MVC bundles JQuery. If you are looking at a control, there are some decent ones, but for web pages they are all ActiveX which means they won't be cross-browser or cross-platform. Cheers, Judah ~| 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:338287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What difference does the parenthesis make?
In mssql there shouldn't be a difference in the records returns. I would double check that the input variable #law.paid# is the same in both of these scenarios and also that none of these queries are cached. -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Monday, October 18, 2010 3:17 PM To: cf-talk Subject: What difference does the parenthesis make? What's the difference between 1. -- SELECT nl_id FROM vw_newsletters WHERE (paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer /) AND (nl_status = 'published' OR nl_status = 'archived') 2. -- SELECT nl_id FROM vw_newsletters WHERE paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer / AND (nl_status = 'published' OR nl_status = 'archived') #1 returns the correct records #2 returns nothing Not sure what difference the first set of parenthesis makes in #1 ~| 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:338290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF jQuery Grid
I don't know if this is what you're looking for or not, but I thought I'd at least mention it. jQuery version of cfgrid. http://www.webtrenches.com/post.cfm/jquery-replacements-for-cfgride-cfwindow e-and-cftooltip Demo http://www.webtrenches.com/cfjq/ -Original Message- From: Doug Ford [mailto:doug.e.f...@gmail.com] Sent: Thursday, October 14, 2010 8:12 PM To: cf-talk Subject: CF jQuery Grid Hi Folks - I am hoping that some of you might have used a Grid based plug in into your work and have some experience. I have been using Ingrid for a while but there is a problem with it. If you put the Ingrid table/grid within a DIV and use any type of positioning in that DIV, the divider bar causes problems, and sometimes locks up the browser window. It's nice for relatively simple instances, but it has limitations when used within a nicely laid out site. Now then, here are my requirements - 1) I need to pass a CLASS TITLE attribute to different random cells to display tool tips. So any plug in that generates a grid with JSON and XML only is out of the mix. (So this might nix jqGrid from the list) 2) I need to be able to have paging controls, where I can either read in an HTML table generated on the backend, or pull back the data to generate my table but CLASS TITLE attributes have to be included. 3) I need to be able to expand the grid object beyond the screen's edge if need be. The data is truly dynamic. One time the page will show 4 columns, the next 20. Probably not, but I have to prepare for the worst. Any and all ideas are appreciated. Thanks, Doug ~| 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:338231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Subversion Software
What do you all use to manage your svn on the client side? IE; tortoiseSvn, Dreamweaver, subeclipse? -Original Message- From: enigment [mailto:enigm...@gmail.com] Sent: Thursday, October 14, 2010 7:46 AM To: cf-talk Subject: Re: Subversion Software +1 VisualSVN Dave ~| 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:338168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Subversion Software
Hey All, I'm looking to set up a subversion server and was wondering what types of subversion servers you all have set up and what software do you use to manage it? Paul Alkema ~| 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:338134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL ColdFusion Encryption
Hi, I know how to encrypt data using ColdFusion using AES_128. I also know how to encrypt data using MSSQL AES_128. Does anyone know if it's possible to encrypt data in ColdFusion using AES_128, then decrypt the string in MSSQL? I've played around with it a lot and can't seem to figure it out. Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFID integer?
Hi All, Does anyone have any idea why one server would give me a session.cftoken that's an integer and the other would give me a session.cftoken that's a alpha-numeric? It's seems to be very consistently this way. EXAMPLE SERVER A Session.cftoken = 316809 Server B Session.cftoken = 8a30c3300f9be8f6-858271FD-1D10-FABB-008190F5BC0804CA I'm assuming that there is a setting in the ColdFusion administrator I'm missing somewhere or something. Any ideas? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFID integer?
Oh, oops. I just figured it out. In the ColdFusion administrator, if the setting Use UUID for cftoken is unchecked than the cftoken will be an integer. Thanks, Paul -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Wednesday, August 18, 2010 10:19 AM To: 'cf-talk@houseoffusion.com' Subject: CFID integer? Hi All, Does anyone have any idea why one server would give me a session.cftoken that's an integer and the other would give me a session.cftoken that's a alpha-numeric? It's seems to be very consistently this way. EXAMPLE SERVER A Session.cftoken = 316809 Server B Session.cftoken = 8a30c3300f9be8f6-858271FD-1D10-FABB-008190F5BC0804CA I'm assuming that there is a setting in the ColdFusion administrator I'm missing somewhere or something. Any ideas? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 Developer on Windows 7 Home Premium?
I've run CF9 on Windows 7 with absolutely no issues at all. Paul Alkema T:@paulalkema -Original Message- From: Matt Robertson [mailto:websitema...@gmail.com] Sent: Tuesday, August 03, 2010 3:43 PM To: cf-talk Subject: CF9 Developer on Windows 7 Home Premium? I'm looking at buying a couple of laptops that will get some light development use. The trouble I am seeing is every laptop whose feature set I am interested in is running Win7 Home Premium. If I am running CF9 developer on them and would only be using the development web server, will CF9 run on it or will the installer kick me out when it sees the Win version I'd be running? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HTML spec for mobile devices
1+ - I attended this, He did an excellent job, very informative. T:@paulalkema -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, August 02, 2010 1:25 PM To: cf-talk Subject: RE: HTML spec for mobile devices You might also head over to Dan Vega's blog. He just gave a mobile session at CFUnited that was really well attended: http://www.danvega.org/blog/ -Original Message- From: Marc Funaro [mailto:subscripti...@advantex.net] Sent: Monday, August 02, 2010 9:14 AM To: cf-talk Subject: SOT: HTML spec for mobile devices I'm looking for a basic web resource coover what would be considered best practices for building a website that will be viewed on mobile devices... a general reference guide/best practices document, that might cover (x)html, css, etc... I can't seem to find the right keywords to Google with. The last mobile xml/html spec I could find was from 2001. I knwo i could just wing it and use basic html and go from there, but I'd rather follow at least a proposed standard, if there is one. Thanks for any links you can provide! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HTML spec for mobile devices
To summarize it, I would look into mobile js frameworks like Sencha (http://www.sencha.com/). Also, to get an idea of screen resolution look at your Google analytics stats they should give you an idea of what mobile browsers are looking at your site and what the screen resolutions are. -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, August 02, 2010 1:25 PM To: cf-talk Subject: RE: HTML spec for mobile devices You might also head over to Dan Vega's blog. He just gave a mobile session at CFUnited that was really well attended: http://www.danvega.org/blog/ -Original Message- From: Marc Funaro [mailto:subscripti...@advantex.net] Sent: Monday, August 02, 2010 9:14 AM To: cf-talk Subject: SOT: HTML spec for mobile devices I'm looking for a basic web resource coover what would be considered best practices for building a website that will be viewed on mobile devices... a general reference guide/best practices document, that might cover (x)html, css, etc... I can't seem to find the right keywords to Google with. The last mobile xml/html spec I could find was from 2001. I knwo i could just wing it and use basic html and go from there, but I'd rather follow at least a proposed standard, if there is one. Thanks for any links you can provide! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to dispaly flash video in coldfusion pages
Hi Kamru, This is really more of a web development issue than a ColdFusion issue as ColdFusion. It shouldn't matter what ColdFusion server your on. This can be done multiple ways, you could create a player in flash or use a flash template however I would check our flowplayer, it's a really robust flash movie player that's built in jQuery. Very cool. http://flowplayer.org/index.html Paul Alkema http://paulalkema.com t: @PaulAlkema -Original Message- From: Kamru Miah [mailto:k.m...@csl.gov.uk] Sent: Thursday, July 22, 2010 10:58 AM To: cf-talk Subject: How to dispaly flash video in coldfusion pages Hello, Could some please advise me if it's possible to play MPEG video files on Coldfusion 8 pages, perhaps after conversion to Shock Wave Flash (.swf) files? It would be nice to have the user controls like Youtube as well! Thanks in anticipation. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfwindow - dynamically setting window title using javascript?
You could use ColdFusion.Window.create. Example cfajaximport tags=cfwindow script type=text/javascript url = 'http://www.google.com/'; title = 'This is my title'; name = 'newWindow'; ColdFusion.Window.create(name, title, url,{initshow:false}); /script a href=javascript:ColdFusion.Window.show('newWindow');Show Window/a -Original Message- From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] Sent: Wednesday, July 07, 2010 9:08 AM To: cf-talk Subject: cfwindow - dynamically setting window title using javascript? Is there a way to dynamically set the cfwindow title using JavaScript? What I mean is, I have the cfwindow's title attribute set to a fairly generic value. Once I display the window, it always contains dynamic data, and I would like the cfwindow title to reflect the dynamic content. I would assume that this would be done via a Javascript snippet from within the cfwindow content display page. Thanks, Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Trouble with international characters
Hi, What's your data type for the sql column that your trying to insert this data into? If your inserting Unicode characters into varchar column you should change the datatype to nvarchar. Also, when using unicode in ColdFusion with cfqueryparam's I would confirm that String Format is checked in your ColdFusion administrator. It should be noted however that if this is enabled for your main dsn that it could possibly cause performance issues. I have two datasources one called nMainDns and another called mainDns. The nMainDns is used to insert Unicode statements while using cfqueryparam's while the other is used for select statements or stored procedures. Paul Alkema http://paulalkema.com/ On Mon, Jul 5, 2010 at 1:40 PM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: Oh, and here's the code for my SQL that's inserting the data: cfquery name=insertRecords datasource=holocaustlearning INSERT INTO tblHLMapLocations(name, description, latitude, longitude, locationIsApproximate, active) VALUES (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim( workingset.name)#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#stripHTML(trim(workingset.description))#, #trim(workingset.latitude)#, #trim(workingset.longitude)#, cfqueryparam cfsqltype=CF_SQL_BIT value=#locationIsApproximate(workingset.description)#, cfqueryparam cfsqltype=CF_SQL_BIT value=false); /cfquery 2010/7/5 Pete Ruckelshaus pruckelsh...@gmail.com I am using CF to import data from an Excel spreadsheet to an MS SQL Server 2005 database. Salient points: Characters are showing properly in the .XLSX file; text fields in the SQL server database are all nvarchar or ntext; I am using cfprocessingdirective pageencoding=UTF-8 / at the top of the page that is processing this page; and, finally, I am using cfspreadsheet to read the spreadsheet and put it into a query object. Here's the data processing code: cffile action=UPLOAD destination=#getTempDirectory()# filefield=uploadxls nameconflict=MAKEUNIQUE cfspreadsheet action=read src=#cffile.serverdirectory#\#cffile.serverfile# sheetname=sheet1 query=getData cfloop query=getdata startrow=1 endrow=1 cfset workingset = queryNew(#getdata.col_1#,#getdata.col_2#,#getdata.col_3#,#getdata.col_4#,varchar,varchar,varchar,varchar) cfset workingset_col1 = getdata.col_1 cfset workingset_col2 = getdata.col_2 cfset workingset_col3 = getdata.col_3 cfset workingset_col4 = getdata.col_4 /cfloop cfloop query=getdata startrow=2 cfset t1 = queryAddRow(workingset) cfset t1 = querySetCell(workingset, workingset_col1, stripOuterQuotes(getdata.col_1)) cfset t1 = querySetCell(workingset, workingset_col2, stripOuterQuotes(getdata.col_2)) cfset t1 = querySetCell(workingset, workingset_col3, stripOuterQuotes(getdata.col_3)) cfset t1 = querySetCell(workingset, workingset_col4, stripOuterQuotes(getdata.col_4)) /cfloop hr / cfquery name=workingset dbtype=query SELECT name, description, latitude, longitude FROM workingset ORDER BY name /cfquery Now, the problem that I am having is that SOME (and not all) of the international characters are not showing up properly. For instance: These show up properly: GroÃraming SB, Flossenbürg, MiroÅ¡ov Labor Camp, Munkács Ghetto, TerezÃn These do NOT show up properly (correct versions in parentheses): Brn?nec (BrnÄnec) Auschwitz (Che?mek subcamp) - (Auschwitz (CheÅmek subcamp)) Che?mno Extermination Camp - (CheÅmno Extermination Camp) Soldau (Dzia?dowo) Concentration Camp - (Soldau (DziaÅdowo) Concentration Camp) In case you're curious, I teach high school English and am working on a Holocaust Location mapping project for my Holocaust Literature class. Does anyone have any ideas as to why some international characters are making it through just fine, but others are getting munched? This is really the first time I've worked with anything beyond the basic Latin character set. Thanks, Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Vote ColdFusion
Hi All, So I've been a member of this Linux forum for awhile now and I recently came across a poll on the forum called The best languages. I know, I know how long are people going to debate this; but the one thing that gets me is ColdFusion isn't even on the list. I've made a post to complain about this and I received some crap about how CF isn't a good language. I just thought it might be nice to share with the Linux community how great CF is and why it should be added to this list of The best languages. This is a very popular Linux board and is read by many. http://www.linuxquestions.org/questions/programming-9/your-opinions-of-the-b est-combination-of-programming-languages-to-learn-813373/page3.html Best Regards, Paul Alkema http://paulalkema.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Order By question
I secont John's SQL. To expand explain further see my example. SELECT * FROM folks ORDER BY CASE WHEN last_name = 'Smith' OR last_name = 'Jones' THEN 0 ELSE last_name END Paul Alkema http://paulalkema.com/ -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, June 30, 2010 3:09 PM To: cf-talk Subject: Re: Order By question Something like... select last_name from table order by case ID when #ID1# then 0 when #ID2# then 0 else 1 end, last_name On Wed, Jun 30, 2010 at 2:02 PM, Les Mizzell lesm...@bellsouth.net wrote: Not 100% sure how to do this... Need to return a list of folks ordered by last_name (no problem), EXCEPT for 2 of them. They need to be LAST regardless of their last names (problem)... Perhaps something with their 2 ID numbers? Ideas? __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334982 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Order By question
I love how almost every question asked on this list will eventually turn into some kind of debate. It's great. :) -Original Message- From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneeg...@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Wednesday, June 30, 2010 5:03 PM To: cf-talk Subject: Re: Order By question I respectfully disagree with this approach. Doing it in the db will be much faster. Not so sure: If the query has to be ordered by the name, it could use an internal index. If it has to be sorted by some artificial column, there is no index and the query could be much longer. So IMO this approach may be the best, especially if the two exceptions have to be added at the end of the query. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
Are your integer fields datatype int in your database? I think a similar error could occur if your integer fields were changed to varchar or a different non-integer based field. Paul Alkema http://paulalkema.com/ -Original Message- From: Brad Wood [mailto:b...@bradwood.com] Sent: Thursday, June 24, 2010 9:57 PM To: cf-talk Subject: Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes out It's a bit more code, but if you switch to having a cfargument tag for each parameter and enforce the type there, you can pass in your struct as an argument collection. You'll get a more meaningful error that way. Sent from my HTC on the Now Network from Sprint! - Reply message - From: Marc Funaro subscripti...@advantex.net Date: Thu, Jun 24, 2010 5:43 pm Subject: Seriously PO'd - cfqueryparam and/or struct dereference flakes out To: cf-talk cf-talk@houseoffusion.com The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Shopping carts
@jonah, Your site looks excellent. Good work. Paul Alkema http://paulalkema.com/ -Original Message- From: jonah blossom [mailto:jonah@creori.com] Sent: Thursday, June 24, 2010 9:13 PM To: cf-talk Subject: Re: CF Shopping carts @Kevin, I feel that this is one area that is completely overlooked in the CF world-- Especially since OO was introduced to CF in MX. So true. When I was looking for a ecommerce solution several years ago, I evaluated all the current offerings and joined the CFCommerce google group, etc. I wasn't finding anything remotely like what I needed, so wrote a solution. I'm now at the point of opening it up for others to use and am evaluating business model and licensing options. (Here's a live example: https://store.apolisactivism.com/) If you'd like to talk more here or offline let me know. Cheers, .jonah ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Is it time for Adobe to Rebrand Cold Fusion?
RapidFusion! Because developing is so rapid compared to developing in other languages. haha -Original Message- From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneeg...@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Friday, June 25, 2010 3:13 PM To: cf-talk Subject: Re: Is it time for Adobe to Rebrand Cold Fusion? Java Fusion Please NO ! Enough Java con-fusion with Java and Javascript. ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdot.net (was: CF vs. ASP.Net)
@Jose, I think that cfdot.net looks excellent. Thank you for doing this for both the CF and ASP.NET community's. @hatton, I prefer C# over Visual Basic because of two reasons. 1. C# Has More Jobs available a. http://www.careerbuilder.com/Jobseeker/Jobs/JobResults.aspx?SB%3Asbkw=C%23 - 2,399 jobs found b. http://www.careerbuilder.com/Jobseeker/Jobs/JobResults.aspx?SB%3Asbkw=Visual +Basic - 1,568 jobs found 2. On average C# developers make more money. a. http://www.indeed.com/salary/VB-Net-Developer.html b. http://www.indeed.com/salary?q1=C%23+Developer Paul Alkema http://paulalkema.com/ -Original Message- From: C. Hatton Humphrey [mailto:chumph...@gmail.com] Sent: Tuesday, June 22, 2010 8:16 PM To: cf-talk Subject: Re: cfdot.net (was: CF vs. ASP.Net) Im not trying to nitpick, I only noticed them (except for Coldfusion... that usually stands out to me) because I sent the link to my colleagues along with the text from the home page as a description for the link. Two things that bug me - 1. It's C# which is one code-behind language for .NET. I have yet to have someone give me a quantifiable performance-based reason why it better than other languages in the family. 2. The .NET version does not include the ASP.NET part of the equation. For example: http://www.cfdot.net/cfdot/Pages/CodeDetail.aspx?id=7 (CFOutput) the .NET code is simply setting the .Text property of a text box. Where's the creation of the object? It's a great concept but as implemented it only confuses the whole CF vs .NET conversation. Hatton ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdot.net
I agree with Eric. I think this site's purpose is to help CFML programmers understand C# from a CFML perspective. Not try to prove that CFML is better than C#. Paul Alkema http://paulalkema.com/ -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Wednesday, June 23, 2010 3:28 PM To: cf-talk Subject: Re: cfdot.net Calling him dishonest is very short sighted on your part (to say the least!). Has the thought occurred to you that perhaps the reason there was so much extra code in the .Net example was because he's not a seasoned .Net developer? I know I certainly wouldn't know the absolute best way to do something when just transferring over to a new language. I'm willing to bet there are many seasoned .Net developers who would make plenty of rookie mistakes when just starting out with CF. Perhaps instead of jumping to conclusions and making accusations, you should offer to help him clean up his examples so they are more accurate. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Matthew Small wrote: All language religion aside - it's not a fair comparison, it's biased towards CF. You should be more honest in your comparisons if you expect anyone to take it seriously. Example: CFEXECUTE: CF: cfexecute name=C:\WinNT\System32\netstat.exe /cfexecute ASP.NET 01.using System; 02.using System.Drawing; 03.using System.Collections; 04.using System.ComponentModel; 05.using System.Windows.Forms; 06.using System.Data; 07.using System.Diagnostics; 08. 09.... 10. 11.//Declare and instantiate a new process component. 12.System.Diagnostics.Process process1; 13.process1= new System.Diagnostics.Process(); 14. 15.//Do not receive an event when the process exits. 16.process1.EnableRaisingEvents = false; 17. 18. 19.//The /C Tells Windows to Run The Command then Terminate 20.string strCmdLine; 21.strCmdLine = /C netstat ; 22.System.Diagnostics.Process.Start(CMD.exe,strCmdLine); 23.process1.Close(); All that is actually needed is: System.Diagnostics.Process.Start(netstat.exe); All of the other stuff is extraneous. The need for the using statements is negated by the fully-qualified name for the method. The object process1 isn't used at all for the actual execution. Passing the netstat.exe executable to the cmd.exe process is ridiculous - you could do the same with CFEXECUTE. Adding in extra string arguments just builds up the amount of code you want to display. And FYI: this one line of code can be executed in the .aspx page: % System.Diagnostics.Process.Start(netstat.exe) % There are numerous similar examples on your website. It's a dishonest misrepresentation. - Matt Small This is pretty sweet Jose. Thanks for taking the time to create this site! An excellent resource indeed. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions On 06/22/2010 06:47 AM, Jose Diaz wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334776 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Cfwindow
Hi, Does anyone know if there is any possible way to close all open cfwindows when a new cfwindow is opened? I would like to have only one cfwindow open at a time. Regards, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFContent failing on large files since moving to ColdFusion 9
Did you restart the ColdFusion service after making this change? Increasing the Maximum JVM Heap Size doesn't take effect until the cf service is restarted. How much disk space is left on your server? How much ram does your server have? -Original Message- From: Daniel Mackey [mailto:dmac...@gmail.com] Sent: Tuesday, June 22, 2010 10:39 AM To: cf-talk Subject: Re: CFContent failing on large files since moving to ColdFusion 9 Unfortunately changing the heap (to 1024) didn't make a blind bit of difference :-( Anyone got any suggestions on a possible work around? Dan. On Tue, Jun 22, 2010 at 3:24 PM, Daniel Mackey dmac...@gmail.com wrote: That's interesting. I don't get any messages logged and the server stays up I might give the heap space a lash and see I'm always confused as to where to set the heap, perma and all that jazz and what effects it all has Dan. On Tue, Jun 22, 2010 at 3:11 PM, Tom Chiverton tom.chiver...@halliwells.com wrote: Update: I now can't get anything to work on the box, because : Error,jrpp-15,06/22/10,15:10:25,billpack,Java heap space The specific sequence of files included or processed is: /home/chivertont/workspace/billpack/webroot/t.cfm'' java.lang.OutOfMemoryError: Java heap space Of course a swift bounce of CF fixes that, but I wonder if you could try increasing you heap size to beyond the file size and see what happens ? -- Tom Chiverton Helping to greatly seize B2B mission-critical compelling niches as part of the IT team of the year 2010, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Pathing Problem
Make sure that the user that the web server is running has access to the E drive. If you remote into the box and you have access to it doesn't mean that the user running the server has access to it. Paul -Original Message- From: Richard Steele [mailto:r...@photoeye.com] Sent: Monday, June 21, 2010 9:14 AM To: cf-talk Subject: Pathing Problem Our images reside on a separate drive e:/images. Our website is on c:\inetpub\wwwroot. How do I show the images on the e drive? Adding a virtual directory images in IIS and having img src in our code point to e:\images doesn't seem to work. Thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 CSS Reset Warning
Hi All, I just upgraded one my old sites to CF9 and was surprised all of a sudden to see some changes in formatting on some pages but not others. IE; strong tags not bolding, h1's looking different than previously and other issues as well. After some investigating I found the issue, apparently CF9's ext framework has a built in CSS reset. See the code below. File: CFIDE/scripts/ajax/resources/ext/css/ext-all.css html,body,div,dl,dt,dd,h1,h2,h3,h4,h5,h6,pre,form,fieldset,input,p,blockquot e,th,td{margin:0;padding:0;} img,body,html{border:0;} address,caption,cite,code,dfn,em,strong,th,var{font-style:normal;font-weight :normal;} //ol,ul {list-style:none;} caption,th {text-align:left;} //h1,h2,h3,h4,h5,h6{font-size:100%;} q:before,q:after{content:'';} I know, this is something that I should have probably been doing already and strong tags are deprecated, but still. If I wanted to do a css reset, I would do a css reset and wouldn't expect a ColdFusion upgrade to do it for me. Note: to make it more odd, this only effects pages that are using ColdFusion tags that use the ext framework like cfgrid, cfwindow, cftooltip ect. Best Regards, Paul Alkema http://paulalkema.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion 9 CSS Reset Warning
Ah, ok. I Googled it and didn't find much. Maybe I just didn't search the correct thing. Anyway, I fixed it by just going into the file on the server and commenting out the reset. Don't know if that was the correct thing to do or not, but it fixed it for me and my ajax tags seem to be ok. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, June 18, 2010 9:59 AM To: cf-talk Subject: Re: ColdFusion 9 CSS Reset Warning Yep - this is a known issue. I just saw a blog entry on it a little while ago - and it had a good workaround too. Give me a minute to dig it up. On Fri, Jun 18, 2010 at 8:56 AM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I just upgraded one my old sites to CF9 and was surprised all of a sudden to see some changes in formatting on some pages but not others. IE; strong tags not bolding, h1's looking different than previously and other issues as well. After some investigating I found the issue, apparently CF9's ext framework has a built in CSS reset. See the code below. File: CFIDE/scripts/ajax/resources/ext/css/ext-all.css html,body,div,dl,dt,dd,h1,h2,h3,h4,h5,h6,pre,form,fieldset,input,p,blockquot e,th,td{margin:0;padding:0;} img,body,html{border:0;} address,caption,cite,code,dfn,em,strong,th,var{font-style:normal;font-weight :normal;} //ol,ul {list-style:none;} caption,th {text-align:left;} //h1,h2,h3,h4,h5,h6{font-size:100%;} q:before,q:after{content:'';} I know, this is something that I should have probably been doing already and strong tags are deprecated, but still. If I wanted to do a css reset, I would do a css reset and wouldn't expect a ColdFusion upgrade to do it for me. Note: to make it more odd, this only effects pages that are using ColdFusion tags that use the ext framework like cfgrid, cfwindow, cftooltip ect. Best Regards, Paul Alkema http://paulalkema.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion 9 CSS Reset Warning
Thanks Ray, This was very helpful. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, June 18, 2010 10:05 AM To: cf-talk Subject: Re: ColdFusion 9 CSS Reset Warning http://nm1m.blogspot.com/2009/11/cfwindow-css-bug-workaround.html On Fri, Jun 18, 2010 at 8:59 AM, Raymond Camden rcam...@gmail.com wrote: Yep - this is a known issue. I just saw a blog entry on it a little while ago - and it had a good workaround too. Give me a minute to dig it up. On Fri, Jun 18, 2010 at 8:56 AM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I just upgraded one my old sites to CF9 and was surprised all of a sudden to see some changes in formatting on some pages but not others. IE; strong tags not bolding, h1's looking different than previously and other issues as well. After some investigating I found the issue, apparently CF9's ext framework has a built in CSS reset. -- === Raymond Camden, ColdFusion Jedi Master Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334650 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 Developer Edition - IP Addresses
Hi, Does anyone know how to edit the allowed allocated IP addresses for the CF9 developer edition license? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 Developer Edition - IP Addresses
That did it. Thanks. -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Wednesday, June 16, 2010 9:57 AM To: cf-talk Subject: Re: CF9 Developer Edition - IP Addresses On Wed, Jun 16, 2010 at 6:52 AM, Paul Alkema paulalkemadesi...@gmail.comwrote: Does anyone know how to edit the allowed allocated IP addresses for the CF9 developer edition license? AFAIK, not configurable. The allowed addresses are 127.0.0.1, and whatever the first 2 addresses that hit the server are. You can reset them by restarting the CF service, but you can't configure which 2 external addresses they are. -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Avoiding SQL deadlocks
I've found this article on SQL deadlocks extremely helpful. Reducing SQL Server Deadlocks http://www.sql-server-performance.com/tips/deadlocks_p1.aspx Paul Alkema http://paulalkema.com/ -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, June 09, 2010 11:15 PM To: cf-talk Subject: RE: Avoiding SQL deadlocks Even in a larger application if, for example, you are supported 150k users against a database. Say there is regular uniform logging going on - say search results or whatever. Whether the code is in different files or not if insert update queries are being run against the same tables you may suffer DB performance issues (including deadlocks). It's not wether the code is split - it's how the DB is being used and how much pressure is put on shared resources. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Wednesday, June 09, 2010 10:03 PM To: cf-talk Subject: RE: Avoiding SQL deadlocks In a smaller app where there is only one piece of code that performs the actions that are causing deadlocks, sure. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, June 09, 2010 7:28 PM To: cf-talk Subject: Re: Avoiding SQL deadlocks Since there is no deadlock error until a deadlock exists, the error you reported is most likely the victim and not the culprit. Of course it could have caused it then the same page was hit again and reported the error. In most CF applications with deadlocks that I've seen, the same code run concurrently is usually the cause of the deadlock. That is, there's a single script being run by multiple users, and that causes the deadlock. 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
List Of Custom Tags
Is there any possible way to pull a list of all custom tags available? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion and .NET Web Services running WSE 3.0
James, I too have had issue connecting to Exact Target's poorly documented API. I did manage to figure out how to add a user via an older API though. http://paulalkema.com/post.cfm/how-to-subscribe-a-user-in-exact-target-via-t heir-api Regards, Paul Alkema -Original Message- From: Dan O'Keefe [mailto:dan.oke...@gmail.com] Sent: Sunday, June 06, 2010 2:36 PM To: cf-talk Subject: Re: ColdFusion and .NET Web Services running WSE 3.0 James, I would be interested in participating on this as well as I have a current need for the WS-Security piece with ExactTarget API. Dan On Sat, Jun 5, 2010 at 7:13 AM, James Holmes james.hol...@gmail.com wrote: OK, I'll finish up the webservice wrapper CFC on which I'm working and then look at what's necessary to add the digest password type (currently I just have the text type working) and any other parts of WS-Security that are possible in CF. The code will work in CF8 and higher, although parts of it will probably work in CF7 (since that's when we got addSoapRequestHeader()). mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 5 June 2010 21:15, Phillip Duba phild...@gmail.com wrote: James, I know I will definitely need something like that in the future. While this project went the .NET route, there are two follow-on projects that will most likely be needed, one requested by my group, so I know I'll be working on at least one more integration using WS-Securit. Thanks, Phil On Sat, Jun 5, 2010 at 8:12 AM, James Holmes james.hol...@gmail.com wrote: Coincidentally, I've just finished developing the code necessary to do a basic WS-SECURITY call in CF, using standard cf webservices code (i.e. no extra Java jars or other external dependencies). If people need this sort of thing, let me know because I'm thinking of starting an open source project to flesh it out. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 5 June 2010 01:04, Phillip Duba phild...@gmail.com wrote: It did for the pure web services, not for the HTTP Post method (not recommended for production). It was a proof-of-concept under a tight deadline so I didn't have time to follow the web service all the way to the conclusion I would need for production. I did find a few blog posts that got me pointed in the direction I probably needed to go. The specific implementation was the Username Token profile. I eventually got to receiving an error of cannot authorize/validate the username token. It probably had to do with timestamps and the makeup of the token itself. Again, I just ran out of time and the project was chosen to be done by another organization internally doing .NET work for which the WS-Security implementation was seamless using MS's WSE library. It wasn't the deciding factor, but it was definitely a differentiator, Phil On Fri, Jun 4, 2010 at 12:53 PM, Dan O'Keefe dan.oke...@gmail.com wrote: Philip, Did you authorization require WS-Security? Dan -- Dan O'Keefe On Thu, Apr 29, 2010 at 12:13 PM, Phillip Duba phild...@gmail.com wrote: Dave, thanks for the response. I've gone to executing the request using CFHTTP, creating the soap:Header tag and building it as I go through the WSE spec and examples. I've gotten to the point that I get unauthorized so that's where I'm at now. I may have to use CFHTTP to do it, but we'll see. Thanks again, Phil ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Builder Stored Procedures
Hi, Does anyone know if there's a way to view a databases stored procedures from inside CF builder's RDS Dataview pane? From what I see it displays tables, views, synonyms and system tables but no way to display stored procedures for easy use. This seems like a major flaw to me. Any ideas? Paul Alkema http://paulalkema.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to delete a post in House of fusion?
If your name or company is on something you want to get off Google, I would instead of working to deleting it, get other content out on the web with your name or company that would appear before it. Also just a note, the company I work for won't hire a developer unless their name is our on development sites, either asking or answering questions. -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Thursday, May 27, 2010 1:49 PM To: cf-talk Subject: Re: How to delete a post in House of fusion? There is no way to delete it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 Hosting
I've been using hostek for awhile and really like it. http://hostek.com/ One of the best features I think is that you can run cf9 applications, asp.net applications and php applications all from 1 hosting package which is awesome since I develop in all of those languages. Also they're CF package is only $5/month which is awesome. One down side I think is the hosting control panel isn't all that great, but it works well and does that I want. Regards, Paul Alkema http://paulalkema.com/ -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Thursday, May 20, 2010 11:10 AM To: cf-talk Subject: Re: CF 9 Hosting http://www.viviotech.net/ mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 20 May 2010 06:10, Kelly Matthews ke...@webdiva.org wrote: Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 Hosting
Um, that's not good. That's odd, I've never had my site go down. Oh well, good luck anyway. :) -Original Message- From: Kelly Matthews [mailto:ke...@webdiva.org] Sent: Thursday, May 20, 2010 11:41 AM To: cf-talk Subject: Re: CF 9 Hosting Actually while hostek's prices are great, the fact that they go down 2-3 times PER day is far too much for my client, which is why I'm looking to move. Should have mentioned anyone but hostek. I've been using hostek for awhile and really like it. http://hostek.com/ One of the best features I think is that you can run cf9 applications, asp.net applications and php applications all from 1 hosting package which is awesome since I develop in all of those languages. Also they're CF package is only $5/month which is awesome. One down side I think is the hosting control panel isn't all that great, but it works well and does that I want. Regards, Paul Alkema http://paulalkema.com/ http://www.viviotech.net/ mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 20 May 2010 06:10, Kelly Matthews ke...@webdiva.org wrote: Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 Hosting
Coldfusion is going out of business and know one uses it any more? Ignorant scum. -Original Message- From: Dawn Sekel [mailto:dawnt...@yahoo.com] Sent: Thursday, May 20, 2010 12:57 PM To: cf-talk Subject: Re: CF 9 Hosting I have used them for years too -- but I have recently had a really bad experience with them. I signed one of my new customers up under a shared hosting account -- just a small application. The server he was on kept crashing. Their technical support told him that the problem was Coldfusion and that he needed to switch to another technology. They said Coldfusion is going out of business and know one uses it any more. Anyway -- I don't user them any more for my smaller customers that can't afford a dedicated server. I'll +1 for CrystalTech. I've been using them for years. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Alan Rother wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Remove html characters
Try this... cfset html = 'pa href=test with link/a /p' cfset withoutHtml = REReplaceNoCase(html,a .*(href=[']?)([^' ]+)[' ][^]+([^]+)/a,\3: \2,all) cfset withoutHtml = REReplaceNoCase(withoutHtml,p[^]*,Chr(10),all) cfset withoutHtml = REReplaceNoCase(withoutHtml,[^]+,,all) cfoutput#withoutHtml#/cfoutput Paul Alkema http://Paulalkema.com/ -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Tuesday, May 18, 2010 9:38 AM To: cf-talk Subject: Remove html characters Hey all, What's the best way to remove html characters and make something plain text? reReplace? Thanks, Rick Webenergy ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333774 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Remove html characters
I don't know if this will actually help you or not, But I figured it might help someone someday. Lol If your using MSSQL and pulling the data your looking to strip from a database, than you can actually do this from a mssql user defined function. -- FIRST, RUN THE CODE BELOW ONCE TO CREATE YOUR INITIAL FUNCTION USE [yourDataBaseName] -- yourDataBaseName GO /** Strips html **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[stripHTML] (@HTMLText NVARCHAR(MAX)) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @Start INT DECLARE @End INT DECLARE @Length INT SET @Start = CHARINDEX('',@HTMLText) SET @End = CHARINDEX('',@HTMLText,CHARINDEX('',@HTMLText)) SET @Length = (@End - @Start) + 1 WHILE @Start 0 AND @End 0 AND @Length 0 BEGIN SET @HTMLText = STUFF(@HTMLText,@Start,@Length,'') SET @Start = CHARINDEX('',@HTMLText) SET @End = CHARINDEX('',@HTMLText,CHARINDEX('',@HTMLText)) SET @Length = (@End - @Start) + 1 END RETURN LTRIM(RTRIM(@HTMLText)) END -- USAGE EXAMPLE SELECT dbo.udf_StripHTML('pa href=Test/a/p') as noHtml -- OR YOU COULD DO THIS SELECT dbo.udf_StripHTML(table.column) noHTML FROM table I've found this very helpful. :) Regards, Paul Alkema http://paulalkema.com/ -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Tuesday, May 18, 2010 11:21 AM To: cf-talk Subject: Re: Remove html characters On Tuesday 18 May 2010 15:33:01 you wrote: #REReplace(trim(MYTEXTSTRING), [^]*, , All)# But if I say that this is the other thing, which is that thing, it'll go all wrong... -- Tom Chiverton Helping to centrally extend industry-wide plug-and-play slick products as part of the IT team of the year 2010, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Comma Prepending to a form variable
Is it possible that you have more than one field with the name varList on the page? If you have two form field on the same page with the same name. Your action page will insert a comma in the form fields to delimit the fields. Paul Alkema http://paulalkema.com/ -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: Tuesday, May 18, 2010 1:50 PM To: cf-talk Subject: Comma Prepending to a form variable Hi All, I have a form variable which contains a list of names like input type=hidden name=varList value=coldfusion,java,dotnet when I go from the current page to another page and I check the above form value, I have it as input type=hidden name=varList value=,coldfusion,java,dotnet I am getting that extra comma before the first value. How to make sure I do not have that extra comma? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Automate FTP
Have you tried seeing if it's possible to upload some of these big files manually? It's not uncommon for FTP servers to have a max files size restriction. What's the error that your receiving? Paul Alkema http://paulalkema.com/ -Original Message- From: Greg Luce [mailto:luce...@gmail.com] Sent: Friday, May 14, 2010 4:58 PM To: cf-talk Subject: Automate FTP I have a remote server with some transaction logs I would like to automate the ftp retrieval of. I have a scheduled task that uses cfftp to do so, but it seems no matter how long I set the timeouts in the CF Admin for the task, or in the cfftp tag, it fails for files larger than ~ 30-40M. I can get 100M files via cmd like this either one step at a time in the cmd window or with this in a batch script: open 10.10.1.49 DBUser DBPW get Eligibility_tlog_201005141200.TRN quit I have tried all afternoon to use cfexecute to do this such that I can let CF provide the filename programmatically with no luck. So basically I would like to use some FTP inside my cf scheduled task rather than using cfftp. Or any other ideas would be greatly appreciated. My scheduled task has worked until the transaction logs started getting too big. -- Greg ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Converting Video uploads with ffmpeg on a shared host
I would say call your hosting company and talk to them to see if it would be possible to remove that restriction. I would say that most likely they won't. If they won't perhaps you need a dedicated server. -Original Message- From: Carey Duryea [mailto:ca...@keepingitgreen.net] Sent: Thursday, May 13, 2010 12:35 AM To: cf-talk Subject: Converting Video uploads with ffmpeg on a shared host i am uploading the videos and after uploading the video i need to convert it into flash format and for that i found ffmpeg to conver vedio into flv.. but to run this exe to convert vedio into flv format i should have access to run the cfexecute tag which is current blocked byt the host... i'm not sure what to do for a work around on this ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion Session Variables in Distributed Config
ColdFusion stores the session variables in the web server local RAM, however when using ColdFusion with distributed configuration you should store the sessions in the database because you don't know which machine will serve the next page causing inconsistent sessions. Paul Alkema http://paulalkema.com/ -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Wednesday, May 12, 2010 1:46 PM To: cf-talk Subject: Re: ColdFusion Session Variables in Distributed Config Sessions are stored on the server running ColdFusion. -Mike Chabot On Wed, May 12, 2010 at 1:07 PM, Donnie Carvajal donnie.carva...@transformyx.com wrote: Does anyone know where the session variables are stored if Coldfusion is running in a distributed configuration? My assumption is the session variables are stored on the server running ColdFusion and not the web server, but you know what they say about assuming. Thanks, Donnie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How are other developers handling big SVN repositories?
GIT does have an eclipse pluggin called eGit for use in your IDE. http://www.eclipse.org/egit/ Paul Alkema http://PaulAlkema.com -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Friday, May 07, 2010 3:41 AM To: cf-talk Subject: RE: How are other developers handling big SVN repositories? Wow you have lost me. First let's look at a great Client UI first, SmartGit looks awesome have been using the SamrtSVN version for awhile but I prefer it inside my IDE first and foremost. A lot of things you mention below I am not sure if you are referring to SVN or GIT, you can certainly hide code in SVN now by just ignoring it. Might have to look a bit closer how GIT does this. Are you saying that GIT can't check out a part of a project, by revision? I know you can in SVN so you must be talking about GIT here. From what I read about GIT and Subversion 1.6 they are almost identical when it comes to merging and patching code, not having used GIT at this point I may have to look a bit harder at the differences. But SVN is as powerful or not depending on if you utilise that power, and by the sounds of it GIT is no different in that area as well. If I have misread what you are trying to say, you didn't make it easy which parts you are talking about for which application although I see a could majority of it can be used in SVN. -Original Message- From: denstar [mailto:valliants...@gmail.com] Sent: Friday, 7 May 2010 4:35 PM To: cf-talk Subject: Re: How are other developers handling big SVN repositories? Yes! Git has been around a lot longer than I thought it had (catch the wave, right? I'm as bad as the anyone. :]), yet chunks of it are still in flux as if it's brand new. Nothing wrong with that, but with folks jumping on the wagon like they have been, you'd think things like submodules (SVN:externals-ish stuff) and other things like, say, java implementations and 3rd party tools/integrations would be there already. For sure there'd be a decent windows implementation, right? Not so, until just recently (Understandable? Plenty of linux heads hate windoze (see?) with a passion. Can't really blame 'em either. I mean... file locking from the 60s? WTF? =)p). I freaking *love* svn externals. I love that you can check out any part of a project, vs. the whole she-bang. I love having that linear history, at this point (maybe I'll change as I become more familiar with the concepts of editing/deleting commit histories and whatnot). The parts I love about Git are the parts that let me work the way I *want* to work-- meaning, perhaps, not the way I *should* work. Just perhaps. For Git, I love: Shelving/stashing stuff. Keeping stuff private and then going public with it, yet with continuity (sorta). Offline commits! ***sharing patches***! (it's built in!) It's the bomb for open source, mostly because of github + easy patching. Love that social coding aspect it's got going on. For closed source, or more centrally managed projects, something centralized (like SVN) seems to make more sense. At least for the repository of record, ja know? Nothing stopping anyone from using both tools, which I find pretty freaking cool. You don't /really/ *have* to choose, you see? The one thing you *don't* have a choice about: Learning the methodologies of managing code changes when multiple people are involved in the code. There's just nothing that's going to save you from learning that. It's sorta like a coder trying to get away from SQL ( ;) a weak analogy, but I tossed it in for Barney). I'm big on flexibility, and Git is more flexible than SVN (for good or ill), so it probably will be the new SVN, eventually. Ironically, I think this flexibility is an boon to the lone developer, but actually complicates multi-developer interaction. With power, comes responsibility. Anyways, Git really is cool, and approaching problems from multiple angles will better prepare you for future problems, so give it a spin! Just don't let the power of the non-linear blind you to the weaknesses of it, or blind you to the power of the linear. We're beyond good and evil. :) Or something like that. I'm not 100% wrapped around all this crap yet, if ever. They have *both* been awesome *and* painful, for me. I think that might just be life, though. Or something like that. :) :den -- ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Convert image to its negative
I've never used this, but the cftagstore has a cfx tag that claims to do this. http://www.cftagstore.com/tags/cfximagesystem.cfm Paul Alkema http://PaulAlkema.com -Original Message- From: Les Irvin [mailto:les.cft...@gmail.com] Sent: Monday, May 03, 2010 8:05 PM To: cf-talk Subject: Convert image to its negative Does anyone know of a CF custom tag that will convert an image to its negative? For example, converting a medical x-ray image to its positive, etc. Thanks in advance for any help, Les ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:19 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
JRun
I'm getting a JRun error on the houseoffusion website. Just letting you all know. J Paul Alkema ERROR BELOW - Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:20 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfcatch issue
Are you on CF8 or higher? Try dumping the cfcatch scope and see what you get. Paul Alkema PaulAlkema.com -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Wednesday, April 28, 2010 4:26 PM To: cf-talk Subject: cfcatch issue hi all- I am using try/catch around a cfquery, and when I use #cfcatch.SQl# within cfcatch, I get an error saying sql is undefined in cfcatch. The same happens with #cfcatch.where#. Everything is fine with #cfcatch.detail#, #cfcatch.message#. I have been working with #cfcatch.sql# and #cfcatch.where# with no issues until today. Can any one let me know what could be the issue ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333196 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CfEclipse Slow Code Hinting
Eh, this helped so much. Makes the world a difference. I think the default delay for this is way to slow. Oh well, thanks so much. Regards, Paul Alkema http://Paulalkema.com -Original Message- From: denstar [mailto:valliants...@gmail.com] Sent: Wednesday, April 21, 2010 6:22 PM To: cf-talk Subject: Re: CfEclipse Slow Code Hinting For CFE it's: Preferences CFEclipse Editor : Insight Delay And you can disable specific kinds of assist using: Preferences CFEclipse Editor Auto-insertion closing: Suggest... In case one of them gets in your way too much at the lower delay setting. :den -- Psychologically experienced consciousness is therefore no longer pure consciousness; construed Objectively in this way, consciousness itself becomes something transcendent, becomes an event in that spatial world which appears, by virtue of consciousness, to be transcendent. Edmund Husserl On Wed, Apr 21, 2010 at 3:41 PM, Jason Fisher wrote: Window Preferences ColdFusion Editor Profiles Editor Code Assist There's a setting there called Dealy Before Showing Code Assist(in milliseconds) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL data integrity
I'm no attorney or law professor but I would look into being PCI compliant. I don't know if this is exactly what you need, but it definitely couldn't hurt and it is a very high level of security. Keep in mind though, that it's not easy. Good luck. Regards, Paul Alkema http://paulalkema.com -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Thursday, April 22, 2010 3:31 PM To: cf-talk Subject: SQL data integrity Hi all, not a CF-specific question but I'm hoping someone can point me in the right direction. We're building an application where some information stored in our database could potentially be subpoenaed to court as evidence. One of the issues brought up by the attorneys is the integrity of the data stored in the database and how it could be proven in court that the data has not been altered since it was entered into the database. Any ideas on where to start looking for a solution to that? The front-end is ColdFusion with a MS-SQL back-end. This is a new area for me, so it's interesting, but I don't have any points of reference to work from either. Any insight is appreciated. Thanks! -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CfEclipse Slow Code Hinting
Hi, Does any know if there's any way to change how long it takes for cfEclipse to provide code hinting? It's so slow. Regards, Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
MSSQL Where In not working with variables
I know this is a CF list, sorry for posting this in the wrong area, but I thought maybe one intelligent people might know. I've been working with the WHERE IN clause in MSQL and It seems not to be working well for me with a variable for some reason.. This is an example of what I'm trying to do DECLARE @idList varchar(max) SET @idList = '1,2' SELECT * FROM table WHERE ID IN (@idList) Any ideas? Thanks, Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: MSSQL Where In not working with variables
Eh, sorry. I've just found the solution to my own problem. Just for future reference, this is my solution. DECLARE @idList varchar(max) DECLARE @sql varchar(max) SET @idList = '1,2' SET @sql = 'SELECT * FROM table WHERE ID IN (' + @idList + ')' EXEC(@sql) Thanks Paul From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Tuesday, April 20, 2010 1:55 PM To: 'cf-talk@houseoffusion.com' Subject: MSSQL Where In not working with variables I know this is a CF list, sorry for posting this in the wrong area, but I thought maybe one intelligent people might know. I've been working with the WHERE IN clause in MSQL and It seems not to be working well for me with a variable for some reason.. This is an example of what I'm trying to do DECLARE @idList varchar(max) SET @idList = '1,2' SELECT * FROM table WHERE ID IN (@idList) Any ideas? Thanks, Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Dynamic SQL Column Names
You could create one table that will store dynamic columns and another to store the dynamic columns data. Then if you're using MSSQL 2005+ than you can use SQL Pivots to extract the data dynamically.. if your using anything less than MSSQL 2005 than you could use dynamic SQL and build a temp table. Pivots http://www.sqlprof.com/blogs/sqldev/archive/2008/04/12/pivots-with-dynamic-c olumns-in-sql-server-2005-2008.aspx Regards, Paul Alkema -Original Message- From: Brian Thornton [mailto:vegasthorn...@gmail.com] Sent: Thursday, April 15, 2010 5:21 AM To: cf-talk Subject: Re: Dynamic SQL Column Names Or go runa query on the table with 1 record using a select * and loop through the columnlist returned. On Wed, Apr 14, 2010 at 8:39 PM, Doug Ford doug.e.f...@gmail.com wrote: Hi Folks - I am wracking my brain trying to figure out how to get the results I am looking for. Here's the background - I am dealing with dynamic environment allowing losers, I mean users, to enter in field names. This is a business product so anything is possible. When a user of the product creates the columns, they have no knowledge of coldfusion or sql, so if a person enters in VIN # as a piece of information they wish to capture, VIN # becomes a column header. Now then, on any given random form my system would be creating, I won't know how many fields or their names. If a person creates 5 or 500 fields, I have no clue, and I won't know what column names they could ultimately create. I have been toying with getColumnList() to display the column titles, but how would I get the actual data out of it? I have tried using evaluate on the field names, but when it comes across VIN #, the system blows up. Any and info is appreciated. Thanks, Doug ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What happens to session variables after redirecting to https?
Hmm.. I don't think this is correct. My site doesn't pass tokens in order to keep session variables or cookies. When a user first lands on my http site, I set sessions/cookies and pass them to our cart which is https and both of them are transferred just fine and I don't pass any type cf tokens. I don't know if it makes a difference but I use 128 bit High-grade Encryption. Now... yoursite.com vs www.yoursite.com is a different issue. That is seen by most browsers as being different sites and doesn't allow you to pass cookies to between the two sites. Paul Alkema http://www.alkemadesigns.com/ -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, March 31, 2010 10:49 PM To: cf-talk Subject: Re: What happens to session variables after redirecting to https? No, from a cookie perspective, http://mysite.com and https://mysite.com are 2 different domains, so you need to send the session tokens across the gap. Any of a number of approaches can work, but here's the quick and dirty: cflocation url=https://#mySecureURL#; addtoken=yes / Or, if you are using some other redirection, you can append the following to the URL: cfid=#cookie.cfid#cftoken=#cookie.cftoken# (Note that the nomenclature is different if you're using Java session IDs.) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Eclipse Compare Remote Files
Hi all, Does any of you know of a plugin or a way to easily compare a remote file for changes? I have cfEclipse and Aptana. Paul Alkema ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Decrypt CF scheduled job password?
Yeah if you do google coldfusion decrypt datasource password make sure you click on what's currently the 4th option entitled How To Crack Coldfusion Datasources . I think you'll find that the most helpful. ;) Paul Alkema AlkemaDesigns.com -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Tuesday, March 30, 2010 10:45 PM To: cf-talk Subject: RE: Decrypt CF scheduled job password? I've never tried it, but if the cron passwords are stored the same way data source passwords are, then they probably are crackable. Google coldfusion decrypt datasource password Note: The people who figured out how to decrypt CF passwords had to decompile CF's source Java code so enter at your own legal risk. :) ~Brad Original Message Subject: Decrypt CF scheduled job password? From: Qing Xia txiasum...@gmail.com Date: Tue, March 30, 2010 8:09 pm To: cf-talk cf-talk@houseoffusion.com Hello folks, I was just wondering, does anyone happen to know if the password in the CF scheduled job XML file (cfroot\lib\neo_cron.xml) is crackable? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: reverse engineer PHP to CF
My whole outlook on converting scripts from one language to another is to look the front end and get an idea of what the application's purpose is and try to figure out exactly what the application is doing, then look at the backend and confirm your front end finding. Take notes! Then rewrite your new application in the way that you think that it should be written keeping in mind that you need to have the same end result as the old script. Or you could even make improvements! I think translating the scripts directly from one language to another will usually result in an application that was written poorly. Languages work differently than another. I think the important thing is that the end results are the same. Paul Alkema AlkemaDesigns.com -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Monday, March 29, 2010 9:39 AM To: cf-talk Subject: Re: reverse engineer PHP to CF cool final is below... cfparam name=reportName default= / cfset reportFile = expandPath(/Powerbase) / reportName . reportID _sql / cfswitch expression=#op# cfcase value=load cffile action=READ file=#reportFile# variable=ff / cfoutput#ff#/cfoutput /cfcase cfcase value=save cfoutput cfdump var=#form# cfset qry = #form.queryToSave# / cffile action=WRITE file=#reportFile# output=#qry# nameconflict=OVERWRITE / cfoutput#reportName#/cfoutput saved ... /cfoutput /cfcase cfcase value=list cfdirectory action=LIST directory=#expandPath('/Powerbase')# name=files / cfoutput ul class=treeview id=treeview_#reportID# li class=listSaved sql files ul cfloop query=files cfif right(name, 4) is _sql li class=item#listFirst(name, .)#/li /cfif /cfloop /ul /li /ul /cfoutput /cfcase cfdefaultcase /cfdefaultcase /cfswitch ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332413 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion SQL Hack
I would ensure that every single update / insert on your site is using cfqueryparam's for security sake, however It sounds to me like your issue is not SQL injection.. but more XSS attacks. An XSS attack is where data is inserted into into a page usually via a database input field somewhere which then executes a javascript or other piece of code into a site which can cause users sessions to be hijacked or the user could be simpley redirected, which is what is sounds like this xsser is doing. Dorioo is right on about the fix for this, I would either sanitize all data that a customer has access to input with the htmleditformat() or sanitize the output with htmleditformat(). IE; INSERT INTO users (userId, userName) VALUES ('#form.username#') Should be.. INSERT INTO users (userId, userName) VALUES ('#htmlEditFormat(form.username)#') Another option would be to enable Global Script Protection in the settings area of your coldfusion administrator. Doing this will cause you to never have the ability to pass javascript tags and object tags via CGI, FORM and URL variables though, so I would be careful about this global option. Good luck! Paul Alkema AlkemaDesigns.com -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Monday, March 22, 2010 9:25 AM To: cf-talk Subject: Re: Coldfusion SQL Hack The query you wrote is not hackable via SQL injection. No changes need to be made to it. -Mike Chabot On Mon, Mar 22, 2010 at 7:04 AM, Anthony Doherty a.dohe...@advancesystems.co.uk wrote: I have a site page that is only using the query below and the site keeps getting hit by SQL hacks. I have looked through every SQL query and all the queries are using cfqueryparam value=#URL.???# cfsqltype=cf_sql_numeric so they cant be hacked. Can someone explain how I can amend this query so its not hackable?? cfquery name=RS1 datasource=DS1 SELECT FEEDBACK.ID, FEEDBACK.FEEDBACK, FEEDBACK.LEFT_BY, County.County, County.ID FROM FEEDBACK INNER JOIN County ON (FEEDBACK.COUNTY = County.ID) /cfquery Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Cfsearch - Spell Checker
Hi All, The CfSearch tag has a built in spell checker however, the company I work for is an engineering company so words that people would search for and make spelling issues are a bit more advanced than the built in spell checker that adobe has provided by default via the cfSearch tag. Does anyone know if there is a way to edit the list of spell fixes? Best Regards, Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Does not contain dilema
First off, as a general rule I would put the variable first, then the string. So you have cfif united States contains country. I would try cfif country contains united states. Secondly.. You need to var your variables. If country is a form variable refer to it as form.country... not just country. This could really mess you up down the road, plus it's just a bad practice. Some something like... cfif form.country contains United States and form.state contains IL and not form.inType contains K-12 / Also, what I do in instances where I'm using multiple IF arguments and I'm trying to find which one is causing my IF statement to fail, is I remove the cif at the beginning and the closing IF bracket. Then I wrap an cfoutput tag around the IF statement and put pound signs around each statement. This should output YES or NO if the statement is passing or not. This is a good way to diagnose which For instance this should tell you exactly which IF argument is causing your IF statement to fail. cfoutput #United States Contains Country# and #K-12 does not contain intype# and #(State is IL) or (State is IA)# /cfoutput cfabort / Regards, Paul Alkema http://www.alkemadesigns.com -Original Message- From: Orlini, Robert [mailto:rorl...@hwwilson.com] Sent: Monday, March 22, 2010 11:51 AM To: cf-talk Subject: Does not contain dilema I have a form with a field call intype which I need to filter and NOT send an email if the form does contain a certain list of states, but does not contain the value k-12 for intype. The cfif I have that does not seem to work is: CFIF United States Contains Country and K-12 does not contain intype and IL Contains State or IA Contains State. I've tried, but it still sends the email which I don't want: CFIF United States Contains Country and K-12 does not contain intype and (State is IL) or (State is IA) Any easier way to do this please? Thanks. RO HWW ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion Builder Released!
I agree, I wouldn't want flashbuilder but I would want cfbuilder. I wouldn't want to pay for flashbuilder if I don't want it. I'm switching back to cfEclipse. -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Monday, March 22, 2010 1:18 PM To: cf-talk Subject: RE: ColdFusion Builder Released! Considering that I don't need flash...no it's not. If flash is the cost, then they should offer a version without flash builder. I think it is an outrageous price for a plugin. Eric -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Monday, March 22, 2010 12:14 PM To: cf-talk Subject: Re: ColdFusion Builder Released! It's bundled with FlashBuilder 4 which is nice. That's actually a pretty decent price. On Mon, Mar 22, 2010 at 12:10 PM, Eric Roberts ow...@threeravensconsulting.com wrote: 299.00? WTF? What the heck is Adobe smoking? Looks like its back to CFEclipse for me! Eric -Original Message- From: Adrocknaphobia [mailto:adrocknapho...@gmail.com] Sent: Monday, March 22, 2010 11:46 AM To: cf-talk Subject: ColdFusion Builder Released! The subject says it all. If you haven't looked at ColdFusion Builder since the last public beta, you should check out the final release. There have been about 4 months of performance enhancements, bug fixes and tweaks since then. You can download a 60-day trial of ColdFusion Builder from Adobe.com. http://bit.ly/TryBolt -Adam ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331986 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cfsearch - Spell Checker
I asked this question at 10:03 AM this morning. Does anyone have any idea's on this? Thanks, Paul From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Monday, March 22, 2010 10:03 AM To: 'cf-talk@houseoffusion.com' Subject: Cfsearch - Spell Checker Hi All, The CfSearch tag has a built in spell checker however, the company I work for is an engineering company so words that people would search for and make spelling issues are a bit more advanced than the built in spell checker that adobe has provided by default via the cfSearch tag. Does anyone know if there is a way to edit the list of spell fixes? Best Regards, Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331989 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm