USawIt

USawIt's Profile

Name:

Michael Givens

Email:

owner@u-saw-it.com

IM:

	AOL/AIM:	webcfml
	Google:	zacktg
	MSN:	owner@u-saw-it.com

Twitter Name:

Website:

Blog:

Portfolio:

About Me:

Adobe Community Experts

Michael_Givens

Skills

Adobe products
Flex / AIR
ColdFusion
JRun
Captivate
Contribute
Acrobat

Technologies
ColdFusion, ActionScript, MXML,
HTML, DHTML, XML, JavaScript,
Java, ASP, ASP.NET, Apache / IIS
Webservers

Adobe Certifications
Macromedia CF 5 Developer
Macromedia Advanced CFMX
Developer Adobe CFMX
Developer

Other Certifications:
HIPPA (Security)
Anatomy & Physiology
Medical Terminology

Languages
English & Chinese

Michael Givens

Spring, Texas

Biography

Michael Givens is the CTO of U Saw It Enterprises, a Web technology
consulting firm based in Spring, TX. As a multi-years experienced web
technology specialist, he is willing to shift gears at a moment’s notice to the
Client’s technology of choice. He is both an Adobe Community Expert and an
Adobe Corporate Champion known to share his experience and evangelism of
all things Adobe. Certified both in ColdFusion 5 and as an advanced CFMX
developer, he has written Adobe Apollo in Flight (Digital Short Cut), co-written
Adobe AIR Programming Unleashed, written Sams Teach Yourself AIR Programming in 24 Hours, numerous articles, and blogs regularly at www.flexination.info.

Credits

Web Sites & Blogs

