Category: Tech

download from http://refont.com/show.php?t=1&get=2&font=goobascript.font

See http://www.techonthenet.com/sql/insert.php

INSERT INTO clients
(client_id, client_name, client_type)
SELECT 10345, ‘IBM’, ‘advertising’
FROM dual
WHERE not exists (select * from clients
where clients.client_id = 10345);

The use of the dual table allows you to enter your values in a select statement, even though the values are not currently stored in a table.

“C:\Program Files\Microsoft Office\Office\MSACCESS.EXE” “E:\myAccessDB.mdb” /WRKGRP “E:\secured.mdw”

Put the STDOUT to a variable

open($fh, ‘>-‘);
print $fh, “hello world\n”;

Link a file handle to a string (since Perl 5.8)

open($fh, ‘<‘, \$string);

http://bdbits.wordpress.com/2008/07/01/unblock-a-nonstandard-port-in-firefox3/

enter about:config in the address bar, and then right-click anywhere in the lower portion of the resulting page and select New and then String from the context menu. The name you need to enter is network.security.ports.banned.override, and the value is the port(s) you want to open. If you have more than one, enter them as a comma-separated list.