Monthly Archives: September 2008

Job Opening in Orlando Area

My friend Rob from Hudson IT is seeking a ColdFusion developer for Orlando, Florida area. Here is the summary:

Our established client is seeking an experienced ColdFusion Developer (MX 6.1) to join their IT department and responsible for fulfilling the technology and business process improvements needs. This person will work side by side a Sr ColdFusion developer and report directly to the IT Director. This role will involve full SDLC project work while interfacing with accounting and marketing users. Any .Net experience would be helpful as a migration from ColdFusion to .Net is being considered.

For more information, contact Rob [rob.bertino(at)hudson.com].

Read More…

T-Mobile Introduces the G1, First Google Android Phone

Today in New York, T-Mobile introduced the first cell phone to use Google’s Android O.S., and announced the sales starting October in the U.S. for about $180. The data plan starts at $25 and includes free Gmail account, and comes with Google Maps. The phone includes 3G and Wi-Fi access, a 3Mp camera and an accelerometer.
Well, I have been using T-mobile for a very long time and I’m very satisfied with their services, that’s why I have not bought an iPhone yet. Now I have no more excuses to jump on the band-wagon of the 3G access. Here are some pictures and the link to an article.
T-Mobile G3 Photo 1T-Mobile G3 Photo 2T-Mobile G3 Photo 3T-Mobile G3 Photo 4T-Mobile G3 Photo 5

Split List Table-Valued Function

Continuing my previous blog about splitting a list to insert data into a table, we could transform the stored procedure into a table-valued function that you can flaunt using your best hosting.
Using the same example list as before, let’s create the function for this list
<cfset addCartValues=”P555|2,P444|1,P333|2″ />
You may download the function here.

Read More…

Looping Through a List Using T-SQL

Usually we have to loop through lists to insert or update data, and some of us choose to use ColdFusion tag CFLOOP with an inner query to do that job. That will cause several connections to the database (one for each member of the loop). One way to avoid that, other than create a huge CFQUERY tag with several inserts, is to write a store procedure and with just one connection to the database, let the SQL take care of the list loop and do its job of inserting or updating data.
You may download the stored procedure here.

Read More…