2013年12月16日 星期一

asp-random

<script type="text/vbscript">

Dim max,min
max=100
min=1
Randomize
document.write(Int((max-min+1)*Rnd+min))

</script>

jquery-tutorial

http://www.w3school.com.cn/jquery/jquery_css_classes.asp

mssql-round mssql-roundup



Select round(Minutes/60.0,2) from ....

asp-excel

inf : http://stackoverflow.com/questions/440892/how-to-output-an-excel-xls-file-from-classic-asp

<%@ Language=VBScript %>
<%  Option Explicit
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=excelTest.xls"
%>
<table>
    <tr>
        <td>Test</td>
        <td>Test</td>
    </tr>
<tr>

</tr>
<tr>
</tr>

test test
<tr>
</tr>
<tr>
</tr>

</table>

<table>
    <tr>
        <td>Test</td>
    </tr>
</table>

2013年12月15日 星期日

jquery-getJson, when 2 getJson at the same time $.ajaxSetup({ async: false });



$.ajaxSetup({
async: false
});


var obj_field=document.getElementById('CUSTOMER.PAYMENT_TERMS_CODE');
obj_field.options[0] = new Option('','');
s='tableRead?table=PAYMENT_TERMS&fields=CODE,DESCRIPTION&where=where status:`A` or status:`D` &format=S,S&callback=?&db=BR201312111529'
$.getJSON(s,
function(data) {
if (data[0]){
for (r=0 ; r<data.length; r++)
{
$(obj_field).append($('<option></option>').val(data[r][0]).html(data[r][1]));
}
}
}
)

var obj_field=document.getElementById('CUSTOMER.PAYMENT_METHOD_CODE');
obj_field.options[0] = new Option('','');
s='tableRead?table=PAYMENT_METHOD&fields=CODE,DESCRIPTION&where=where status:`A` or status:`D` &format=S,S&callback=?&db=BR201312111529'
$.getJSON(s,
function(data) {
if (data[0]){
for (r=0 ; r<data.length; r++)
{
//combo.jsoncall20131213
//obj_field.options[r+1] = new Option(data[r][0],data[r][1]);
$(obj_field).append($('<option></option>').val(data[r][0]).html(data[r][1]));
}
}
}
)


java-left

String s20=str.substring(0,1);  ## left(str,1)


if (! s20.equals("#"))

navison-entries