Viewing entries posted in January 2011

AS3/Flex toOrdinal

Posted by Alexis on 24 January 2011 | 0 Comments

Tags: ,

Over the weekend I had to put together a small Flex project to illustrate data in a pie graph. Also the data had to read in terms of its placement 1st 2d 3rd or 4th. While there are Flex validators for these types of things I prefer to write in Actionscript. I find it easier to follow and easily reusable in other non Flex projects.

0 comments | Read the full post

Interger Primary Key as Rowid SQLite

Posted by Alexis on 17 January 2011 | 1 Comments

Tags:

Interesting quirk about SQLite table PRIMARY KEY's. I've been using ID as my table KEY name, a habbit adobted from MySQL. And in recent SQLite development I've been using

1 comments | Read the full post

Insert Or Update if row exists AIR SQLite

Posted by Alexis on 16 January 2011 | 0 Comments

Tags: ,

OK leading on from the previous post, here's a solution for the INSERT or UPDATE if row exists which seems like a very common question in forums.

0 comments | Read the full post

3115 Error with SQLite

Posted by Alexis on 16 January 2011 | 0 Comments

Tags: ,

I'm doing some work with SQLite in Adobe AIR. Doing some tests to figure out a cleaver TRIGGER to UPDATE or INSERT appropriately.

0 comments | Read the full post

Fun with a green screen

Posted by Alexis on 14 January 2011 | 0 Comments

Tags: ,

While putting this site together I thought it'd be fun to have a laugh. Getting photographs of myself looking like an idiot, and compiling them together for the site.

0 comments | Read the full post