Wednesday, August 29, 2007
Nokia 6610 with IMAP
I've just got a
Nokia 6610 (and very nice it is too) and have spent the last couple of days configuring it. As I have a months free internet usage (thanks
Vodafone), I thought I'd make use of it. I set my email settings up (I use IMAP) and could send and receive emails, however, messages deleted from my IMAP server, weren't being deleted from my phone's inbox. This confused me for quite some time, and I couldn't find anything on the internet to help me so I fiddled with a few settings until I got it to work.
Within the E-mail settings section there are 4 options:
Connection settings - the incoming and outcoming options for the email servers
User settings - name, signature, new email alerts
Retrieval settings - what to receive (headers etc) and how many, IMAP folders to retrieve
Automatic retrieval - E-mail notifications and E-mail retrieval.
The Automatic retrieval details holds the key, it is badly described in the
user manual as:
E-mail notifications — To automatically retrieve the headers to your device when
you receive a notification of new e-mail in your remote mailbox, select Auto-
update or Only in home netw.
E-mail retrieval — To have e-mail headers automatically retrieved at set intervals,
select Enabled, or if you only want headers to be retrieved in your home network,
select Only in home netw. Headers can be automatically retrieved for two
mailboxes at most. You can set on which days, at what times, and how frequently
the headers are retrieved in Retrieval days, Retrieval hours, and Retrieval interval.
E-mail notifications and E-mail retrieval cannot be active at the same time. Quite frankly I didn't understand this when I read it first time, and I still don't fully understand it. What I do know, however, is that by choosing E-mail retrieval and setting it to "Only in home netw." a message is displayed on the screen which says "All e-mails are retrieved to mailbox when automatic retrieval enabled. Continue?" which led me to believe I was on to something. I set up some Retrieval days, hours and interval and then when chosing to connect a proper synchronise took place. I'm not sure if this is because some other settings behind the scenes were magically updated, or that this on its own was the key. To try and work this out, I set the E-mail retrieval back to disabled and re-connected and deleted emails didn't get removed, so I'm assuming that this is the key.
I'm not sure how much I want to use email on my phone, but I'm pleased to have worked out how to make it work.
Update:
More confused than ever. Whilst it worked once, and sync'd my mailbox, I then deleted some more emails from my server IMAP account and re-connected and nothing changed. New emails were received, but deleted ones didn't go away. However, if I delete an email from the phone inbox (and asking it to delete on the server as well) a proper synchronise seems to happen. This would appear to be the most reliable method currently.
Labels: 6110
// posted by Jane @ 8:49 PM
Comments:
iGoogle
I started using the
iGoogle personalised home page quite some time ago now, and over time have configured it to have almost everything I need displayed on it. This is the screen that I have open on my browser the majority of my day at work, and it gives me a great view into everything that is important.

