standard-programing develop-standard

standard-program
standard-develop
software-standard
null

Tempate
asp: response.write("Year")

Between
mysql : SELECT job FROM mytable WHERE id BETWEEN 10 AND 15

Config
mysql : /etc/mysql/my.cnf

Date
asp:

for
asp: for i = 1 to 30
        next

if
asp: if  true then
           doSomething
        elseif true then  
           doSomething
        end if

java : if (true) { do Something }
          else if (true) {do Something}
          else {do Something}

mysql : if (new.Password <> old.Password) then
elseif true then 
do something
else
set new.password=sha(new.password);
      end if;

Log
mysql : /var/log/mysql/error.log ; /etc/mysql/my.cnf

Null
mysql: if(isnull(NameOfOverseaCo),'',NameOfOverseaCo),
mssql:  CASE WHEN MyColumn IS NULL THEN 0 ELSE MyColumn END
asp:        If IsNull(col.value) Then
                  aValue(rr)=FormatNumber(0,roundup) 
             else
                  aValue(rr)=FormatNumber(col.value,roundup) 
            end if
javascript : var c_value=escape(value) + ((exdays==null) ? "" : "; expires="+exdate.toUTCString());


Numeric
asp: int(10/3)=3
          myNum = 23 Mod 10

Remark
asp : 'Remark         or  Program..... 'Remark
mssql : --Remark  /**/
mysql : /* */
generator : #


Roundup
javascript: obj_qty.value=parseFloat(obj_qty.value).toFixed(0);

Parameter

javascript : function _refreshv2(v_id,v_value,v_enable) (javascript-parameter)

servlet : table = request.getParameter("table");
              fields = request.getParameter("fields");
              format = request.getParameter("format");

String Tran
javascript: var str="Visit Microsoft!" ;result=str.replace(/Microsoft/,"Google")


String Connectiong

java : st.executeUpdate("alter table "+s0+" alter column COMMENT SET DEFAULT '';" );


String Compare

asp : if p0="KB" then

Write
asp: response.write("Year")
javascript: document.write('something');


U.I.
disable :

javascript :  $("#companyname").removeAttr("disabled");

    $("#companyname").attr( "disabled", "disabled" );