Flexination.info (http://www.flexination.info) My Web Technology Blog Site

WebMXML.com (http://www.webmxml.com) My Flex Example Site

WebCFMX.com (http://www.webcfmx.com) My Corporate Champion Site

WebApollo.info (http://www.webapollo.info) My Apollo Example Site
MXNA Blog Posts
Articles
ColdFusion Developer’s Journal – Creating a Flex 2 Signature Grabber
(http://coldfusion.sys-con.com/author/mgivens.htm)
Flex Developer’s Journal – Video Rock ‘n Roll With Flex 2
(http://flex.sys-con.com/author/mgivens.htm)

Discussion groups

Forums

FlexCoders (http://tech.groups.yahoo.com/group/flexcoders/)
Flex Components (http://tech.groups.yahoo.com/group/flexcomponents)
SilvaFug (http://www.silvafug.org/)
Ajax and RIA (http://tech.groups.yahoo.com/group/ajax_and_ria)

Company:

U Saw It Enterprises

Position:

CTO

Company Address:

3715 Sapling Trail
Spring, TX 77388
google map

Company Site:

Company

My Products:

Acrobat, ActionScript, Adobe Media Player, AIR, Blaze DS, Captivate, ColdFusion, Contribute, Dreamweaver, Fireworks, Flash, Flash Media Server, Flex, Flex Builder, Master Collection, RIA - Rich Internet Applications, Spry, Web Development

Adobe Expertise:

I know a lot

Interests:

<p>I simply enjoy working with web technologies and AIR. To me it's not just a job, it's a hobby that I get tons of satisfaction from.</p>

Recent Work:

Recent Code:

<?xml version="1.0" encoding="utf-8"?>
<mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" title="AIR - Encrypted SQL Local Database" layout="absolute" width="279" height="276" backgroundColor="#3E058B">
  <mx:Script>
    <![CDATA[
      import flash.net.Responder;
      import mx.collections.ICollectionView;
      import flash.data.*
      import flash.filesystem.File;
      import flash.net.Responder;
      private var dbConn:SQLConnection = new SQLConnection();
      private var dbStatement:SQLStatement = new SQLStatement();
      private var employeeResponder:Responder = new Responder(employeeResult);
      [Bindable] private var employeeCollection:Array;
      private function init(): void {
          // prepare a bytearray for encryption key 
          var mySeed:String = "AIR15IsAGreatProduct";
        var myKey:ByteArray = new ByteArray();
        var i:int = 0;
        for (var j:int=0; j<16; j++) {
          i = (hexToInt(mySeed.charCodeAt(j))*15) + hexToInt(mySeed.charCodeAt(j+1));
          myKey.writeByte(i&0x00FF);
        }
        var dbFile:File = File.desktopDirectory.resolvePath("Encryptedemployees.db");
        dbConn.addEventListener(SQLEvent.OPEN, connOpenHandler);
        dbConn.addEventListener(SQLErrorEvent.ERROR, errorHandler);
        dbStatement.sqlConnection = dbConn;
        dbConn.open(dbFile, SQLMode.CREATE, false, 1024, myKey);
      }
      private function hexToInt(hex:Number):int {  
        return parseInt("0x" + hex);  
      }
      private function connOpenHandler(event:SQLEvent): void {
         initTable();
      }
      private function initTable(): void {
        dbStatement.text = "CREATE TABLE IF NOT EXISTS employees ( id INTEGER PRIMARY KEY, name TEXT, description TEXT )";
        dbStatement.addEventListener(SQLEvent.RESULT, insertEmployees);
        dbStatement.execute();
      }
      private function insertEmployees(event:SQLEvent): void {
        dbStatement.removeEventListener(SQLEvent.RESULT, insertEmployees);
        dbStatement.addEventListener(SQLEvent.RESULT, getEmployees);
        dbStatement.text = "INSERT INTO employees (name, description) VALUES ('Meriadoc Brandybuck', 'Friend of Frodo')";
        dbStatement.execute();
      }
      private function getEmployees(event:SQLEvent): void {
        dbStatement.removeEventListener(SQLEvent.RESULT, getEmployees);
        dbStatement.text = "SELECT * FROM employees"
        dbStatement.execute(-1, employeeResponder);
      }
      private function employeeResult(result:SQLResult): void {
        employeeCollection = result.data;
      }
      private function errorHandler(error:SQLError): void {
        trace("Failure.");
        trace("code: " + error.errorID);
        trace("operation:" + error.operation);
        trace("details:" + error.message);
      }
    ]]>
  </mx:Script>
<mx:DataGrid dataProvider="{employeeCollection}" creationComplete="init()" verticalCenter="1" horizontalCenter="0" width="236" height="214">
  <mx:columns>
    <mx:DataGridColumn dataField="name" headerText="Name"/>
    <mx:DataGridColumn dataField="description" headerText="Descriptiom"/>
  </mx:columns>
</mx:DataGrid>
</mx:WindowedApplication>

Recent Code File:

AIRSQLEncrypted.zip (1KB)

Stats

Last online Oct 04
Joined 10/18/08

Groups

USawIt is a member of the following Groups:

Austin Flex User Group
public, Group - North America, 24 Members
Houston Adobe Users Group
public, Group - North America, 56 Members
find community
Houston ColdFusion Users Group
public, Group - North America, 18 Members
LA AIR
public, Group - North America, 30 Members
Los Angeles Professional Adobe AIR Development User Group
Online ColdFusion Meetup
public, Group - Virtual, 232 Members
The Online ColdFusion user group
SilvaFUG
public, Group - North America, 56 Members
Silicon Valley Flex User Group (SilvaFUG)
VegasFUG
public, Group - North America, 58 Members
Las Vegas Flash Platform User Group

Adobe Groups

USawIt

USawIt's Profile

Adobe Community Experts

Skills

Adobe products Flex / AIR ColdFusion JRun Captivate Contribute Acrobat

Technologies ColdFusion, ActionScript, MXML, HTML, DHTML, XML, JavaScript, Java, ASP, ASP.NET, Apache / IIS Webservers

Adobe Certifications Macromedia CF 5 Developer Macromedia Advanced CFMX Developer Adobe CFMX Developer

Other Certifications: HIPPA (Security) Anatomy & Physiology Medical Terminology

Languages English & Chinese

Michael Givens

Biography

Credits

Web Sites & Blogs

Articles

Discussion groups

Stats

Groups

Adobe products
Flex / AIR
ColdFusion
JRun
Captivate
Contribute
Acrobat

Technologies
ColdFusion, ActionScript, MXML,
HTML, DHTML, XML, JavaScript,
Java, ASP, ASP.NET, Apache / IIS
Webservers

Adobe Certifications
Macromedia CF 5 Developer
Macromedia Advanced CFMX
Developer Adobe CFMX
Developer

Other Certifications:
HIPPA (Security)
Anatomy & Physiology
Medical Terminology

Languages
English & Chinese