ServerURL="http://c5aweb01/MFG/Personal/Personal_Info.asp?WorkID=" & Session("WorkID")
Set Mail1 = Server.CreateObject("CDO.Message")
Mail1.CreateMHTMLBody ServerURL,31
AA=Mail1.HTMLBody '結果回傳到AA裡
Set Mail1 = Nothing
message_count = Split(AA,",")
message_count = Array(0,0)
'=====重要訊息=====
ServerURL="http://c5aweb01/MFG/common/重要訊息/Top5.asp?FAB=" & FAB
Set Mail1 = Server.CreateObject("CDO.Message")
Mail1.CreateMHTMLBody ServerURL,31
MFG_MESSAGE = Mail1.HTMLBody
Set Mail1 = Nothing
原本的方式為逐筆寫入list，在join成SQL
table_name = "l5ab_eqp_port_status"
SQLS = []
for row in df.values:
SQL = "('" + "','".join(row.astype("str")) + "')"
SQLS.append(SQL)
SQL = "insert into " + table_name + " values " + ",".join(SQLS)
一行搞定
SQL = "insert into " + table_name + " values " + ",".join("('" + "','".join(row.astype("str")) + "')" for row in df.values)
<script data-sample="1">
CKEDITOR.replace( 'editor1', {
height: 250,
extraPlugins: 'colorbutton,colordialog'
} );
</script>
<script data-sample="2">
CKEDITOR.replace( 'editor2', {
height: 250,
extraPlugins: 'colorbutton',
colorButton_colors: 'CF5D4E,454545,FFF,CCC,DDD,CCEAEE,66AB16',
colorButton_enableAutomatic: false
} );
</script>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"></script>
<script src="http://code.highcharts.com/highcharts.js"></script>
<title>折線圖</title>
</head>
<body>
<div id="container"></div>
<script>
Highcharts.chart('container', {
chart: {
type: 'column'
},
title: {
text: 'World\'s largest cities per 2017'
},
subtitle: {
text: 'Source: <a href="http://en.wikipedia.org/wiki/List_of_cities_proper_by_population">Wikipedia</a>'
},
xAxis: {
type: 'category',
labels: {
rotation: -45,
style: {
fontSize: '13px',
fontFamily: 'Verdana, sans-serif'
}
}
},
yAxis: {
min: 0,
title: {
text: 'Population (millions)'
}
},
legend: {
enabled: false
},
tooltip: {
pointFormat: 'Population in 2017: <b>{point.y:.1f} millions</b>'
},
plotOptions: {
series: {
cursor: 'pointer',
point: {
events: {
click: function (e) {
$("#myDiv").html(this.name);
}
}
},
marker: {
lineWidth: 1
}
}
},
series: [{
name: 'Population',
data: [
['Shanghai', 24.2],
['Beijing', 20.8],
['Karachi', 14.9],
['Shenzhen', 13.7],
['Guangzhou', 13.1],
['Istanbul', 12.7],
['Mumbai', 12.4],
['Moscow', 12.2],
['Sao Paulo', 12.0],
['Delhi', 11.7],
['Kinshasa', 11.5],
['Tianjin', 11.2],
['Lahore', 11.1],
['Jakarta', 10.6],
['Dongguan', 10.6],
['Lagos', 10.6],
['Bengaluru', 10.3],
['Seoul', 9.8],
['Foshan', 9.3],
['Tokyo', 9.3]
],
dataLabels: {
enabled: true,
rotation: -90,
color: '#FFFFFF',
align: 'right',
format: '{point.y:.1f}', // one decimal
y: 10, // 10 pixels down from the top
style: {
fontSize: '13px',
fontFamily: 'Verdana, sans-serif'
}
}
}]
});
</script>
<div id="myDiv"></div>
</body>
</html>
parseInt("abc") // 傳回NaN
parseInt("123abc") // 傳回 123
parseInt("abc123") // 傳回 NaN
parseInt(" 123abc") // 傳回 123parseFloat("20"); //傳回20
parseFloat("30.00"); //傳回30
parseFloat("10.68"); //傳回10.68
parseFloat("12 22 32"); //傳回12
parseFloat(" 80 "); //傳回80
parseFloat("378abc"); //傳回378
parseFloat("abc378"); //傳回NaNNumber(true); //傳回1
Number(false); //傳回0
Number(new Date()); //傳回1970/1/1到現在的毫秒數
Number("123"); //傳回123
Number("123 456"); //傳回NaNsudo pip install gunicornsudo gunicorn -w 1 -b 0.0.0.0:80 run:app --daemonps -ef | grep gunicornsudo kill -9 12705