my team is looking for an experienced coldfusion developer for a contract position

The Population Health team of Mayo Clinic Global Products and Services is looking for an experienced ColdFusion contractor with strong SQL skills to help with maintenance and development of new projects.

Candidate should have these skills/experience:
ColdFusion 7/8/9
Using CFCs
Consuming and creating Web Services
Creating MVC ColdFusion applications
Bean, DAO and Gateway methodology
Use of any ColdFusion Framework (i.e. Model Glue, Fusebox, Mach-II, ColdSpring)
Database development (including queries, table creation, stored procedures and UDFs)
JavaScript, specifically AJAX frameworks (i.e. jQuery, Prototype, Scriptaculous)
Strong communication skills
.Net development is a plus but is not required

Initial contract length is 6 months.

If you are interested send me an email at sonnenberg dot johann at mayo dot edu.

fckeditor and setting up the aspell spell checker on mac osx

My team uses the FCKEditor for some rich text editing on one of our products. A new requirement requested of us by product development, is that the editor have spell check enabled. So, I started digging. It sounds like the Aspell spell checker is the one to go with. Enabled like this:

FCKConfig.SpellChecker = 'SpellerPages';

Our servers are Windows servers, but we do our development on our local machines. Half of our developers use Macs and the other half are on Windows. This is where the problem comes in. I need to get it to work in both environments.

So, I am attempting to get the spell checking working on my MacBook Pro. I downloaded and installed aspell and successfully tested it with this command in Terminal:

echo "this word is mispeled" | /opt/local/bin/aspell -a -d american -H

So, that works. That returns a list of potentials for the misspelled word(s).

But, I needed to modify the spellchecker.cfm file because the stock cfexecute is set up for a Windows environment. Here is the original call:

<cfexecute name="cmd.exe" arguments='/c type "#tempfile_in#" | "#aspell_dir#\aspell.exe" #aspell_opts# > "#tempfile_out#"' timeout="100"/>

Here is the call that I modified it to:

<cfexecute name="/opt/local/bin/aspell" arguments='-c -type "#tempfile_in#" | -a --lang=en_US --encoding=utf-8 -H > "#tempfile_out#"' timeout="100" />

The problem is, is the system hangs for quite some time and I have not gotten it to return in a timely fashion, or at all. The second file is created with the suggestions, but the server hangs. What am I missing in my arguments? Or is there a better way to call it?

I am not an expert at Aspell, as I just downloaded it yesterday. I have been digging through the documentation but have not come up with a solution. Any help would be appreciated!

***UPDATE***
I am making some progress on this this morning. Here is the code that I have called from Terminal on my Mac...and it works there!

cat "/pathToFile/textToCheck.txt" | aspell -a --lang=en_US --encoding=utf-8 -H --rem-sgml-check=alt > "/pathToFile/dude.txt"

I still cannot get that to work with cfexecute. Anyone have any ideas? It would be just like in the DOS command "/c" which I thought was "script" on Unix, but I still can't get it to work.

***UPDATE AND FIX***
I found the fix! After 8+ hours of working through this, I finally got it to work! The "command" is different between Terminal on a Mac and cfexecut. In the cfexecute call, you need to use "bash" and tell it with the -c and quotes that you are running in command line mode. Here they both are. I hope this helps Mac and Unix users!

In Terminal:

cat "/pathToFile/textToCheck.txt" | aspell -a --lang=en_US --encoding=utf-8 -H --rem-sgml-check=alt > "/pathToFile/dude.txt"

From cfexecute:

<cfexecute name="/bin/bash" arguments='-c "cat #tempfile_in# | #aspell_dir# -a --lang=en_US --encoding=utf-8 -H > #tempfile_out#"' timeout="100" />

Here are some links that helped me get it to work!

http://www.yolinux.com/TUTORIALS/unix_for_dos_users.html

http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000243.htm

my team is looking for a senior coldfusion developer

My team here at Mayo Clinic is looking for a Senior level ColdFusion developer for our team! Here is the official job posting. If you have questions that are not answered by the posting, just post a comment to this post.

Senior Analyst Programmer

Mayo Clinic in Rochester, MN, is seeking qualified candidates for the position of Senior Analyst Programmer. Our Global Product Service is in immediate need of a highly motivated individual to be part of the Population Health technical team who is capable of designing and implementing interactive web-based applications and services. Duties will include supporting the monitoring and maintenance of multiple web sites and working closely with other members of the Population Health technical team to help architect applications for the EmbodyHealth portal. You will also assist in the integration of EmbodyHealth with other business units at Mayo and other vendor partners. To qualify, you must have a Bachelor's degree and three years of professional software development experience; or an Associate's degree and five years professional software development experience; or nine years of professional software development experience. Three to five years' experience in web application development and a background working with ColdFusion are required. Experience in data modeling and design on enterprise level DB such as Microsoft SQL Server is also essential

