Dave Ferguson's Blog

I must have been sleeping under a rock because I missed the release announcement.

jQuery Mobile version 1 is finally released. You can read all about it here... http://jquerymobile.com/blog/2011/11/16/announcing-jquery-mobile-1-0/

Congrats to all involved on creating such a great product.

ThemeRoller for jQuery mobile was released as well. If you were at Adobe MAX 2011 you probably saw it demoed there. Initially I was very excited about the tool. However, after 5 minutes with it I was kinda bummed out. But, take a look at it and form your own opinion... http://jquerymobile.com/themeroller/

Till next time,

--Dave

This entry was posted on November 18, 2011 at 3:56 AM and has received 502 views. There are currently 3 comments. Print this entry.

So, it was asked on twitter if cfspreadsheet could read a csv file. I quickly looked at the docs and it appeared to me that it could. The docs even had this example..

However, if you try and do that you get this error:

So, what I figured out was that cfspreadsheet type="csv" just converts the read xls document into csv format. Not sure how usefull that is.

So, I started digging into a possible solution. Then I stumbled into something. I ran into a post that talked about using cfhttp to load the csv. So, that got me thinking and I ended up with this.

I was shocked that the isQuery returned true. So, since it uses the first row as the column names I write some code to loop over the data and out put it. I honestly didn't think that this would work. I just get totally excited when something that I thought would be hard became super easy thanks to ColdFusion.

I have only ran this against ColdFusion 9 so I am not sure about backwards compatibility.

UPDATE: If the column name contains a space an error will be thrown. The error happens in the cfhttp tag call so you can't correct them post call. Make sure that if you are doing this that your first row contains text that are column name formatted. I.e... use "my_date" instead of "my date".

Till next time...

--Dave

This entry was posted on September 28, 2011 at 11:00 AM and has received 927 views. There are currently 5 comments. Print this entry.

If you happened to miss my ColdFusion Developer week presentation on ColdFusion and Mobile you are in luck. You can just go here: http://adobe.ly/q7XIgC and watch it. Or watch it again if you where there. This is an edited version with the audio drop out section removed.

If you want to watch any of the other presentations from the week you can find the full list of them here: http://www.adobe.com/devnet/coldfusion/events.html

Till next time...

--Dave

This entry was posted on September 20, 2011 at 1:30 PM and has received 626 views. There are currently 1 comments. Print this entry.

Sorry for the delay everyone. Here are the slides and the code for my Adobe Developer Week presentation on ColdFusion and Mobile.

This entry was posted on September 19, 2011 at 10:50 AM and has received 680 views. There are currently 3 comments. Print this entry. Download attachment.

I am mostly bogging this so I don't forget this stupid mistake I made. I am using jQuery to make an ajax call to a CFC. The CFC returns json data that I am using to populate a form.

The call worked just find and data was returned. However, for some reason, in JavaScript the JSON data was not being treated as JSON. I spent ages searching for solutions and doing trial and error.

This is the JavaScript call I was making:

This is the CFC that returned JSON.

Knowing what I know (which I started to question) I should have been able to use "data.DATA" to get to the JSON data in the result. However, when I output it to the console I would get "undefined". I also tried, among other things, "data[0]" which got me "{".

The lovely kicker was that the Chrome debugger network tab showed the call return as JSON.

I continued to try anything I could think of to get JavaScript to understand the return as JSON. All I ended up doing was finding a ton of ways to not process JSON.

Finally, I figured something out. It finally dawned on me that JavaScript was processing the data as a string not JSON. The "Intelligent Guess" feature of $.ajax() in jQuery was apparently failing to see the data as JSON.

I then added " dataType: 'json' " to the ajax call. Once I did that everything started working as expected.

If there is a moral here I would say it is to not expect data types to be auto assigned correctly. If you can, define what the data types will be. this will save you pain and anguish later.

Till next time...

--Dave

This entry was posted on September 5, 2011 at 11:37 PM and has received 638 views. There are currently 2 comments. Print this entry.

Time to get your learning on.. for FREE. Check out Adobe ColdFusion Developer Week for a weeks full of great sessions for the new and old alike.

I am especially excited about this as I am one of the speakers. I will be talking about ColdFusion and Mobile.

Check it out and sign up. http://www.adobe.com/cfusion/event/index.cfm?event=detail&id=1489920&loc=en_us

Till next time,

--Dave

This entry was posted on August 24, 2011 at 10:13 AM and has received 537 views. There are currently 1 comments. Print this entry.

Well.. I ran across this code and wanted to share. I am using it as more of an example of something you probably shouldn't do.

