ClickCulture Blog - ColdFusion

ClickCulture - Looking for ColdFusion / .NET Developers

Mon, 31 Jul 2006 18:05:00 -0400

ClickCulture is looking for ColdFusion / .NET web developers!

We are looking for bright, energetic, hard working individuals who enjoy working in fast paced environments and who are willing to assume increasing responsibilities.

Position Description:

Perform web-based software development tasks including gathering requirements, coding, testing, and documentation. Work could include modifications of existing applications as well as development of new applications.

Must have solid working knowledge of:
HTML, CSS, ColdFusion MX and/or .NET, Microsoft SQL Server, and JavaScript. Working knowledge of Fusebox or other frameworks, XML, Subversion a plus! Primary Responsibilities:

Assist in the design and development of new web applications based upon best practices.
Resolve technical issues, and ensure proper operation of existing web-based products and services.
Ensure development consistency and strive for continued development innovation.

Candidate should possess:

3+ years developing ColdFusion and/or .NET applications.
Strong problem-solving and debugging skills.
Excellent communication skills (both verbal and written) and attention to detail.
Strong understanding of complex database-driven projects.

Location: Raleigh, North Carolina

If you meet these qualifications, we invite you to submit a resume and cover letter:

e-mail: jobs @ clickculture.com
fax: (919) 420-7758 Please no phone calls or postal mail.
Only qualified candidates will be contacted.

CFSearch Differences Between CFMX 6 and 7

Thu, 27 Jul 2006 20:43:00 -0400

I've been tearing my hair out for the last two days trying to debug Verity/vspider since we've upgraded to CFMX 7. I have been using vspider to index two sites successfully on 6 and after the upgrade they were no longer working. The spider was running and the collection was getting populated but cfsearch would fail complaining it could not find the collection even though I could see it in the CF admin. Previously I had used the full path to the collection in my cfsearch (worked in CF6): cfsearch collection="C:\wwwroot\projectname\collectionname" This fails in CF7. It appears you no longer need the full path - this works in CF7: cfsearch collection="collectionname" Verity and especially vspider don't appear to be used much in the CF Community. A post to cf-talk and to the Adobe forums several hours ago have only resulted in one response.

Developer Links

Wed, 12 Jul 2006 17:21:00 -0400

Busy! Here is a quick link dump: Ray Camden's ColdFusion Security Checklist Spell Checking (like Gmail) Why We Like Flex DHTML Timelines Form Gallery - Builder Speaking of forms - put the label on top of field

Apollo, Walmart, Subclipse Tips and HTML/CSS in Email

Tue, 30 May 2006 13:45:00 -0400

Nice review of Apollo - Macro... I mean Adobe's next big thing - think - Flash everywhere! UML Tutorials - getting started with UML Rob Rohan releases his Afae Eclipse Plugin for free! This is interesting - Adobe is putting links on del.icio.us. Right now it appears to be centered around the design tools - Photoshop/Illustrator/Flash - hopefully Flex and ColdFusion will get added. Some GREAT Subclipse tips here - the Team -> Synchronize view and the ability to show incoming/outgoing changes rocks! Fascinating article about Walmart data mining... I was in Walmart yesterday and was standing near the front and it's amazing to actually listen to the cash registers beep - every beep = transaction. Two articles regarding using HTML/CSS in email.

ColdFusion + Flex, CSS, Adobe, Google and Microsoft Battle It Out

Tue, 23 May 2006 12:37:00 -0400

CF + Flex = RAD
Nice Online CSS Reference tool
Google, Microsoft and Adobe - The battle for the new operating system
More on the same topic but a bit more in depth
Picture cloud

Railo, Virtual Software Installs, SQL Resv'd Word Checker

Thu, 30 Mar 2006 15:19:00 -0400

Remove hidden data in Microft Office documents

Railo - another CFMX engine - good stuff!

Virtual Software Installs - if you install a lot of software to try out - this looks useful - allowing you to install on a 'layer'

Pete Freitag's SQL Reserved Word Checker

RDS support in CFEclipse! The wiki instructions were a bit lacking but I found this post on Ray Camden's site which was helpful in finding the right download - it would be nice if this could be linked from the CFEclipse site.

McAfee's Virus Definition Kills Apps

Mon, 13 Mar 2006 11:54:00 -0400

New on Slashdot and elsewhere about the latest McAfee's virus definitions wiping out a bunch of applications include Office, and according to the Slashdot post - ColdFusion.

I dug around a bit and found this list of affected files and indeed several Java related files are mentioned so it's possible this might trash ColdFusion. More at Sans.org.

Can't Install ColdFusion 6.1

Thu, 16 Feb 2006 00:08:00 -0400

Bobby just ran into this and I have as well so I figured I'd blog this to remember it...

If you try to install ColdFusion 6.1 on Win2003 with SP1 it will fail with no errors. The installer will run but then nothing else will happen.

