Wednesday, January 18, 2012

CM9 Alpha0 released for HP Touchpad

Seems that HP Touchpad is on a roll this month as CyanogenMod 9 Alpha 0 has been released for it yesterday. It looks very nice but still there's a very long way to go as the following still don't work:
  • Hardware accelaration - hence no Netflix and YouTube only works in SD mode
  • Audio is messed up and microphone does not work yet
  • Camera does not work as the hardware drivers are closed source
  • Most hardware problems from CM7 have been inherited
  • TP does not show as an external USB drive when connected
To get this on your TP, you need to do the following:
  1. Download the following 3 files and put them in a folder called cminstall in the root of yout Touchpad:
    1. CM9 Alpha0 from here or here
    2. Clockwork Recovery from here, and
    3. Moboot from here
  2. Install NovaCom drivers on you PC/laptop from here or here or here if you do not have them already
  3. Ensure that Development mode is on in your Touchpad and connect it to the PC in USB mode
  4. Run the command
    novacom boot mem:// < ACMEInstaller2
    and twiddle your fingers while waiting for the install to run & complete!
It looks quite good for an Alpha0 release - let's hope it progresses faster and better!
P.S.: Please let me know if the above does not work for you or if there's any step missing :)
You read more details about the CM9 Alpha0 release on the rootzwiki.

Thursday, January 12, 2012

webOS 3.0.5 update released for TouchPad

Good news for those of use still holding on to our TouchPads from the fire sale! HP has released the latest update for webOS 3.0.5 86 Over-The-Air for TouchPads. Good to see that it (allegedly) fixes the bugging audio issue that got introduced in the 3.0.4 update. It also has some good updates related to sensor, camera and HTML5 video playback.
Read more details on their HP webOS Developer Blog and in the webOS 3.0.5 release notes.

Tuesday, January 10, 2012

Count occurance of character in a string

To count the number of times a particular character occurs in a string, use the below SQL query.
If you are using Oracle 11, you can use the new REGEXP_COUNT - note that it uses regular expressions and so special character need to be escaped:

SELECT  REGEXP_COUNT (first_name, '\.') 
AS dot_count 
FROM employee;

If you are using any other version of Oracle, then use this query:

SELECT  first_name, 
LENGTH (first_name) - LENGTH (REPLACE (first_name, '.')) 
AS dot_count 
FROM employee;


Related Posts Plugin for WordPress, Blogger...