One of the strengths of ColdFusion is to make hard things easy. This code basically ignores that principal and makes hard things harder.

So.. here is the code I found

While in principal the code works. An XML file is generated and written to the server. However there are many issues with this.

1: The XML being written replaced an XML document used by a flash object. If the flash object tried to call the XML while it was being written it would error.

2: IF there was an error in XML generation the system would be left with an invalid and incomplete XML document on the server. This would probably cause the flash object to fail.

3: Causes excess I/O to the file system.

So, how did I fix it? Well easy.. ColdFusion has a built in way to create XML. There are a couple ways to do it but I used the tag approach. It just seemed to fit with the current code.

Here is what I ended up with:

Now the code just generates a single XML var and then writes it at once to the server. If something were to go wrong with the generation the existing XML document will be left untouched. Also, since it is a single write the odds of the flash object being impacted by the new XML are drastically reduced.

So, remember, let ColdFusion do what it does. Don't try and work against it and make your lives harder.

Till next time,

--Dave

This entry was posted on August 22, 2011 at 8:30 PM and has received 907 views. There are currently 4 comments. Print this entry.

Since the show is for the people we would like to know what the people want. We do our best to talk about subject that we feel are of interest. However, we may not have hit on something that interestes you. Also, if there is something we are doing that you are not a fan of let us know that as well.

Use the comments below or email us at podcast@cfhour.com and share your thoughts.

Till next time...

--Dave

This entry was posted on August 22, 2011 at 10:46 AM and has received 592 views. There are currently 1 comments. Print this entry.

While working to restrict an upload I came across an interesting issue with CFFILE. Lets say that this is your code:

The "accept" attribute would restrict to only file with an image mime type. The "thumbs" var names in the results attribute will contain the results of the CFFILE action. If the "result" attribute is omitted the results will end up in a "cffile" var.

Lets say a user uploads a text file instead of an image. We need to check to see if cffile processed the file. This is where the odd behavior comes in.

First, an error will be thrown that has to be trapped. There is no "onError" mechanism built into cffile. Easiest thing to do is to wrap it in a cftry. You can then look at the cfcatch.message for the error.

Next, if there was an error and we tried to check the "thumbs" var we would get another error. This is because the var does not exist. However, if you check for a "cffile" var it is an empty struct.

From what I can tell, if the file does not pass the accept check it is not written to the server. This means there is no cleanup to deal with.

So, the moral of this story is that I wish that cffile had an internal way to handle this. I don't think that wrapping it in a cftry is the best solution.

Till next time,

--Dave

This entry was posted on August 13, 2011 at 10:06 PM and has received 761 views. There are currently 4 comments. Print this entry.

So, how did I get started? For me it was a complete fluke. I actually had no aspirations of getting into technology at all. Infact, I was on my way to being a restaurant manager for Denny's. Following in my mothers footsteps. Then a complete and unexpected event happened and I found my self a ColdFusion programmer.

I was young main in my early 20's. Working at Denny's and just enjoying life. Then, when helping my mom move a refrigerator a freak accident changed my life. I was moving the refrigerator through a door when it fell on me. I suffered a severely messed up ankle and a dislocated hip. My hip went back into place on its own. My ankle was a whole noter story.

I ended up not breaking anything but it would be months before I was able to walk again. It would be years before I could walk for distance without any pain. I spent the next 9 months on crutches and in wheelchairs. I spend many an hour in physical therapy to get my ankle back a useable condition.

It was about a year after my accident that my doctor told me I needed to find a new career. He said I am young and it should not difficult. I was spending lots of time on BBS systems during my healing. So, getting into computers seemed like a good idea. I picked up a few books and did lots of reading. The internet was not the same back then as it was today. Books were still the best way to get accurate information.

Fast forward a couple months. I was sitting in Denny's bar ( yes the Denny's I worked at had a bar) reading of all things "HTML for Dummies". A customer who I knew from when I worked there came up to me. He asked me if I built websites. I said I was just starting out and learning. He offered me the opportunity to create a website for his company. I took the offer and was off to the races.

I was working with a form submission and was having some issues. I talked to a friend and he suggested that I build it using Cold Fusion (yes with a space cause that is how it was spelled back then). The rest is history.

For a more to this story please listen to episode 107 of the CFHour podcast where I tell this story in much more detail.

http://cfhour.com/post.cfm/show-107-new-stuff-and-the-long-road

Till next time,

--Dave

This entry was posted on August 1, 2011 at 5:55 PM and has received 894 views. There are currently 5 comments. Print this entry.