It's mentioned here on the Macromedia/Adobe site - see note #60086.

From the note:

On Windows 2003 systems with Service Pack 1 (SP1), the installer immediately exits in the "preparing to install" dialog before extracting files. This worked previously on Windows 2003 without SP1.

A feature of Windows 2003 Service Pack 1 is "Data Execution Prevention". This security feature blocks the InstallAnywhere self-extractor for CF 6.1 and all JRun4 Updaters. (CF 7.0 is not affected). To fix this problem, do the following:

Click Start, right click My Computer, and select Properties.
On the Advanced tab, click the [Settings] button under the Performance section.
Select the Data Execution Prevention Tab in the Performance Options dialog
Select the radio button for "Turn on DEP ... except those I select:"
Select "Add" and select the Coldfusion or JRun installer. (the entry shows up as "InstallAnywhere Self-Extractor" in the dialog)
Select "Apply" on the "performance options" and "OK" on the "System Properties" page
Now run the installer

ColdFusion Runs Slower on IIS 6 than IIS 5

Thu, 19 Jan 2006 21:10:00 -0400

Here is an interesting tech note - our development server (IIS 6) has always been slow since I upgraded to Win2003. I will investigate to see if this speeds things up?

Symantec Screws Up ColdFusion and Compression

Wed, 18 Jan 2006 15:13:00 -0400

Saw this interesting article about ColdFusion and Symantec Norton Internet Security bungling compressed content from web servers.

"Something about how CF reassembles its own responses (those it is responsible for serving) seems, in conjunction with compression, to create response entity that the Symantec Norton Internet Security 2006 (NIS 2006) decompression engine on the client side cannot properly handle."

Something to be aware of if you are seeing unexpected output from CF.

Using Access To Cascade Delete A Parent/Child Relationship

Thu, 12 Jan 2006 18:05:00 -0400

Database: Access
Language: ColdFusion/SQL

For a recent project I built a links application which had a parent/child relationship via one table:

CatID > ParentID.

The problem was if you deleted a link category - you would need to also delete any categories under that category (child) as well as any links associated with those categories.

Another negative was there was no way to know the depth of the parent/child relationship so it would take a complex loop to delete everything.

I remember reading something about using the database to do a ‘cascading’ delete so I dug into this and came up with the following solution which lets the database do the heavy work:

First I setup my table as such (notice tblLinkCategory relates to itself - tblLinkCategory_1)

The key to initially setting this relationship is the first record in tblLinkCategory MUST have a NULL value in parentID - since it’s the first record there is nothing to relate to - so a NULL must be used.

Next we just need to setup the cascade - right click on the relationship line between each table to get the properties:

Select “Enforce Referential Integrity” and “Cascade Delete Related Records”

Once you do this you can no longer delete rows with Access open (you will get a ‘table locked’ error) but it works fine via a delete query from ColdFusion.

Now by doing a single delete from the tblLinkCategory table:

delete
from tblLink
where id = <cfqueryparam value="#attributes.id#" cfsqltype="CF_SQL_INTEGER" maxlength="5">

It will delete the category, any sub-categories and any related links to those categories.

SEO, ColdFusion Frameworks and Security, CFAJAX, Wiki Matrix

Tue, 10 Jan 2006 11:12:00 -0400

Two good SEO links (one and two)

ColdFusion Frameworks and Security

Good CFAJAX Example

ColdFusion Perfomance Monitor

Wiki Comparison Matrix

Nice JS/CSS image gizmo

Top 10 Design Mistakes, Google Page Rank, Web Developer Toolbar 1.0

Wed, 04 Jan 2006 12:44:00 -0400

Game 360 Quicktime - Doom and Half Life

Top 10 Design Mistakes for 2005

Google Page Rank and domain registration length

Google 'Safe Browsing' Extension protects you from phishing sites

Sceduling software - article

New WebDeveloper Toolbar Firefox Extension 1.0 - a Firefox must have!

Sean Corfield Framework Presentation

Tue, 03 Jan 2006 00:53:00 -0400

Went to see Sean Corfield give his frameworks presentation at the local Triangle ColdFusion User Group meeting (TACFUG).

Will Tomlinson was there from ColdFusionGear as well with some shirts and mugs - great ColdFusion stuff!

Great presentation - Model Glue looks very interesting but I still like Fusebox for it's simplicity which was what attracted me to ColdFusion in the first place.

Fiddler, CF Memory Leaks, ColdFusion makes the top 20

Fri, 16 Dec 2005 12:27:00 -0400

Fiddler - this looks really neat

Psuedo Memory Leak with CF/Search Bots and Client variables

Nice del.icio.us Firefox Extension

ColdFusion makes it into the top 20 list of programming languages!!

Interesting article on search bots and shopping carts

Two great links on functional specs (one) (two)