Goodby CFUnited, Perhaps next year

I have planned unsuccessfully to get to CFUnited. But the for last 6+ years, other obligations have interfered for that week..... So, I get my oxes out of the ditch (which included a funeral, a few surgeries to repair cycling injuries, mom-in-law getting 2 hip replacements...you get the picture) to clear July-August 2011 to attend Next Year -- 2011...

(sigh) My friend Gene Godsey broke that news to me, no next year.... (sigh).

So Here's My VOTE: Have it somewhere, somehow, someway and Honey House Web Designs WILL be there! PLease, please (please)....

HHWD Hiring ColdFusion Developers - Updated

WOW! What a year! Due to our expanding backlog of work, Honey House Web Designs is expanding our workforce. Update: We are looking for experienced CF coders, as well as subcontractors and Internet IT professionals.

If you are a Coldfusion developer who is proficient in

  • CF 8 or 9,
  • CFC beans and Data Objects,
  • CSS based designs,
  • Java
  • Server Management

If you are proficient in Flash/Flex, CFEclipse, FusionDebug, these are added bonus.

Candidates should live in the South East, (no relocation offered). Some telecommuting may be possible within a 150 mile radius in the beginning, but you must be an organized self-starter who can work without tons of oversight.

Please send your resume and project sample links to hhd - at - honeyhousedesigns.com (you know the schpeal).

CF / IIS Service LockUp when using CFMX7, MS Access, and File Uploads

A client regularly uploads an Access database (I know, I know, not the best one for the job.. but the point is another blog/argument) which is then a CFMX7 datasource.

Occasionally and intermittently over the last few years, the .mdb file would be locked, showing the corresponding .ldb file and the uploads would fail. But these files weren't just locked. They were so tightly bound, that FTP deletes would not delete. Even the hosting support personnel could not delete. They had to shut down the CF server, and IIS to delete the files and then restart. Not good news for other accounts the shared hosting server.

Even more interesting is that all of a sudden, the problem became more frequent (locking 6 times yesterday, and 5 more today)... and thus, replicable. It appears as if CF Access datasource connection creates the lock (appropriately) when a query of any sort is performed, even SELECT statements. Attempting an upload while the file is "locked" however doesn't just reject the upload, it corrupts the files and the service.

We don't know what changed, but every single upload now locks. and I suspect the java method that creates the datasource link may lock the database at the application.cfc level. (Any CF/JAVA wizards, please feel free to chime in on this suspician if you know one way or the other). IIS is v6.

To correct this, have the CF Administrator UNcheck that the "maintain database connections" . Creating a "dummy" query is only for pre CF6.

BlogCFC was created by Raymond Camden. This blog is running version 5.9.1.002. Contact HHWD