Table Of Contents
 

Digital Crew Developer Blogs

Digital Crew have 2 employees blogging at present.

These blogs are mainly Coldfusion, Internet Technologies and programming related journals and notes.

If you have any issues, features or items you wish to highlight, why not drop Peter or Daniel and email to have it featured on one of their development blogs.

RSS feeds are available for each blog and should be automatically accessible.

Dan Mackey On ColdFusion Development

  • I am a week into Flex 3 development building an AIR app to test the new API for Teamwork Project Manager and thought I would share an issue with HTTP Basic Authentication that I ran into. To be honest it has been itching away at me all day today and half of yesterday and I finally solved it. Wh...
  • After my initial post yesterday CFX_CompareHTML ColdFusion HTML diff custom tag I got quite a bit of feedback and one of the items raised was that some people dont like CFX tags and I should use JavaLoader to use the JAR file from within ColdFusion. (Thanks Dan Vega) I have uplo...
  • Following on from my last post I have released Version 1 of my ColdFusion HTML Diff Custom Tag, CFX_CompareHTML. When we wrote Teamwork Project Manager one of my jobs was to compare versions of Notebooks which were marked up using HTML. I did lots of searching and found Diff.cfc which d...
  • I have a small project that I am working on that needs a Java custom tag that I'm writing. I need this running on ColdFusion 7/8 and Railo 3. Adding the CFX to CF is fine and I had no problems, except that its laborious. Having to place the file in the right folder, adding that folder to the Jav...
  • Just a quick post as I havent posted in ages due to the considerable committments from Teamwork Project Manager My CFOrgChart demo has gained a huge amount of interest from people and I have unexpectedly been flooded with requests for the code so here it is ;-) DOWNLOAD ZIP FILE I'll be updatin...
  • I upgraded to an iPhone 3G recently and love it. I am doing this one legally and have not Jailbroken it so I dont have all the cool 3rd party apps from Installer App. The main app I miss is an IM service app. I used to use Fring but now can't so I was delighted when I found Palringo. Very nice ap...
  • I was checking my RSS feeds (using a paid version of FeedDemon) and noticed on Nick Bradbury's blog that FeedDemon (and all newsGators non-enterprise RSS products) are being released free. While I appreciate why they are doing it, something inside me felt disappointed. Why? Cause I paid ...
  • I found a very interesting article today on a subject that is of particular interest to me at the moment. I am in the need of a good gantt chart component (for integration with www.teamworkpm.net) and after searching high and low, have come to the conclusion that it may be worth building one mysel...
  • As I have posted before, Live Support is something that interests me greatly and I have been constantly on the look out for a good solution. A new addition to the Windows Live Messenger family of products is the Windows Live Messenger Control for blogs and websites. It allows anybody to ...
  • Once again I have been impressed by AIR - Adobe Integrated Runtime. I can see massive advantages of an app environment like this even if I have some requirements that are not available. Anyway, we use Google Analytics for client projects and our own websites and I alway...

Topper on ColdFusion

  • GRANT ALL ON mydatabase.* TO username@"%" IDENTIFIED BY 'mypassword'; But when I logged in as this user, he could see all the databases. The only way to give the user full access to just one database, so far as I can see is by spelling out what the user can do with GRANT SELECT,...
  • eTags. eTag() is a handy function that you can use to perform client-side programmable caching of your coldfusion pages. To get the benefit just call <cfset eTag( "My Page" )> and the next time a user visits this page, they will get a 403 not modified response and execution w...
  • In case you can't read the writing, download the big version here - The BP Party (pdf) And please spread the word in case I miss anyone. Details again: Date: February 21st 2009 Time: 9pm Activity: Copious Drinking Notes: It's fancy dress! You must come dressed up as something beg...
  • Form Wizard for ColdFusion. It will save your hours and hours of tedious work designing forms for your website, and then doing the javascript validation, database store, email notifications etc. And the look and feel can be extended to integrate with any website design. It's o...
  • Here's a quick Railo tip.. To change the default railo server port from the current default of 8600 to port 80: Open the C:\Program Files\Railo\conf\resin.conf file. (You can use the free Notepad++ for this if you don't have another suitable editor, windows notepad won't do.) ...
  • Store counters in seperate tables A common scenario, you have a "pages" table and you want to store a hit counter in that table so you will know which pages are the most popular, you would have something like: CREATE TABLE `pages` (   `pageId` int(10) unsigned NOT NULL auto_i...
  • The Query Cache If your using MySQL in production you should turn on the query cache - this is off by default ( even if you have installed using the wizard and choosen "dedicated server" ). The query cache basically remebers the results of your queries and saves them from being exe...
  • Use StructKeyExists instead of isdefined Many of ye know this old nugget already so sorry if you know this already but StructKeyExists is much much much faster than isdefined. As Simon Whaylay says: "IsDefined() checks not just if a variable exists, but if it is also syntactically corr...
  • sql-mode=NO_BACKSLASH_ESCAPES Before you do this, If you have a simple search on your site and a user inserts test\'' OR 1 = 1   -- instead of just test The \'' will get escaped and your SQL statment will turn from something like: WHERE variable LIKE 'test' AND use...
  • review of our software, Teamwork Project Manager from about.com!]]>