By pauldubois  | 10 September 2009 - 03:51 PM

If you want to convert a string to uppercase or lowercase, but UPPER() and LOWER() won’t work, you’re probably trying to convert a binary string. Convert it to a nonbinary string so that ...

By pauldubois  | 10 September 2009 - 03:36 PM

If you want to convert a string to uppercase or lowercase, use the UPPER() or LOWER() function. If they don’t work, see “Converting the lettercase of a...

By pauldubois  | 10 September 2009 - 03:04 PM

Choose the data type according to the characteristics of the information to be stored and how you need to use it. Consider questions such as these:Are the strings binary or nonbinary...

By pauldubois  | 10 September 2009 - 02:31 PM

If the table already exists, just use INSERT INTO ... SELECT to retrieve rows into it. If the table does not exist yet, use CREATE TABLE ... SELECT to create it on the fly from the SELECT ...

By pauldubois  | 10 September 2009 - 02:08 PM

If you need into create a table that has exactly the same structure as an existing table, use CREATE TABLE ... LIKE to clone the table structure. If it’s also necessary to copy s...

By pauldubois  | 10 September 2009 - 01:14 PM

If you need to construct SQL statements that refer to identifiers containing special characters, quote the identifiers so that they can be inserted safely into statement strings. The topic ca...

By pauldubois  | 09 September 2009 - 12:53 PM

If you need to construct SQL statements that refer to data values containing special characters such as quotes or backslashes, or special values such as NULL, or you are constructing statements using ...

By JDBiersdorfer  | 08 September 2009 - 02:42 PM

Your browser program is not just your window to the Web. With handy tools and mini-programs called add-ons, you can teach your browser new tricks. Add-ons c...

By JDBiersdorfer  | 08 September 2009 - 02:24 PM

Most modern browsers now include an import/export function that lets you save your bookmarks to a file that you can then transfer to a second browser. The expor...

By JDBiersdorfer  | 08 September 2009 - 02:02 PM

If a broadband network at home or work isn't enough Internet access for you, another option is a wireless mobile broadband card. These cards, available from...

By JDBiersdorfer  | 08 September 2009 - 01:13 PM

Of all the things you can do on a computer, backing it up is one of the most important—but overlooked—tasks. Some netbook owners may not have much of anythi...

By JDBiersdorfer  | 08 September 2009 - 01:03 PM

If you plan to store a lot of files on your ultraportable PC, you'll have to keep an eye on your internal drive space. Netbooks don't have the biggest drives ...

By JDBiersdorfer  | 08 September 2009 - 12:54 PM

On the fence about getting a Windows 7 netbook or upgrading your current Windows XP model to the newer system? Here are some points to ponder:Windows 7 is more advanced than Windo...

By dannyg1  | 02 September 2009 - 04:14 PM

You can make the user interface part of a popup calendar date picker by using a dynamic table inside an absolute-positioned div container. Scripting behind the picker must accomplish two primary tasks...

By dannyg1  | 02 September 2009 - 02:08 PM

Countdown timers can take many forms. This example application sets the turn of the new yearin the user's time zone as the "zero hour" for the timer, and displaysa constantly updated dis...

By dannyg1  | 02 September 2009 - 01:34 PM

You can allow keypress events to succeed only if the desired character keys are pressed. The following function, invoked from a text field's keypress event, allows only numerals 0 through 9 (no de...

By dannyg1  | 02 September 2009 - 01:20 PM

You can keep more detailed controls hidden from view until a user chooses an item in a select element or turns on a checkbox using a function that is similar to the togglePurDec() function shown in th...

By dannyg1  | 02 September 2009 - 12:38 PM

Use the code in the example below as a model for designing a single object that contains methods for each of your validation routines. The example uses modern event techniques for the form element'...

By dannyg1  | 02 September 2009 - 12:12 PM

The basic solution is to invoke the focus() and select() methods of the text box under inspection. An unfortunate timing bug (primarily affecting IE for Windows) prevents these calls from occurring im...