Javascript Popup - close after redirect

If you want to redirect the popup window to another location (a page or a file download) and then close the window, you can simply use the following javascript.

<script type="text/javascript">
    window.opener.location = "new_page.htm";
    window.close();
</script>

Find and Replace using grep and sed

Following command finds all the occurences of <br> in all .xml files in the current directory, and replace those <br> with <br/> . Please note that < and > have been surrounded with [ and ] in the sed command. / in the <br/> tag has been escaped using \. If you want to replace foo with bar, then you can just use those words.

find . -iname "*.xml" | xargs grep -l "<br>" | xargs sed -i -e 's/[<]br[>]/<br\/>/g'

find . -iname "*.xml" | xargs grep -l "<br>" | xargs sed -i -e 's/foo/bar/g'

A more general form of the expression would be

find . \( -name "*.php" -or -name "*.html" \) | xargs grep -l 'TEXT TO SEARCH' | xargs sed -i -e 's/TEXT TO REPLACE/REPLACEMENT STRING/g'

Rename Files with find command in linux

If you want to rename files recusivelly using linux find command, here are two example usage of it with exec and xargs. This command will convert all the *.xml files into *.html files.

Using xags

find . | xargs rename 's/\.xml$/\.html/i'

Using exec

find . -exec rename 's/\.xml$/\.html/i' {} +

Above commands recurrsively replace files within inner directories too. If you want to do it for current directory only you can use -prune.
i.e

find . -prune | xargs rename 's/\.xml$/\.html/i'

find . -prune -exec rename 's/\.xml$/\.html/i' {} +

Multiple Joins on the same table

Here are few example queries which shows how to use multiple inner joins with sql.

SELECT Fruit1, F1FruitName = F1.FruitName, F1FruitCost = F1.FruitCost,
Fruit2, F2FruitName = F2.FruitName, F2FruitCost = F2.FruitCost
FROM T1
JOIN T2 F1 ON Fruit1 = F1.Fruit_ID
JOIN T2 F2 ON Fruit2 = F2.Fruit_ID

If you want each fruit on it's on line(Record set), then it looks like

SELECT UserID, Fruit1 AS FruitID, FruitName, FruitCost
FROM T1
JOIN T2 ON Fruit1 = Fruit_ID
UNION
SELECT UserID, Fruit2 AS FruitID, FruitName, FruitCost
FROM T1
JOIN T2 ON Fruit2 = Fruit_ID

Here is two equivalent queries where one of them uses join and other doesn't.

SELECT codice, 
other1.value AS value_one, 
other2.value AS value_two
FROM main
LEFT OUTER JOIN other as other1 ON (main.id = other1.id_main AND type = 'type_one')
LEFT OUTER JOIN other as other2 ON (main.id = other2.id_main AND type = 'type_two)

is equivalent to

SELECT codice,
(SELECT value FROM other WHERE id_main = id AND type = 'type_one') AS value_one,
(SELECT value FROM other WHERE id_main = id AND type = 'type_two') AS value_two
FROM codice

Query below will give you a clear idea about how to use mutliple joins in the same query. Hope this will help you to understand the usage.

SELECT u1.displayname AS Player1
, u2.displayname AS Player2
, u3.displayname AS Player3
, u4.displayname AS Player4
, u5.displayname AS Player5
, u6.displayname AS Player6
FROM (
(
(
(
(
DCMLeagues AS L
INNER 
JOIN Users AS u1 
ON u1.userid = L.player1
)
INNER 
JOIN Users AS u2
ON u2.userid = L.player2
)
INNER 
JOIN Users AS u3 
ON u3.userid = L.player3
)
INNER 
JOIN Users AS u4 
ON u4.userid = L.player4
)
INNER 
JOIN Users AS u5 
ON u5.userid = L.player5
)
INNER 
JOIN Users as u6 
ON u6.userid = L.player6

find command - search content of a file

find in Unix is a very powerful tool for users which give you a very good flexibility. find command has a very broad usage among users. Here is the way how you can use find command to search files and content within files.

In order to search for a particular file named "test.txt" in /home directory, use

find /home -name "test.txt" -print

Search all the .txt files in /home directory, use

find /home -name "*.txt" -print

if you want to search for a string through all the files .txt files, there are two ways

find /home -name "*.txt" -exec grep -q "string-to-be-searched" '{}' \; -print

find /home -name "*.txt" | xargs grep "string-to-be-searched"

second one is more fast and efficient. Removal of -q in the first command will output the text segment where the specified string is. If you want to search all files for the string, just remove -name "*txt" option.

How to Increase JVM(Java) Heap Size

If you're building a big project using ant/maven then your jvm heap size may not sufficient and give you a java.lang.OutOfMemoryError: PermGen space exception. Increasing of maven/ant heap size might not sufficient enough for that and an increase of jvm heap size might also needed. When you're starting an application through command line, you can do it by specifying

java -Xms32m -Xmx128m your_application

it will be a temporary increase of heap size and if you want to increase it permanently set the following environment variable as needed.

export _JAVA_OPTIONS="-Xms64m -Xmx128m"

-Xms64m is the startup size(64MB) and -Xmx128m is the maximum size(128MB)

PNG Tranparency in IE6

1 . First Download this Zip file and unzip

2 . Copy and paste iepngfix.htc and blank.gif into your website folder.

3 . Copy and paste this into your website's CSS or HTML:

<style type="text/css">
    img, div { behavior: url(iepngfix.htc) }
</style>

That CSS selector must include the tags/elements on which you want PNG support -- basically, give it a comma-separated list of tags you use. It must also include the correct path to the .HTC relative to the HTML document location (not relative to the CSS document!). For instance, yours may look like this:

<style type="text/css">
    img, div, a, input { behavior: url(/css/resources/iepngfix.htc) }
</style>

4 . If your site uses subfolders, open the .HTC file in a text editor like Windows Notepad and change the blankImg variable to include a correct path to blank.gif like so:

IEPNGFix.blankImg = '/images/blank.gif';

Again the path is relative to the HTML file. Otherwise, you will see a "broken image" graphic!

5 . If you want support for CSS1 background-repeat and background-position, make sure you include the add-on .JS file in your <head>:

<script type="text/javascript" src="iepngfix_tilebg.js"></script>

Otherwise, background images will work but won't repeat or position.

You can view two other methods at
http://jquery.andreaseberhard.de/pngFix/
http://koivi.com/ie-png-transparency/