processing IMAP folder on a regular basis

April 13th, 2008

When you need to check a mailbox on a regular basis and process messages that has arrived since your last check you may find that some messages were somehow skipped.

Read the rest of this entry »

How to deal with IMMUTABLE error in indexes that work with timestamps

March 19th, 2008

Say that in an older version of PostgreSQL you had an index like this:

  1. CREATE INDEX logTypeDay ON myLog (eventType, date_trunc(‘day’, creationTime));

and now after upgrading to 8.1+ you’re getting:
ERROR: functions in index expression must be marked IMMUTABLE

Read the rest of this entry »

How to concatenate two object attributes and assign the result to a variable

March 4th, 2008

All right, this is really no rocket science it’s just something I needed and took me some time to figure out.

  1. {assign var="fullName" value="`$human->first` `$human->last`"}

or more robust version:

  1. {capture assign="fullName"}
  2. {$human->first} {$human->last}
  3. {/capture}

How to delete AppSlipRotate.prc and StatusBarLib.prc if you’re stuck in a reset loop

October 3rd, 2007

I bought Palm TX recently and I’m still in that period of time when you install new stuff and discover what’s out there to try. On my old Palm V I loved a text entry application Fitaly. I just had to have it on my new Palm as well.

Read the rest of this entry »

Date formatting in Smarty

September 26th, 2007

If you use the so called, German date format (day of month. month. year) you may have wondered how to achieve it with Smarty - without the leading zeroes for month.
Read the rest of this entry »