Hands on Adobe AIR at the next Twin Cities CFUG

On Wednesday, September 2nd, I will be presenting at the Twin Cities ColdFusion User Group meeting. At this meeting we are going to be trying something new (at least for me since I have been going to the CFUG). We are going to do some hands-on work with the technologies we love instead of just doing a lecture-style presentation.

The work we will be doing is with Adobe AIR, JavaScript, jQuery, and SQLite. Here is the description for the session:


Using SQLite Databases with AIR - Part 5 - Parameterizing Queries

In a previous post we looked at doing simple CRUD with Adobe AIR and SQLite and doing CREATE TABLE statements. But the examples we've looked at are VERY simple. In fact, we have not looked at any dynamically constructed queries.

Today I want to look at properly building dynamic queries in AIR using bind parameters.


Using SQLite Databases with AIR - Part 4 - Simple CRUD

So in case you you've been living under a rock for the last several years, you know that CRUD stands for Create, Read, Update and Delete. Which is what we are going to look at today, doing simple SQL statements with SQLite databases in Adobe AIR using JavaScript.

We saw in my last couple posts how do do simple CREATE statements using both synchronous and asynchronous connections. I will paste them here again so that we have the reference all on one page.


Using SQLite Databases with AIR - Part 3 - Asynchronous Database Connection

So in my last AIR and SQLite post we talked about Synchronous Database Connections in AIR.

In many cases, synchronous connections may be all you need. If your queries are fast and a slight applicaiton pause is not a concern, or if you have a need for rigid program flow control, then synchronous connections are great. But there may come a time when you do not want the program to pause during a query, or series of queries. You may want the user to be able to continue working while the queries take place in the background. This is where asynchronous queries come in.


Building an AIR Application with HTML and jQuery - Connect Recording

Last night I got together, online, with Todd Raffery, Ben Nadel and Andy Matthews to talk about Adobe AIR and jQuery.

Last week, while twittering, we came up with the idea of having a "virtual classroom" setting, using Adobe Connect to get together and work through building an AIR application from scratch. So we did just that. This was a private session, so don't feel like you missed an announcement. I wanted to keep it small and informal so that we could feel OK about speaking freely, having fun and learning through questions and discussion.


Unselecting Radio Buttons with jQuery

I got a weird request from one of my internal customers today. In one of our applications he wanted to be able to "uncheck" radio buttons.

We all know that if you have a group of radio buttons, like this, that once you select one option, you cannot unselect an option, you can only change from one option to another.


jQuery and AIR: Desktop Development for the Front End Designer with Andy Matthews

UPDATE: For anyone that may have missed this, here is the recording URL:

Unfortunately, we cannot all be in the beautiful city of Nashville tonight to see Andy Matthew present his jQuery and AIR: Desktop Development for the Front End Designer. And we weren't all at cf.Objective to catch it there (I was, it was great). But, you can still see it in person or online TONIGHT!

I think this presentation is a "must see". Not just for the Front End Designer, but for any of us who want to see the power of Adobe AIR when combined with something as fantastic and jQuery.


Cross-Domain Requests in Adobe AIR - Security Series #13

At cf.Objective() this last week, one of the topics of discussion after Samer Sadek's excellent Adobe AIR presentation was about cross-domain restrictions in Adobe AIR applications written with JavaScript. I do not know if this discussion is relevant with AIR applications written with Flex.

As many may know, and if you don't you should read up on this, most browsers implement a "same-origin" policy on JavaScript run within the browser. This means that JavaScript is free to use any resource available from within the domain that it is running, but it cannot use remote resources.


More Handy JavaScript - Array push() and pop()

The other day I was work on my AIR application, and I came across a need for an Array function in JavaScript that was similar to the ColdFusion function ArrayAppend(), that would add a new value to the end of an Array. Then I remembered something my brother told me about push() and pop() in Java.

So I looked into it, and sure enough, JavaScript arrays have the push() and pop() methods. I did not know this. I'm sure some JavaScript gurus are shaking their heads at my lack of such simple knowledge, but regardless, I did not know. And since I did not know, perhaps some others might not either, so I thought I would share.


Using the Adobe AIR Encrypted Local Store

The Encrypted Local Store in the Adobe Integrated Runtime (AIR) can be used to store data on the user's local machine in a safe and persistent way. The data persists between application launch instances. Once something is placed into the Encrypted Local Store it is there to stay until it is removed or the files are deleted.

A separate Encrypted Local Store is set up for each AIR application on a machine and for each user of that machine. So essentially, each user gets their own Encrypted Local Store for each AIR application they use.

Using the Encrypted Local Store

Using the Encrypted Local Store is quite easy. It is available in the flash.data package and can be called from an HTML/Ajax AIR application without needing to include any other JS files.


More Entries

BlogCFC was created by Raymond Camden. This blog is running version 5.9.1. Contact Blog Owner