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.

Topper on ColdFusion

  • MySQL - Create a user with access to just one database
    Wed, 08 Apr 2009 11:27:00 GMT
    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,...
  • eTag()
    Wed, 25 Mar 2009 02:14:00 GMT
    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...
  • The BP Party
    Fri, 16 Jan 2009 09:13:00 GMT
    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 launched
    Tue, 30 Dec 2008 08:24:00 GMT
    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...
  • Tip: Change the Railo port to port 80
    Thu, 13 Nov 2008 07:57:00 GMT
    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.) ...
  • MySQL Optimisation Tip #2: Store counters in seperate tables
    Sat, 08 Nov 2008 06:38:00 GMT
    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...
  • MySQL Optimisation Tip #1 - Turn on the query cache
    Wed, 05 Nov 2008 12:59:00 GMT
    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...
  • ColdFusion Optimisation Tip #1 - Use StructKeyExists instead of isdefined
    Wed, 05 Nov 2008 12:57:00 GMT
    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...
  • Tip: Protect your MySQL from SQL Injection
    Mon, 20 Oct 2008 07:23:00 GMT
    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...
  • Great Review for TeamworkPM
    Tue, 02 Sep 2008 10:47:00 GMT
    review of our software, Teamwork Project Manager from about.com!]]>