berbagisolusi
Archive for
Refresh HTML Frameset
Using Redirects with Frames Overview This tutorial is for people who have sites that use frames. In a framed site, there is usually at least two frames; a navigation frame which holds the links to navigate around the site, and a content frame which holds the page’s content. Of course there may be more than … Continue reading
Auto Refresh HTML
To make the page reload or refresh itself, we have to use the following code inside the head tag <meta http-equiv=”refresh” content=”5″ > The attribute http-equiv=”refresh” calls for refresh of the page. The attribute content=”5″ sets the time for refresh. The time after which the page has to reload is set using the content attribute. … Continue reading
input text Currency Format using Javascript
Input text for money currency very important, but that need write and change on key press. This problem can be solve using javascript, let’s read this sample : <html xmlns=”http://www.w3.org/1999/xhtml”> <head> <meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ /> <script language=javascript> function currencyFormat(fld, milSep, decSep, e) { var sep = 0; var key = ”; var i = … Continue reading
Oracle select limit using rownum and rank()
**USING ROWNUM Oracle has a system attribute ROWNUM for each record returned. A query that only returns the first 20 records would look like the one in the example. ROWNUM starts counting with 1. // mysql select col from tbl limit 20; // Oracle select col from tbl where rownum<=20; // Microsoft SQL select top … Continue reading
Checking Javascript Available Object
Calling object name using javacript like document.getElementById(“id”).value or document.Form1.value will have problem if that object not available. How do checking the object? This is sample checking : if(null !== x && ‘object’ == typeof(x)) { alert(“Hey, It’s an object or an array; good enough!”); } if available return of alert(obj); will be “[object]” … Continue reading
String Functions in Oracle / PLSQL
Oracle/PLSQL String Functions ASCII Get The ASCII Value Of A Character ASCII(ch VARCHAR2 CHARACTER SET ANY_CS) RETURN PLS_INTEGER; SELECT ASCII(‘A’) FROM DUAL; SELECT ASCII(‘Z’) FROM DUAL; SELECT ASCII(‘a’) FROM DUAL; SELECT ASCII(‘z’) FROM DUAL; SELECT ASCII(‘ ‘) FROM DUAL; CASE Related Functions Upper Case UPPER(ch VARCHAR2 CHARACTER SET ANY_CS) RETURN VARCHAR2 CHARACTER SET ch%CHARSET; SELECT … Continue reading
MySQL String Function
Table 11.7. String Operators Name Description ASCII() Return numeric value of left-most character BIN() Return a string representation of the argument BIT_LENGTH() Return length of argument in bits CHAR_LENGTH() Return number of characters in argument CHAR() Return the character for each integer passed CHARACTER_LENGTH() A synonym for CHAR_LENGTH() CONCAT_WS() Return concatenate with separator CONCAT() Return concatenated string … Continue reading
Alasan resign yang baik / tepat (6 Point )
Memang tidak mudah memutuskan untuk pindah kerja, apalagi anda sudah cukup lama bekerja di perusahaan tersebut. Tapi jika anda ingin melakukan perubahan yang lebih baik, apalagi ada kesempatan untuk itu, jadi tidak ada salahnya anda mencoba. Karena kesempatan berharga tidak akan datang dua kali. Permasalahan akan muncul, apabila anda sudah diterima di perusahaan baru tapi … Continue reading
Web Statistic
berbagisolusi 