>> GreenByte.info By Nick Tong (quiksilv) | Supported by: TalkWebSolutions.co.uk

dbvarname in stored proc gotcha with coldfusion 7,0,2 updated

I just updated my server with coldfusion version 7,0,2,142559 and everything was working dandy, or so I thought. I started getting errors emailed to me telling me a stored procedure was not working. After looking at the code for a couple of hours, change JDBC drivers and removing an old commons-digester-1.3.jar file I still couldn't find a fix to the error:

[Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near '='.
Message    [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

[More]


Using Google Reader and RSS.cfc to aggregate feeds

I'm not sure how others aggregate blog/news feeds etc but I've found an easy (and somewhat simple) way to aggregate feeds using Google reader and Ray Camdens rss.cfc.

All you do is create an account with Google reader and then start adding the feeds you want to aggregate. Add your tags to the feeds i.e. cfEclipse, FuseBox etc and make your feed public. The public feed that you create here will be what we need to grab the data in Ray rss.cfc.

Once you're happy with all your feeds in Google create a page called feeds.cfm - make sure that rss.cfc is in the same folder as this page [or invoke the cfc some other way (recommended)].

Then use this code in feeds.cfm

<cfset myRssFeed = "YourGoogleFeedURL" />
<cfhttp method="get" url="#myRssFeed#" />
<cfset rssObj = createObject("component", "rss");
<cfset request.feed = rssObj.getEntries(cfhttp.FileContent) />

<h1>My Feed</h1>
<cfoutput query="request.feed">
   <h2><a href="#request.feed.link#" title="#request.feed.title#">#request.feed.title#</a></h2>
   <cfif len(request.feed.description)>
      <p>#request.feed.description#</p>
   <cfelse>
      <p>No description available</p>
   </cfif>
</cfoutput>

One thing you will have to do is update line 537 in rss.cfc to this:

<cfif structKeyExists(arguments.xmlData.feed.xmlAttributes,"version")>
         <cfset result.type = "Atom">
         <cfset result.version = arguments.xmlData.feed.xmlAttributes.version>
      <cfelseif structKeyExists(arguments.xmlData.feed.xmlAttributes,"xmlns:gr")>
         <cfset result.type = "Atom">
         <cfset result.version = 2.0>
      </cfif>
This is a bit of a hack but the Google feeds don't have a version number in the returned XML.

Cool huh?

Check out the feed page on cfFrameworks.com to see it in action.


CFDevCon A Coldfusion Conference for the UK

Take a look at this:

cfDevCon Logo

Yes finally a UK ColdFusion developer conference (well a mini one at least), which will be taking place In November this year..
For more information please visit www.cfdevcon.com.


For those of you that like me, that couldn't afford to go to CFUnited in the USA, hopefully this might go some way to making you feel a bit less less left out.
We have some great topics and some awesome products on show, not to mention some execellent prizes to give away.
Those of you who have been playing with BlueDragon on the CFDeveloper FREE developer hosting will be interested to get a chance to see all the cool new features in the up coming Bluedragon.net 7 and will get some first hand tutoring from New Atlanta on how to leverage the power of BlueDragon.
Also on show is FusionReactor, the MUST HAVE performance monitoring and crash protection tool for ColdFusion servers. And yes I do use this myself to keep the CFDeveloper server up and running. They will also be showing off their new FusionDebug plugin for CFEclipse that allows you to finally have some proper debugging tools for your ColdFusion applications.
And speaking of CFEclipse, Mark Drew its creator is coming along to finally wean you old studio/homesite junkies (me included) off your antiquated old IDE. He will be getting down and dirty and really showing us how to properly use the power of CFEclipse, including some of the advanced features such as source control
For those that have been living in a closet, CFEclipse is the new FREE open source IDE for CML editing, in fact it seems to have been taken on board by Adobe too.
For more info get on over to http://cfeclipse.org/
We also have Kevin Roche from the Thames valley CFUG giving us a lesson in Fusebox 5 lexicons and Reactor. I have never been a big fusebox fan, but since Fusebox 4 I have been impressed, and with the release of fusebox 5 even *I* am getting on the bandwagon and retiring my own framework in favor of the FB5 way. And those of you that like to spend time surfing the CF blogs out there, will no doubt have noticed the other craze currently sweeping CF land, namely Reactor and ColdSpring, more great framework add-ons that allow you code faster and generate code on the fly among other things, its all gone very "Ruby on Rails" in the CF world of late don't you think.
I also have a couple of guest speakers coming over from the USA who are big names in the CF world, one of which is Charlie Arehart who is doing the FusionReactor session for Intergral, he is also planning to do some FusionReactor training sessions the next day for those of you that realise the potential of this product and want to know more. Charlie as many of you may know is very active in the community and writes a lot of articles for the ColdFusion Developers Journal and has also co-authored a few CF books.
And finally after you have had your fill of techno babble, there is an after conference party in the evening for you to relax, chug down some beers at the bar and get to know some of the other CFDeveloper members or corner some of the speakers with any of your technical questions. I'll even let you buy me a beer or two as well if your lucky :-)

So what are you waiting for, slide on over to www.cfdevcon.com and register.

I look forward to seeing you there.

I for one am looking forward to it.


A CF developers toolset

Someone asked me today what tools I develop with and I thought that I would let you all know what I use these days; there has been a good flamewar on the cf-talk mailing list about IDE recently.

So here they are:

IDEs
Design/CSS: Dreamweaver
Day to day CF coding eclipse/cfeclipse

Source Control
SVN (subversion) with tortoiseSVN

RDBMS
MS SQL 2000– looking at MSSQL 2005

Bug Tracking
Ray Camdens Lighthouse Pro – although I’m looking at Trac (but having SQL, JRun, eclipse, DW and Python all running might kill my Vaio!

FTP
Dreamweaver
Beyond compare
Looking at ANT to do this for me…

CFML Parser
Depending on my machine but JRun on my laptop, CF Server on my desktop and Bluedragon on my USB memory stick.

Web server
Depending on my machine IIS on my desktop and Apache on my laptop

What do other people use, I would love to know. Is there anything that I'm missing?

RDS plugin for cfeclipse

So I finally decided to install the RDS plug-in for cfeclipse. I have to say that it's great getting all your enviroments in one package and a great kicker to the plug-in is it has a built-in query editor, sweet!

The following 2 link helped me out loads: follow in order
socialpoints.com
labs.macromedia.com

how to remove extra cfeclipse navigator text

Have you ever worked with cfelipse using CSV and had a load of test to the right of your file names such as (ASCII ~ko)?

Well after searching the preferences section I know how to get rid of this.

  • Click Window | Preferences to open a dialog window.
  • Click Team | CVS | Label decorations
  • Click the text decorations tab and in the file description remove {revision} {tag} ({keyword}).
Your navigator window should now be a lot clearer.

a web developers cheat sheet list

Here is a list of some great cheat sheets. Last updated 15/04/2007.

If you know of any please add them to the comments below. Lets help each other out.

Web Dev Cheat Sheets

Databases / SQL Cheat Sheets

Language Cheat Sheets

Javascript

Version Control Cheat Sheets

Framework Cheat Sheets

Other cheetsheets

Commercially Printed CheatSheets

Apollo

Please do add more to the comments and I will update... need to get more cheat sheets for frameworks!

BlogCFC was created by Raymond Camden. This blog is running version 5.5.1.