UNIX

A Tutorial on Wget

A Tutorial on Wget Basics Wget is one of the powerful tools available there to download stuff from internet. You can do a lot of things using wget. Basic use is to download files from internet. To download a file just type [bash] wget http://your-url-to/file [/bash] But you cannot resume broken downloads.use -c option to […]

Perl

PERL – Length

PERL – Length [perl] $RESULT = length(EXPRESSION); [/perl] Perl’s length() function simply returns the length of a perl string in characters [perl] $myString = ‘perl.about.com’; $myLength = length($myString); [/perl] In this example, we’ve created a string with the value perl.about.com. When we run the length function on the string, it will return 14, or the […]

Miscellaneous

Vodafone Mobile Broadband – iPad settings

Vodafone Mobile Broadband – iPad settings If¬† your using a dongle sim from vodafone in your iPad;¬† I found these settings worked for me. APN: pp.internet User: web Pass: web

Perl

Perl Push Array

Perl Push Array A slightly more interesting kind of variable is the array variable which is a list of scalars (ie numbers and strings). Array variables have the same format as scalar variables except that they are prefixed by an @ symbol. The statement @food = ("apples", "pears", "eels"); @music = ("whistle", "flute"); assigns a […]

MYSQL, SQL

SQL Where values are not in another table

SQL Where values are not in another table [sql] select TCode from Tracking where not exists (select * from Task where Task.TCode = Tracking.TCode ) [/sql]

MYSQL

Select next available ID

Select next available ID ## Select the next available UID ## Do not delete users from unixuid and unix gid as there id’s may get re-used ######################################## [sql] SELECT min( r1.uid ) +1 AS next_available_uid FROM unixuid AS r1 LEFT OUTER JOIN unixuid AS r2 ON r2.uid = r1.uid +1 WHERE r1.uid >200 AND r2.uid […]

Blogs

A Tutorial on Wget

PERL – Length

Vodafone Mobile Broadband – iPad settings

Perl Push Array

SQL Where values are not in another table

Select next available ID

Recent Posts

Company Information

Our Services

Expertise

Main Headquarter

Other Pages

Other Offices