Community Member Profile

Recent Blog Comments By Tero Pikala

• Making SOAP Web Service Requests With ColdFusion And CFHTTP

  Posted on Jan 11, 2010 at 6:26 PM

  I've found this often only way to invoke "complex" web services. They don't really have to be that complex - typically .NET ones just don't work well with Axis that is doing heavy lifting in ColdFusion. In my opinion easiest way to figure out required XML is to use SoapUI (read more »

• Ask Ben: Creating ColdFusion Templates On The Fly

  Posted on Sep 21, 2009 at 5:28 PM

  Based on the original question it seems that Steve only needs to create CF templates so that pages from CMS can have proper URLs. I would suggest to use mod_rewrite or similar approach to rewrite pretty much any URLs in the site to a page handler which can be traditional CF page. This is m... read more »

• Ask Ben: Streaming Binary Data From The Database (BLOB) To The User Using ColdFusion

  Posted on Jun 30, 2008 at 2:40 PM

  JD: I would usually implement caching as a reverse proxy with Apache mod_cache or Squid. Caching is complex thing and using existing code for it is usually good idea.... read more »

• SQL Optimization Case Study - JOIN Clause vs. IN Clause

  Posted on Sep 4, 2007 at 7:27 PM

  Sometimes you just need to use IN, specifically if there are some ids in ColdFusion that need to be part of the query. This could happen for example when you have results from search server but need to filter out them based on some SQL based logic. When that happens one thing to check is... read more »

• Ask Ben: Forward ColdFusion Requests To Another Domain

  Posted on Aug 22, 2007 at 9:50 AM

  That would go to .htaccess in your webroot; only requests for that domain will be served there and thus matching is done earlier by Apache virtual hosts setup. If your host allows you to use .htaccess and they have mod_rewrite enabled this would work for you - I would think that's quite co... read more »

• Ask Ben: Forward ColdFusion Requests To Another Domain

  Posted on Aug 22, 2007 at 7:59 AM

  Alternative and in my opinion preferred way is to use mod_rewrite if using Apache. Couple fo lines in .htaccess will take care of whole thing (including images and other files) RewriteEngine On RewriteRule ^(.*)$ http://www.new.com/ $1... read more »

• I Just Can't Understand Object Oriented Programming (OOP) And Join Tables

  Posted on Aug 17, 2007 at 9:53 AM

  I guess I would do something like this: Create value object Practice. It has property childs which is an array. Then create PracticeDAO which can be asked for single Practice with id and knows how to populate childs array with Practice objects as well. Sort order is determined by po... read more »

• Ask Ben: Environment-Based Application.cfc Settings

  Posted on Aug 13, 2007 at 2:41 PM

  To use SFTP you need to use SCP task with Ant - and it's definitely good idea to use something else than stone age FTP without any security at all.... read more »

• Ask Ben: Environment-Based Application.cfc Settings

  Posted on Aug 13, 2007 at 7:50 AM

  @Ben, Ant has external task for FTP communications. As long as you don't have anything really tricky it should be possible to script FTP transfer with Ant. Check http://ant.apache.org/manual/OptionalTasks/... read more »

• Ask Ben: Environment-Based Application.cfc Settings

  Posted on Aug 12, 2007 at 1:33 PM

  Quite different approarch is to deploy application to various environmens with Ant script and use that script to customize environment specific variables. Check Ant manual for Replace / ReplaceFilter tasks for details.... read more »