You name it, it's fair game here: Android development, Windows, C#, Java, my pet, Video Games, Xbox, and Twitter. This is where I dump bits that may be helpful. Or not.

Monday, December 14, 2009

Shameless plug for ToMarket Android App

OK, some of you know that I have an Android App in the Android Market called ToMarket. It is a convenient little shopping App that has a bit of a following. As I decide where to go next with it in it's evolution I have a new website called www.ToMarketWeb.com that will host web services and possibly an online version of the app. Chaeck the site out - log into the forum and say hello if you like.

Tuesday, December 1, 2009

SQL Order By using columns of Strings that may be numbers...

Had a column of type string that may be numbers that are entered by the user of an application. The user is allowed to sort, but using the standard "order by colname asc" can give this nasty list:

1
12
19
3
4
44
7
acorns
beer

Changing the command to read "order by cast(colname as signed) asc" makes the list much prettier:

1
3
4
7
12
19
44
acorns
beer

This syntax was using MySQL, but should port nicely elsewhere.

Command Completion at DOS Prompt

I always search for the trick to make your command prompt have auto completion when when you hit the tab key, so I am writing it down here for everyone to bask in the auto-complete glory...

1. Run regedit (start->run type regedit and hit enter)
2. Find HKEY_CURRENT_USER\Software\Microsoft\Command Processor
3. Click the "Command Processor" item and in the right pane double click "CompletionChar"
4. In the value data textbox, enter 9 and press ok.
5. Close regedit and restart any command prompts you want to tab instead of type in.

Enjoy!