Wednesday, April 30, 2008

Convert numbers between 0 and 1 to Binary

Take the decimal expression and repeat-
edly multiply it by 2. At each step, keep track of the integer part of the
result but do not carry it along in subsequent multiplications.

For example, convert decimal 0.7 to binary:
0.7 * 2 = 1.4
0.4 * 2 = 0.8
0.8 * 2 = 1.6
0.6 * 2 = 1.2
0.2 * 2 = 0.4
0.4 * 2 = 0.8
0.8 * 2 = 1.6
0.6 * 2 = 1.2 etc.

The binary representation of decimal 0.7 is 0.1011001100...
where the "1100" repeats forever.

Monday, April 28, 2008

Installing DAO 3.6 (Data Access Objects)

If you work with Windows XP This will definitely workl
  • download dao360.zip and unzip it into a temporary directory.
  • Copy the Dao360.dll file to System32 Directory (inside the Windows Derectory)
  • Add new Reference (Project ->References) .
  • Show the DAO360.dll by browsing the System32 Directory
  • Now you can use DAO3.6 Facility

Sunday, April 27, 2008

GANTT CHARTS


A Gantt chart is a graphical representation of the duration of tasks against the progression of time. A Gantt chart is a useful tool for planning and scheduling projects. A Gantt chart is helpful when monitoring a project's progress.


Planning and Scheduling
A Gantt chart allows you to assess how long a project should take. A Gantt chart lays out the order in which tasks need to be carried out. A Gantt chart helps manage the dependencies between tasks.


What is CAT 5 Cable ?

CAT 5 is short for Category 5 cable, which is the most commonly used cable for wiring computer networks. CAT 5 cable is typically round and is found in various colors, however, the color of the sheathing is irrelevant. All CAT 5 cable features four twisted pairs of wires inside the sheathing.

CAT 5 cable is available with the wire pairs having either a solid or stranded core. The stranded core is typically used for patch cables that are used to connect the computer network card to the network jack terminus. The solid core wire is typically used for runs from the wall termination back to the network patch panel. Solid core CAT 5 cable is also available in standard sheathing or plenum.

Plenum CAT 5 is the same internally, but features a special outer sheath that puts off no toxic fumes when it burns

Thursday, April 24, 2008

Batch Processing

A batch processing system is one where programs and data are collected together in a batch before processing starts.

Each piece of work for a batch processing system is called a job. A job usually consists of a program and the data to be run.

Jobs are stored in job queues until the computer is ready to process them.

There is no interaction between the user and the computer while the program is being run. Computers which do batch processing often operate at night.


Example : Payroll - when a company calculates the wages for its workforce and prints payslips.


Wednesday, April 23, 2008

MySQL Update Example using PHP

Once again we will be working with the data from a previous example. Sandy has just had a birthday and she now 22 years old. Our job now is to update her age using MySQL commands like UPDATE, SET, and WHERE.

  • UPDATE - Performs an update MySQL query
  • SET - The new values to be placed into the table follow SET
  • WHERE - Limits which rows are affected

PHP & MySQL Code:

// Connect to MySQL

// Get Sandy's record from the "example" table
$result = mysql_query("UPDATE example SET age='22' WHERE age='21'")
or die(mysql_error());


$result = mysql_query("SELECT * FROM example WHERE age='22'")
or die(mysql_error());

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
echo $row['name']." - ".$row['age']. "
";
?>

A Simple Database Backup:

You can use mysqldump to create a simple backup of your database using the following syntax.

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

    • [username] - this is your database username
    • [password] - this is the password for your database
    • [databasename] - the name of your database
    • [backupfile.sql] - the file to which the backup should be written.

The resultant dump file will contain all the SQL statements needed to create the table and populate the table in a new database server. To backup your database 'Customers' with the username 'sadmin' and password 'pass21' to a file custback.sql, you would issue the command:

mysqldump -u sadmin -p pass21 Customers > custback.sql

You can also ask mysqldump to add a drop table command before every create command by using the option --add-drop-table. This option is useful if you would like to create a backup file which can rewrite an existing database without having to delete the older database manually first.

mysqldump --add-drop-table -u sadmin -p pass21 Customers > custback.sql