The Linux Page

Help other users realize that everything is possible, especially avoiding Windows for their own personal use.

Welcome to The Linux Page


Fox Trot by Bill Amend. Click to enlarge.
Click to enlarge

This site is a collection of my own work with Linux. Certain things are easy, others take time to decipher and if I ever need to repeat the work (which usually happens!), then I need to remember everything by memory or... have a site with all the steps taken and to take again.

The following are my most recent posts:

If you have your own Drupal site, you may have noticed a set of tabs appearing at the top. The View and the Track tab often appear on your site even for anonymous users. This is really annoying!

Here I show you what I see when I go to one of my pages. The View, Edit and Track tabs.

Problem

As I'm working with MS-Access, I'm learning all sorts of things.

I had to write my own SQL because the database management was such that a simple form just did not fit well (i.e. things like multiple unique keys to be checked between MS-Access and a QuickBooks database...)

The SQL is relatively easy to write (there are a few tricks with MS-Access, for instance, dates are written between hash characters: #2009/01/01 00:00:01# and you cannot use all balls or it fails!)

Now, I tried to use the same form to:

Subversion Labels?

At this time, Subversion does NOT support simple labels.

This would be neat, but it simply isn't available.

What I usually want to do is mark all the files in a folder with a label to mark that point in time as a specific version. There is no feature in Subversion to do that.

There are many different things you can do to circumvent this problem.

[toc hidden:1]

Whenever I try to merge, which does not happen very often, with the SVN source control system (i.e. Subversion), I have to test 20 different ways before I finally find the right way.

Now, I'm writing the solution that works for me.

The command I have to use is:

svn merge -r N:M file:///path/to/svn/file /destination/path

The path to the SVN file is the same as what you would use to check out that specific folder (file).

Working with MS-Access and writing SQL queries to run via QODBC to get data from QuickBooks, I ran in a problem with dates.

I needed to sum the sub-total of all the rows for a given year. So that is pretty simple SQL1:

SELECT SUM(subtotal) FROM Invoice WHERE YEAR(TimeCreated) = YEAR(NOW())

That does not work. So I tried to generate the year in the macro code and sticked that to the statement:

SELECT SUM(subtotal) FROM Invoice WHERE YEAR(TimeCreated) = 2009

And that does not work either.

I tried ...

  • 1. Although at first I tried with BETWEEN, I simplify my samples here

As most people know, all of the MS-Office macros are written in Visual Basic.

Visual Basic is for sure a huge whole lot better than the BASIC I had on my Apple //c. For one thing, it does not require line numbers and you can declare functions, procedures, and have local variables (FOR loops that use the variable I do not overwrite the variable I of the FOR loop from the calling function!)

Since MS-Access 2007, we have the possibility to create classes!

RETURN statement in BASIC

Like many programmers, I switch between languages quite often.

I have worked with BASIC before since I had an Apple //c and used other Apple ][ computers that had some (really bad, early) BASIC language in their ROM.

At the time, the worst part was the line numbers. You had to write in BASIC as if you were writing assembly language. And I'll skip the numerous problems with memory...

To read files out of your repository via SSH, set your CVSROOT variable to something like this:

export CVSROOT=":ext:login-name@host//cvs/path/root"

What tells CVSROOT that it will get the data from an external host is the <em>:ext:</em> at the start of the URL.

The <em>login-name</em> is your name or whoever's login name you can use to connect to the computer.

It is assumed that you can already connect with SSH.

 

My Boring Story

Microsoft Office is making progress... or... is that really progress?!

I got a great little surprised when I met face to face with Access 2007 and all the menus were gone. I wasn't warned about that one! Not only are they gone, you MUST use little tiny icons in the place of menus so it takes you an awful long time to learn the icons, but not just that, YOU have to choose which icons will appear on your toolbar.

An RSS feed is very common on all new websites. It has been around for years now. As of today you could listen to thousands of RSS feeds and be totally swamped by all the news...

But what is an RSS feed?

The way users know about RSS feed is in the form of a URL. The URL points to a file on a website that includes data. That data file uses the specific RSS or RDF format, which uses XML as the base format.

So it is in fact very easy to generate an RSS feed. All you have to do is write an XML file with the proper tags and attributes as defined on the W3C and ...

Thank you for visiting my website.