Mayo Clinic, one of Fortune magazine's "100 Best Companies to Work For," offers an excellent salary and benefits package. To apply or learn more about this or other opportunities, please visit http://www.mayo-clinic-jobs.com/job/ROCHESTER,-MN-Senior-Analyst-Programmer-23956-Job/497314/

Stephanie Bowron, Human Resources Phone: 800-562-7984

Mayo Clinic is an affirmative action and equal opportunity employer. Post-offer/pre-employment screening is required.

senior coldfusion programmer/analyst and sql server application dba positions open on my team

My team is growing and expanding our business and we need another ColdFusion programmer and a SQL Server DBA!

Our team is small but growing here at the Mayo Clinic. We use ColdFusion 8.0.1 and SQL Server 2005. We work in a fast-paced environment and work on fun projects and get to do R&D as well. The team I work with is awesome. We have fun every day and I get to work with ColdFusion which is awesome!

The product that we work on is a Health and Wellness portal for clients. This includes a Health Assessment, other health programs (handling stress, smoking cessation, etc.). We are also getting in to Flex applications.

You can find the Senior Programmer/Analyst job by going to MayoClinic.org click "Find a Job" and type in "23956" for the posting number.

You can find the Senior Systems Software DBA job by following the same steps as above but use "23919" for the posting number.

Also, and this is key, we now have the option for employees to work two or three days up in the Twin Cities at our new office in Eagan, and then work two days down here in Rochester.

If you have questions, you can send me an email at johann dot sonnenberg at gmail dot com.

sql server 2005 varchar(max) and coldfusion cfprocparam cfsqltype

For the applications that my team supports and builds, we are finally making the move from SQL Server 2000 to SQL Server 2005. We have been running in SQL 2000 compatibility mode for a while and are now making the switch.

We wanted to use the new varchar(max) data type which is new to SQL Server 2005, but we didn't know what cf_sql_type in the cfprocparam tag mapped to varchar(max). So, I did some testing.

I created a datasource to our new 2005 database I'll call tempworks. In tempworks we have a table person with columns: personID INT IDENTITY, userName VARCHAR(100), and personNotes VARCHAR(max). We use stored procedures to access the database for all transactions. So I built an insert proc with a call that looks like this:

<cfstoredproc procedure="getPerson" datasource="#personDatasource#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" type="IN" value="#arguments.userName#">
<cfprocparam cfsqltype="CF_SQL_CLOB" type="IN" value="#arguments.personNotes#">
<cfprocresult name="qInsertPerson">
</cfstoredproc>

This worked with a cfsqltype of CF_SQL_CLOB, but really VARCHAR(max) is not a CLOB or TEXT in SQL Server. So, I used CF_SQL_LONGVARCHAR in place of CF_SQL_CLOB and that worked as well. I was inserting personNotes with a length of over 140,000 characters to give it a real test. I also changed my datasource settings to "Enable long text retrieval (CLOB)." and it worked with both cfsqltypes with that setting on and off. I am using ColdFusion 8.0.1 developer edition.

I could not find any documentation for this mapping, so I thought I would post it for others who are looking for this information as well. Oh yeah, and so I don't forget this either!

coldfusion encrypt/decrypt with sql server and ssl connection

Since my last post, from which I really appreciate all of the help, we have decided to do all of the encryption on the database side. Not using the .Net stuff, but just using the built-in encryption/decryption methods for SQL Server 2005.

Here is my next problem though. Because the data will be transmitted from the web servers to the database servers (both in clusters) in plain text, we need to encrypt the data transfer between the servers.

We have identified two options (but I am looking for more too):

1. Use the SSL encryption option on the SQL Server and have CF put the cert into the Java keystore and connect that way.

2. Use IPsec tunneling on both the web servers and the database servers.

Here is what we have done so far. We have created a cert on our development SQL Server, exported the cert, and imported it into the Java keystore (using keytool) so CF can see it. But, we have had no luck getting connected. We have SSL encryption turned on and have it set that all connections must use it. We still see an error of:

Connection verification failed for data source: adventureworks
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.

Has anyone done this before? Are we missing a JDBC connection string parameter? We have looked at the DataDirect JDBC Driver documentation, and have tried many variations without success.

If anyone has any experience with either the SSL encryption using JDBC with SQL Server and ColdFusion, please comment. Or, if anyone has any experience with IPsec tunneling, please comment. Thanks for the help!

More Entries

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