From top left to bottom right (going in columns) I use:
Every now and again I follow the
Add Stuff link to see what is new. And whilst checking that link I've just gone and got distracted by the
Ski and Snow Report gadget :-) - one to install in preparation for the
big trip me thinks.
Labels: tool
// posted by Jane @ 6:16 PM
Comments:
Thursday, August 23, 2007
Remember the milk
This time last year I read most of the
GTD book and overhauled my existing todo management system (notes in diaries, tasks in outlook, email TODOs etc). After that and up until the
beginning of the year I relied on
monkeyGTD to help me keep track of what my team and I needed to do. I used it locally, on my desktop and kept backups etc and whilst it worked pretty well for me, it started to get pretty unwieldy due to storing all the tasks within the page itself, not to mention that it was only useful at work and didn't help me when I was at home (there is a password protected online version of monkeyGTD I could have used which would have overcome this issue) so I was still emailing TODO items to my work email address. So, not perfect.
Several months later, with a new (non management) job and tasks building up I decided it was time to move to a new tool. I knew that
Paul was a devotee of
Remember the Milk (rtm) and so thought I'd give it a try.
First impressions were good, with an easy to use interface allowing me to create as many or as few lists as I needed, with priorities, dates, repeating tasks etc and a
handy getting started guide. I discovered an
iGoogle gadget which allows an easy method of maintaining a task list. Being an iGoogle fan (there's a blog post coming sometime soon about why this is) this works well for me as the page is open in my browser window quite a lot of the time.
Not long after I started using rtm, they announced
twitter integration and being a
twitter fan I was totally sold. By linking up twitter to my rtm account, I can:
add tasks to rtm by sending direct messages (d rtm). These get sent to my rtm inbox list. Parsing takes place so if I send a task "Buy milk today @7pm" it'll get added to rtm with an appropriate date and time reminder
set up my reminder service in rtm to direct message me with tasks due - either daily reminders or the time based reminders
Having got my twitter direct messages going straight to my mobile phone, I get timely reminders sent to me directly. A fantastic combination of technologies.
Remember the milk have just started to offer a
pro service, mainly to offer the chance for regular users to support the service, but there will be some new pro-only features according to the
blog post. I've still only been using rtm for two or three months, but I'm already seriously considering supporting them as I'd miss it if it wasn't here, and I've been really impressed with their embracing of technologies (they implemented
google gears support within days of it being released). In fact, I'll just add a task to rtm to reminder me to consider that in a months time if I'm still as impressed with it.
Labels: article, rtm, tool
// posted by Jane @ 6:04 PM
Comments:
Tuesday, August 21, 2007
SQL Server - Dynamic Order by clause
I was just asked a question about a way of making the order by clause in a query alter according to a variable without having to build up the sql query as a string and EXEC it.
After a bit of a play we got it to work using similar code to the following
DECLARE @intOrder INT
SET @intOrder = 4
SELECT *
FROM Customers
ORDER BY
CASE @intOrder
WHEN 1 THEN CompanyName
WHEN 2 THEN ContactName
WHEN 3 THEN ContactTitle
WHEN 4 THEN Fax
ENDwhere CompanyName, ContactName, ContactTitle and Fax are all character columns.
There is a condition. The columns that are being potentially ordered by need to be of the same type, which means potentially
casting columns. And of course, remembering that an integer may be of a different length to others and so needs to be
padded to ensure that the comparison is appropriate.
DECLARE @intOrder INT
SET @intOrder = 3
SELECT *
FROM Employees
ORDER BY
CASE @intOrder
WHEN 1 THEN LastName
WHEN 2 THEN CONVERT(VARCHAR(20),BirthDate,121)
WHEN 3 THEN REPLACE(STR(ReportsTo, 10), SPACE(1), '0')
WHEN 4 THEN Title
ENDwhere LastName and Title are character columns, BirthDate is a date - using format 121 to move it into ODBC canonical (with milliseconds) yyyy-mm-dd hh:mi:ss.mmm(24h) and ReportsTo is an integer
Labels: SQL
// posted by Jane @ 12:11 PM
Comments:
Wednesday, August 15, 2007
A busy Tuesday in Brighton
Last night was a busy night in Brighton, with an overlap between
Flash Brighton - Jeremy Keith - Ajax : Flash Killer and
£5 App Meet.

Richard and I managed to see some of
Jeremy's presentation (which was excellent) before heading off to the £5 app to hear
Tom Hume talk about the history of
Future Platforms.
Jeremy presented on Ajax and how it relates to Flash, and effectively how there is space for both of them - Ajax is good for pages, flash is good for applications. We were shown a set of different sites and asked "Are they Ajax or not?" - Jeremy pointed to the ratings section on Amazon as a great Ajax example - small, discreet and works really well. Then we had to grab a cab and move on - any chance of seeing the rest of the slides sometime Jeremy?

Tom gave an excellent presentation about "The gritty reality of founding a software company", discussing the history of FP, the highs and lows, the lessons learnt - check for mobile coverage before renting an office when you're a mobile application provider - and of course the
Pith!
Two excellent events, with excellent local speakers.
Labels: Brighton, event, flash, sussexdigital, £5 app
// posted by Jane @ 8:18 PM
Comments:
Tuesday, August 14, 2007
TSQL: Get random rows
We needed to return a random subset of rows from a database, and someone pointed out the
newid() function.
SELECT *
FROM Company
ORDER BY newid()For the application concerned it works well, but as it says in
Random Sampling in T-SQL "However, it's evaluated by the operating system, not T-SQL. In addition, while unique identifiers can be ordered, the comparison functions aren't documented. Unlike Rand(), NewID() has not been designed for use as a statistically valid random number generator." so it obviously must be used with caution.
Labels: SQLServer
// posted by Jane @ 4:30 PM
Comments:
Monday, August 13, 2007
Madgex Hackday II
Last week saw the 2nd
Madgex hackday. There were 6 teams, with 24 hours each, to work on a project of our own choosing. We were the biggest team of 5 people on the day and focussed on implementing a templating language for ASP.NET based around the concept of
django's templates. Our hacking went well and by the end of the day we had a working subset of tags.
On Friday we all had to present our projects, and quite a wide range had been done from social policy research, a project documentation creator, a tool for deployments, a tool for managing the status of changes waiting to be deployed, and finally a
table football webcam (so that the people on the other floors can check that the table is empty before appearing for a game). Our project won, and so we have custody of the cup until the next hackday.
All in all it was an excellent opportunity to work with different people and to investigate some new ideas. Thanks Madgex!
Labels: hackday, madgex
// posted by Jane @ 9:53 PM
Comments: