ColdFusion on Wheels - table relationships
May 28, 2008
If you have two tables in your database that have a one to many relationship then you need to set up the relationship between the two in ColdFusion on Wheels. For example if you have a posts table and a comments table (Note that ColdFusion on Wheels… Read more »
Using Query of Queries to improve performance
May 28, 2008
I'm pretty sure that this has been blogged about before but I thought it was important enough to write about as some people may not have seen it or forgotten! I am currently building an application that requires a lot of database interaction. I've d… Read more »
Dreamweaver CS4 supports Subversion
May 27, 2008
The beta of Dreamweaver CS 4 is available from Adobe labs, along with Fireworks CS4 and SoundBooth CS4. I'm pleased to see that finally Dreamweaver has included support for Subversion without the need for any 3rd party add-ons. If you already have a… Read more »
IE8, CF8 Ajax and jQuery
May 23, 2008
I noticed a post on Dale Fraser's blog about IE8 breaking the DHTML/AJAX built-in features of Coldfusion 8. I decided a while back to stick with doing AJAX calls and DHTML using jQuery instead of using the new tags in CF8 - and I'm glad I did as my code still works in IE8. Read more »
Is it just me? BlazeDS woes
May 23, 2008
Trying to get BlazeDS, CF8 and Flexbuilder to talk so that I can build a chat application and the pain it's causing me! Read more »
Updating a website from Access
May 21, 2008
A while back a client wanted to be able to update stock levels from their back office system which was an Access Database. Recently I was asked about this so I'd thought I'd share the concept. With a mix of some Visual Basic code and few DLLs and a CFC you can pass a WDDX packet from Access to a ColdFusion webservice. You will need to register some DLLs (wddx_com.dll, ASPtear.dll, xmlparse.dll, xmltok.dll) on the clients PC to get it to work. Read more »
Expanding menus with jQuery
May 13, 2008
I was recently asked by a client to do a menu which would expand to show pages when the visitor moved their mouse over the menu heading to show sub pages of that section. Their second requirement was that the menu would stay expanded if the visitor c… Read more »
Performance gain with Subquery instead of group
May 12, 2008
I've often used SubQueries in SQL for filtering data, but I've not tried using one in a select statement. I recently had a query that was running slowly due to the number of fields referenced in the group by clause. By changing it to use a SubQuery in the select it has actually reduced the execution time. Read more »
To open source or not?
May 02, 2008
Jedi Master, Raymond Camden recently did a presentation on Open Source and RIAForge. The synopsis pretty much covers it: It is time for more CFers to start contributing to Open Source, for the benefit of the Community and the product. Ray provides… Read more »