Dirk.Net

The old post has become obsolete and I removed it. Today it’s a bit more straightforward and easier to get a English-Thai-English dictionary installed on Linux (and Windows).

The original Nectec portal (registration is now required) referenced in the old post is here:

http://lexitron.nectec.or.th/2009_1/index_en.php?q=common_manager/download

However, it’s probably best to install StarDict from a repo manager for your system.

Then download the dictionary files from NecTec, unzip and put them into your dic folder (on OpenSuse 11.4 it’s is at /usr/share/stardict/dic/) , and off you go.

Here is an older lexitron rpm package that installs flawlessly on OpenSuse 11.4 and gives you a small and snappy English-Thai-English dictionary on OpenSuse. I use it more often than the slow and intrusive StarDict.

It’s an every day task: Select the ten top-selling widgets from each category. The obvious approach is to combine TOP and GROUP BY, which usually comes with some annoying “Column ‘xxx’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause” errors you try to work around. The culprit is a misunderstanding of the GROUP BY clause. It will NOT give you multiple result sets, but rather ONE result set with a single row for each group. From Books Online:

GROUP BY produces a single result set. There is one row for each group containing only the grouping columns and aggregate functions that show the subaggregate for that group. The select list can contain only the grouping columns and aggregate functions.

Here’s how to achieve the desired “TOP X PER GROUP” results using a variety of features introduced with SQL Server 2005.

Accessing files located on a Windows Active Directory network share from your Linux machine is easy via Samba (and probably NFS, which I’ve never tried). However, trying to use Open Office applications such as Writer or Calc to open these files will likely fail. OO apps will start up and then die silently. That’s why it’s usually necessary to mount the shared drive with a command such as this: 
sudo mkdir /media/mynetworkserverc
sudo mount -t cifs //mynetworkserver/c /media/mynetworkserverc -o username=myusername,password=mypassword