untitled888

Oracle: show all tables in a DB

2012-04-27T09:36:00.001-07:00

As we all know, there is a SHOW TABLES sql command in MySQL, in Oracle, it is:

SELECT table_name FROM dba_tables;

notice in the FROM clause there is a dba_tables which shows all tables used by oracle, use user_tables to only show your own table.

KeyCodes - for Javascript, VB, Java, C++ and other language in Windows

2012-04-08T20:37:00.001-07:00

Javascript Char Codes (Key Codes) - Cambia Research:

Key	Code
backspace	8
tab	9
enter	13
shift	16
ctrl	17
alt	18
pause/break	19
caps lock	20
escape	27
page up	33
page down	34
end	35
home	36
left arrow	37
up arrow	38
right arrow	39
down arrow	40
insert	45
delete	46
0	48
1	49
2	50
3	51
4	52
5	53
6	54
7	55
8	56
9	57
a	65
b	66
c	67
d	68

Key	Code
e	69
f	70
g	71
h	72
i	73
j	74
k	75
l	76
m	77
n	78
o	79
p	80
q	81
r	82
s	83
t	84
u	85
v	86
w	87
x	88
y	89
z	90
left window key	91
right window key	92
select key	93
numpad 0	96
numpad 1	97
numpad 2	98
numpad 3	99
numpad 4	100
numpad 5	101
numpad 6	102
numpad 7	103

Key	Code
numpad 8	104
numpad 9	105
multiply	106
add	107
subtract	109
decimal point	110
divide	111
f1	112
f2	113
f3	114
f4	115
f5	116
f6	117
f7	118
f8	119
f9	120
f10	121
f11	122
f12	123
num lock	144
scroll lock	145
semi-colon	186
equal sign	187
comma	188
dash	189
period	190
forward slash	191
grave accent	192
open bracket	219
back slash	220
close braket	221
single quote	222

'via Blog this'

Changing the Default Location when Saving Attachments in Outlook 2010

2012-04-02T21:15:00.003-07:00

To change the default save as folder, follow the steps below:

===============

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs.

1. Open Registry Editor (regedit), browse to HKEY_CURRENT USER\Software\Microsoft\Office\14.0\Outlook\Options

2. Right click an empty spot on the right pane

3. Choose New String Value

4. Rename the String Value you created to DefaultPath

5. Double click DefaultPath

6. Fill in new value data typing the full path of the new default Save As location

CSL is SCAM COMPANY!

2011-07-27T07:51:00.000-07:00

Hi Everybody, I have a very important announcement to make,

CSL is a shit Malaysian company.

They always up-sell crap from China for their own profit.

Even dare to sell their crap Tablet for RM1599! Ipad 2 only RM1499!
go to http://www.cslcare.com/press/droidpad-launch-in-malaysia.html and http://store.apple.com/my/browse/home/shop_ipad/family/ipad to compare yourself if you don't believe.

Btw, even their company name oso copy-cat!

Copied from a telco in Hong Kong. Go to http://www.hkcsl.com/en/about_us/corporate_profile.jsp if you all don't believe, they hire some really genius SEO to optimize their search, so you cannot find this company if you go www.google.com.my, only www.google.com.hk can find.

At last, fuck this company and all their scammers! Greedy people with short-sighted business plan will fail! Everybody, boycott their product! If you wanna buy cheap China phone, buy the real cheap China phone, don't buy up-sell stuff!

Advanced Streamyx Settings

2011-04-27T09:47:00.000-07:00

This is the Streamyx settings I extracted from a telekom router, in case anybody have trouble connecting after all the basic setting is correct

VPI: 0

VCI: 35

Service Category: UBR without PCR (PCR set to 0 for TP Link)

Encapsulation: PPPoE LLC

MTU: 1492

IGMP: disable

NAT: enabled

Firewall: disabled

IP Address: Dynamic

QoS: disabled

UPnP: disabled

RIP: none (any, Streamyx dun give any Routing Protocol)

DSL Settings: G.Dmt, G.lite, T1.413, ADSL2, AnnexL, ADSL2+ (make sure Annex M is unchecked)

Phone Line Pair: Inner Pair

Bitswap: Enabled

SRA: Disabled

SQL Insert command using set option to add records to MySQL table

2011-03-25T00:59:00.000-07:00

SQL Insert command using set option to add records to MySQL table

using

Insert into library set book_name='Learning MySQL', author='plus2net group'

is better than

Insert into library(book_name, author) VALUES('Learning MySQL', 'plus2net group')

Connecting two mysql tables from different databases - PHP answers

2011-01-12T22:49:00.000-08:00

