Review: Sprint Mogul vs Sprint Touch

Over the summer, we switched to Sprint and got new phones and I played with the Palm Centro and the HTC Touch. I decided on the Touch for a number of reasons, the main one being that it was Windows Mobile (read very customizable and hackable). As used it and got more comfortable with it, I quickly realized I needed one more thing - a real keyboard. I just couldn't get used to the software keyboard, and despite promises from other Touch users that I'd soon be as good with it as with a real keyboard, it wasn't happening. So I looked for alternatives.

Since I wasn't anywhere close to qualifying for an upgrade, the new Touch phones (the Touch Pro and the Touch Diamond) were out of my price range, so I was left looking for one of the older models or a steal of a price. Of course I could look at BlackBerry's, but the specialty plan I'm on with Sprint doesn't support the BB data, so those were out.

One of the phones I found was the HTC Mogul - technically it's the PPC-6800. It has most of the features of the Touch (the PPC-6900), but it also has a sliding keyboard.

Here's the spec comparison between the two phones (not sure why the HTML is placing so much space between this and the table):

	Sprint Mogul (PPC-6800)	Sprint Touch (PPC-6900)
Installed RAM	64MB SDRAM	128MB SDRAM
Installed ROM	256MB Flash	256MB Flash
Processor	QUALCOMM 400 MHz MSM7500	Texas Instruments 201 MHz OMAP850
Display type	2.8" TFT active matrix	2.8" TFT active matrix
Max Resolution	240 x 320	240 x 320
Data Speed	EV-DO Rev. A	EV-DO Rev. A
Dimensions	2.3 in x 0.7 in x 4.3 in	2.4 in x 0.6 in x 4 in

So the Mogul has less RAM but a faster processor, and about everything else is the same.

To make things better, I have a friend that runs a cell phone shop who had a like-new Mogul on hand that he gave me a steal on - and I picked it up.

So, after a week of playing with it, here's my review:
The Good:
The keyboard is awesome. Look you can talk all you want about how you'll get used to using a software keyboard, blah blah blah, but I couldn't. And after 4 months of playing with it, I'd had enough.
It's also WM6.1 (like the Touch), so the learning curve from the Touch to the Mogul was nil.
It's got Wi-Fi. Yeah, it's cool. In addition, its got a switch on the side so it doesn't kill your battery if you're not using it.
It's got a scroll wheel on the side. That makes it a lot easier to scroll websites and email and such.

The Bad:
It is a little slower than my Touch, which I'm sure is because the RAM is less.
The touch screen is slightly (about 1/8") depressed from the housing, which makes it hard to get to the X in the top right corner or any of the other functions on the edge (like scrolling).
No TouchFLO (I can add it as an app from xda-developers) so no easy access to the 9 most used contacts like the Touch. I'm sure I'll be adding this soon.
It seems to be thicker, although not by much, it is.
The housing is hard plastic, not rubberized plastic, which means it's slippery (yeah, I've dropped it already once).
The GPS is slower to connect than the one in my Touch.

Overall:
I like it. The keyboard alone makes it more than worth the upgrade. Well, that and including the fact that I got taken care of by my friend.



That said, anyone that needs or is interested in a cell phone in the Salt Lake Valley, be sure to stop by the Wireless Giant store at 7200 S State St in Midvale and talk to Pieter. Tell him I sent you and he'll take care of you as well. No, I don't get anything from referring you, but I just like to make sure people that take care of me get rewarded.

Other reviews can be found here:

CNet's Review of the Mogul

CNet's Review of the Touch

Gmail has themes

Gmail finally offers themes for its' web-based Gmail users. That's pretty stinking cool if you ask me.

It's just too bad I use Outlook to pull my Gmail. But....just for fun, I changed my Gmail theme to terminal
<--------------
but, realizing that my eyes couldn't take too much of it, I switched back to something else.

Pretty awesome, google.

ForEach loop in SQL

Have you ever needed to do a ForEach loop in MSSQL? Ever wanted to be able to loop through all results of a query and perform an action? No? I needed to the other day, and it was a PAIN to figure out. So, once I did, I figured I need to document it for others who may be just as stumped.

Before I explain what I found, a quick background of the problem and the structure of the DB would be helpful.

Customer A wants to update each Contract's Remarks field with the combined remarks from all the Contract's Equipment location.

Here's the problem. Each Contract table is linked to a ContractDetails table (one to many). Each ContractDetails table is linked to the Equipments table (one to one). Since a basic update statement with an inner join only updates the contracts based on the first result of the equipment, that won't work. We could potentially have hundreds of equipments tied to each contract.


DECLARE @ContractID INT
DECLARE @Equip Varchar (500)
DECLARE @Location VARCHAR (1024)

