Syndicate content

time

List Open Files

This is a quick note so I can find the command I need to use to list open files.

My search will work this time.

lsof stands exactly for "LiSt Open Files"

That gives you a list of all the files opened by your system, process by process. It can be useful to know if you are developing a program or if you are limited in the number of files opened at once.

wput, a really bad tool?

The other day, I setup a small script to send file on an FTP. That was a long time since I had done anything like that and was not really thrilled, but I'm working for a client.

The FTP worked pretty well. The upload was going for a while. According to wput, if the connection is lost, it automatically retries and continues the transfer. It got stuck 3 times on me. For hours. No retry. Zilch.

Now, I updated my files on my end and then started the transfer again. Had to wait forever, although that is not the direct fault of wput, when it gets stuck mid-way, it's bad.

MO Paragraph trimmer filter test page

This page has empty paragraphs at the top (before this line), at the bottom and in between each paragraphs. In a way, this is a weird module!

It use the MO Paragraph trimmer filter1, written in PHP for Drupal 6.x, to remove all of those empty paragraphs. Sadly, there isn't a good way for you to check the page source, but you can test by posting a comment (I think...)

The idea ...

  • 1. Available on the Made to Order Software website.

MS-Access: INSERT INTO syntax error

Today I was creating a report and created a table with a column named 'Group'. It looked like it worked just fine so I moved on with it.

Then, at the point I wanted to insert data with a simple INSERT INTO ... statement, it broke. The statement would generate a syntax error. Yes. The simple answer is that GROUP is viewed as a keyword and thus when used as a field name it needs to be escaped (i.e. written between backward quotes: `...`). Not liking the need to escape a field name each time I use it, I just renamed the field which is even better.

I put that radio button in the wrong Option Group, MS-Access

It happens all the time. You create two or three option groups and start adding radio buttons.

Then you write some VBA code attached to each button and/or their option group.

And at some point in the development you notice that one was put in the wrong option group.

Just deleting the option and creating a new one is not a good option because then you have to make totally sure you have the right setup and that can take some time to review.

Instead, you can move a radio button from one option group to another by following these steps:

No AfterUpdate event on Check Boxes in MS-Access?!

Symptoms

  1. My checkbox does not have an AfterUpdate event
  2. When running, I cannot de-select that check box once selected

Discovery Process to Solution

In MS-Access, you often want to run an action after the user changed something in a form.

at job spool growing

How it works

The at command is often used to start a process at a later time. It can run any script at a specified date and time.

For instance, if you want the computer to send you a signal in one hour, use something like:

cat signal | at -q z now + 60 minutes

Assuming that the file named signal contains the commands necessary to generate the signal. Then in 60 minutes, the script will be execute and the signal will be heard or shown.

Connections to clamav.inoc.net, why is that?

Lately, I noticed that I always had a clamav.inoc.net connection. I was wondering why... I did install clamav but I did not recall changing anything in Apache where I'd get requests from the outside that would look like clamav.

The fact is I also installed freshclam. By default, that gives you a line like this in your netstat -a64 listing:

    tcp   383     0 halk:38272       clamav.inoc.net:www     CLOSE_WAIT

Most of the time you won't catch it when it is still connected and sending/receiving data. The deamon that accepts the connections is freshclam and it will save the new data ...

PHP glob function does not return softlinks

I use all sorts of tricks in order to duplicate functionality without actually duplicating PHP code.

One of the main, easiest way under Unix is to create softlinks. First put all your code in one folder, then create a softlink to it. That gives you two paths:

MS-Access constants

To define a constant in MS-Access, use the Const keyword as in:

Private Const varname = "Some value"

The value can be a string, integer, floating point. The variable can be made public in which case it is global among all modules and forms.

The value after the equal sign must be constant at time of compilation which is why it is limited to strings, integers and floating point values.

Syndicate content Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Salesperson
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165

     

Terms of Site Index

Find the page/content you are looking for with our index.

  • HTML
  • VACUUM

    The VACUUM instruction is used by PostgreSQL to query the server in cleaning up the corresponding database cluster. The work done is simply to remove the unused rows and clearly mark them are available. The VACUUM FULL command will go the extra distance of pushing the data so as to make the tables as small as possible. The command can be run on a per table basis.

  • array
  • demonstration
  • odbcpp