This site have interesting examples to connect 2 MySQL tables in different database on different servers
Connecting two mysql tables from different databases - PHP answers

//Define your database connections and select your database want to use. In this example I use two connections and two DBs. But you can use more than two.
//MySQL Server 1
$dbhost1 = "127.0.0.1";
$dbuser1 = "dbuser1";
$dbpassword1 = "dbpass1";
$db1 = "database1";
$connection1 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
mysql_select_db($db1,$connection1);
//MySQL Server 2
$dbhost2 = "xxx.xxx.xxx.xxx";
$dbuser2 = "dbuser2";
$dbpassword2 = "dbpass2";
$db2 = "database2";
$connection2 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
mysql_select_db($db2,$connection2);
//The SQL statement
$sql =" SELECT database1.tablename1.fieldname1 AS field1, database2.tablename2.fieldname2 AS field2 FROM database1.tablename1,database2.tablename2";
//Execute query and collect results in $results
$results = mysql_query($sql);
//Print result until end of records
while($rows = mysql_fetch_array($results)){
print $rows["field1"]." | ".$rows["field2"]."
";
}
?>

Quick Tip: Prevent Animation Queue Buildup » Learning jQuery - Tips, Techniques, Tutorials

2011-01-04T06:22:00.000-08:00

Quick Tip: Prevent Animation Queue Buildup » Learning jQuery - Tips, Techniques, Tutorials

a really useful way to stop drop-down menu from keep dropping down when the user moves the mouse over the item many times rapidly

Auto refresh parent window after closing popup - Dev Articles

2010-12-14T18:14:00.000-08:00

Auto refresh parent window after closing popup - Dev Articles

useful codes to refresh parent/main window when a popup closes.

function refreshParent() {   window.opener.location.href = window.opener.location.href;    if (window.opener.progressWindow)     {     window.opener.progressWindow.close()   }   window.close(); }

window. operner. location. reload();

Check visibility of item in jQuery

2010-12-13T22:59:00.000-08:00

var isVisible = $('#as_txt_techname').is(':visible');

isVisible will return true if it is visible, false if it is not

PHP SELF

2010-12-13T22:33:00.000-08:00

some servers cannot support PHP_SELF, to be safe, use $_SERVER['PHP_SELF'];

Refreshing another window for the same browser using javascript

2010-12-09T22:53:00.000-08:00

window.opener.location.reload()

can also replace opener with window name if previously set with window.name = "main";

How to use ArrayList in Java

2010-12-01T04:25:00.000-08:00

How to use ArrayList in Java

Useful tips here, but it din mention the big frustration I have today when using ArrayList.

when reassigning the same array to an ArrayList, make sure to reinitialize the Array, or else all items inside the ArrayList will refer to the same array and u will have duplicates of the last Array

Object[] tempObj = new Object[3];

while ((s = br.readLine()) != null) {

if(c == (rowItems)){

c = 0;

tempObj = new Object[3];//REINITIALIZE HERE

}

//if (s != null && s.equals("")==false) {

tempObj[c] = s;

System.out.println("Line" + c + ": " + tempObj[c]);

//}

if (c == (rowItems - 1)) {

userData.add(tempObj);

System.out.println("Expected result: \'" + tempObj[0].toString() + "\', \'" + tempObj[1].toString() + "\', \'" + tempObj[2].toString() + "\'");

}

c++;

}

4shared.com - perkongsian dan storan fail percuma

2010-10-27T18:15:00.000-07:00

4shared.com - perkongsian dan storan fail percuma

great file sharing site

check which item is selected in a radio button group

2010-10-27T03:44:00.001-07:00

$('#edit-checkbox-id').is(':checked');

Dynamically create drop down list for maximum compatibility

2010-10-27T02:47:00.000-07:00

The W3C DOM Level 2 HTML defines an add method for the select element object

but not for the options collection. However using that method is
difficult as IE implements the method with the same name with different
parameters.
If you simply want to add an option then using the DOM Level 0
var select = document.forms.formName.elements.selectName;
select.options[select.options.length] = new Option('text', 'value');
is much better in terms of browser compatibility.
[color=blue]
> anOption.innerText = "NewElement";[/color]

Firefox does not support the innerText property at all. For option
element objects you can set
anOption.text
[color=blue]
> anOption.Value = "99";[/color]

JavaScript is case sensitive, the property is named value and not Value.

Mozilla id attr issue

2010-10-26T21:13:00.000-07:00

Mozilla seems to have problem when mixing small cap n big caps letter in the id attr, example <div id="txtVAns">, better use all small caps next time

Finally

2008-12-16T23:02:00.001-08:00

Yeah~
Finally, Im here.
Im a BLOGGER.~~