DECLARE cur CURSOR FOR
select cd.ContractID, e.equipmentnumber, isnull(e.Location, '')[equipment location]
from contractdetails cd
inner join equipments e on cd.equipmentid = e.equipmentid
order by cd.ContractID

OPEN cur

FETCH NEXT FROM cur INTO @ContractID, @equip, @Location
WHILE @@FETCH_STATUS = 0
BEGIN
IF @Location <> ''
UPDATE Contracts SET Remarks = LEFT(Remarks + char(13) + char(10) + 'Equipment number ' + @Equip + ' is located at ' + @Location + '.', 1024)
WHERE ContractID = @ContractID

FETCH NEXT FROM cur INTO @ContractID, @equip, @Location
END

close cur
deallocate cur


We needed to declare a cursor. The cursor is a collection of results from the select statement (in this case: select cd.ContractID, e.equipmentnumber, isnull(e.Location, '')[equipment location]
from contractdetails cd
inner join equipments e on cd.equipmentid = e.equipmentid
order by cd.ContractID). Once that was done, we open the cur, and Fetch each of the results, one by one, peforming the action (in our case, the update statement) for each result.

The HTPC Project

For that last little while, I'd been tossing around the idea of building an HTPC (Home Theater PC). The reasons for building one were fairly simple:

• Eventually, if built correctly, it can take the place of my $13/month DVR from Comcast
• Expandability (I'll expound)
• It's a geek project

So, being the cheapskate I am, I watched auctions, and waited. And waited. Finally, I found a great auction on eBay for a barebone ASUS PC. The guy had listed it by it's specific model number, which makes it hard to search for. I ended up winning this computer (brand new case, motherboard, and PSU) for $35 after shipping.

Once I got that, I added these components:

• Hauppauge HVR-1600 TV Tuner
• Hitachi 500GB SATA HD for media (I have a 120GB SATA drive for the OS and programs)
  
• AMD BE-2400 2.3Ghz X2 45W Processor
• ASUS HD3450 HDMI Video Card
• 2GB PQi PC2-4200 RAM
• and an old 16x DVD-RW I had lying around

So, it's a pretty good setup, for not a lot of $$$.

The next decision was what OS to use. From various Microsoft trials and things I'd done, I had 64-bit and 32-bit Vista Ultimate, as well as XP Media Center Edition 2005. Add to that the tons of flavors of free OS's out there specifically for this purchase (MythTV, SageTV, etc).

Due to my relative inexperience with Linux (I'm learning it as we speak), as well as my desire to do more than simple TV Capture with this box (you can see that my specs dwarf the MythTV requirements) ruled out Linux and all his relatives.

Then, because I didn't want (or need) the overhead of Vista on this machine, I decided to stick with XP MCE.

Once that was setup, it was pretty simple to set the Media Center portion up. A lot of pointing and clicking and letting Windows do it's thing finding the channels based on my zip code and so forth.

In addition, I decided to not hook the PC straight into my TV via HDMI. This was partly decided by the fact that the video card was bad and needed to be RMA'd (thank heavens Newegg has the world's best customer service...I highly recommend them for all computer needs), partly decided because I didn't feel the need to shell out the cash for an HDMI switcher and more cables, and mostly decided by the fact that I already have an XBox 360 that can serve as a MCE extender, eliminating the need to fiddle with an IR and blaster, as well as allowing me to keep the HTPC in my office.

I also am using the HTPC as a media streaming device. Orb, a free piece of software, allows me to stream my media to anywhere, as long as I have the internet, with ease. Install it, tell it where to find my media and what I want to share. Then, set up usernames and passwords for anyone I want to have access to it.
Then, simply browse to http://mycast.orb.com/, enter the username and password, and decide if I want to look at pictures, listen to my music, or watch shows (if the tuner is supported). This is especially cool for me, as I'm about to start traveling more for work, and really don't want to have to dump all 60GB+ of my music onto my laptop. The downside? If your upload speeds suck...so does your streaming experience.

So, as I've been playing, I've found things I like, and things I don't. I still haven't found a good way to stream non-Windows standard video types (such as xVids or non-standard AVI's) to the 360.

I like the media remote for the 360. It's got most everything you need and works really well.

So, for those out there are already using it, what toys or programs are you using, and what do you like about it?

The Beginning

So I've come to grips with the fact that I'm a tech-geek. I like to get my hands on the latest gadgets. I like to learn new stuff about those gadgets. And you know what? I'm okay with that.

So, rather than boring those that read my family blog with details of the latest trick I learned with SQL scripting, or the cool thing I did with my HTPC, I'll post them here. That way, those that care can check it out, and those that don't....well...they don't have to be bored. Besides, lets be honest, there's a lot of people that don't even know what an HTPC is, let alone understand the specs that I'm running on it.

So that said, yes I am a geek, and I'm okay with it!