sqlite is missing several basic database features compared to typical SQL servers and unfortunately padding is one of them. For a most situations though, you can use a simple hack to get the same functionality. This trick uses a combination of concatenation and substr: — the statement below is almost the same as — select [...]
Archive | January 12, 2010
Installing Flex Formatter Plugin
If you like your code clean and with proper doc block comments, Flex Formatter is a handy plugin for Flex Builder 3. The plugin installs in Eclipse by simply dragging the files into the plugin directory, however with Flex Builder you can install from a remote install site hosted on the google code site. To [...]
Flex: All your dates are belong to us
I feel like I’m constantly ranting about Flex’s implementation of Dates. This week I just discovered a new “feature” that is even more annoying to me. Without going over it all again, Flex dates are timezone aware and the UTC offset is automatically calculated for you. The problem is that you are locked into displaying [...]
