The Linux Page

multiple

Setting the color of a cell in LibreOffice Calc depending on the cell value...

Introduction

This is not the first time I try to look into getting a color in a cell when the value of the cell is such and such, not just smaller than 0 and it becomes [RED]... which is a default available in your formula.

The fact is that you need to create styles that you're going to reference either with the STYLE() function or using the Conditional Formatting window.

So...

Creating New Styles and Formatting

First select a cell. You probably want to use an empty cell where you can enter a number or some text and then change it's format with the Format Cell... option. ...

Classes in JavaScript (from complex objects to proper classes)

When creating objects (commonly called JavaScript classes) in your JavaScript code, you want to use the prototype. This is the only clean way of doing it. In JavaScript, you can create objects on the fly, but those are not considered safe.

Quick and Dirty

The quick way is to create an object directly. This works, but it has potential problems with used against a powerful optimized such as the Google Closure Compiler.

All the Quick and Dirty examples can make use of this in their myFunc examples. However, the closure compiler will warning about all of them because it doesn't know for ...

POSTing multiple files over HTTPS

I've been trying to send a POST to Apache 2.x using cURL. In itself, that's very easy to do. However, I run modsecurity and when cURL sends a POST that's too large, it actually decides to break the transfer down using an Expect: 100-continue header. That in itself sound good.

Some people said that you could override the Expect by adding the curl option to add a header like this:

  curl_setopt($ch, CURLOPT_HTTPHEADER, array('Expect:'));

This sounds all nice, however, it only removes the header from the request, it does not prevent the errors with modsecurity. Not only that, the curl header

Assigning multiple IP addresses to the same Network Card

Setup your interface for multiple IP addresses

Today I got a new IP address for a server and I had to assign it to the same NIC as my current IP address.

So?! How do you do that on a Debian or Ubuntu server?

It is actually very simple. On Ubuntu you go to /etc/network and edit the interfaces file. It should already include a definition for eth0 (virtual machines will have something else than eth0).

  # The loopback network interface
  auto lo
  iface lo inet loopback

  # The primary network interface
  auto eth0
  iface eth0 inet static
        address 192.168.1.1
        ...

Number of friends on Facebook is limited!

Playing around with facebook for a couple weeks now and I bumped into a new one!

Yep! There is a limit to the number of friends you can have on Facebook... It is 5,000±10.

This explains why I have found several people with multiple accounts. That's the way to circumvent the limit. With 3 accounts, you can get 15,000 people in your circle.

UPDATE using multiple tables

Today I wanted to copy a column from one table to another. One way is to go through the table and update the items one by one. The other way is to use the UPDATE order a copy the data as required.

The UPDATE command does NOT support such a feature by default and thus each database has its own syntax when it comes to how to make that work.

PostgreSQL uses an extra FROM between the SET and WHERE orders.

[toc hide:1]

LEFT JOIN not supported

Often, when you use LEFT JOIN, you will have one table and one comparison.

Whenever you need more than one comparison, they must be put between parenthesis, otherwise you get that silly error saying: LEFT JOIN are not supported.

So you need to write something like this:

SELECT *

FROM table

LEFT JOIN other

ON (table.f1 = other.f1 AND table.f2 = other.f2)

WHERE table.f3 = 'something'

Multiple LEFT JOIN in your SQL order in MS-Access

As I was writing a report using VBA in MS-Access, I needed to get a name from a table. Yet, once in a while, that name does not exist in that table (for good reasons) and yet I'd like a more human name than the default number that you otherwise get... The result was a need for two LEFT JOIN in my SQL command.

  1. Using the result

I have three text boxes in my form:

(a) The one that the user sees with the valid result, it actually includes a simple VBA script:

External Links

Use at your own risk! These are links to other pages outside of this website:

GNU Free Documentation License

                GNU Free Documentation License
                 Version 1.3, 3 November 2008


 Copyright (C) 2000, 2001, 2002, 2007, 2008 Free Software Foundation, Inc.
     
 Everyone is permitted to copy and distribute verbatim copies
 of this license document, but changing it is not allowed.

0.

Syndicate content Syndicate content

SMS From Me Logo

SMS From Me

To automatically start one on one conversations with your online leads.

     

   

Terms of Site Index

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

  • Fiesty

    Name of a Walt Disney character used for a version of Ubuntu.

  • VB

    Abbreviation of Visual BASIC. See also VBA.

  • block
  • large
  • visual