Learn new Get simpler Do more

1. Code Page 지정 1) 해당 페이지에 적용 2) Session.CodePage = 65001 세션 범위내에서 적용 2. Response의 Content-Type 추가 Response.CharSet = "UTF-8" 3. 메타태그 설정 4. 파일 Encoding 설정 파일 저장시 해당 Encoding으로 저장

ASP에서 FormatNumber함수를 이용해서 반올림처리를 할수 있다. (ASP에서 round함수는 반올림 함수가 아님) FomatNumber()

Dim str Dim cutstr Dim cutstr1 Dim str_arr Dim str_num Dim if_num Dim k,i Dim str_arr1 str = "2006/10/18,2006/10/19,2006/10/20,2006/10/21,2006/10/22,2006/10/23,2006/10/24," str_arr = Split(str,",") ' 배열선언 if_num = UBound(str_arr) Redim str_arr1(if_num) ' 배열 사이즈 재정의 For k=0 To eval(if_num-1) 'for문 Response.write str_arr(k) & " " str_arr1(k) = Split(str_arr(k),"/") Response.write UBound(str_arr1(k..

In order to connect to MySQL database from ASP you need to install MySQL ODBC connector. You can download the MySQL driver from the URL below http://dev.mysql.com/downloads/connector/odbc/ 1. Use System DSN Open Data Sources(ODBC) and add System DNS Dim adoConn Set adoConn = Server.CreateObject(“ADODB.Connection”) adoConn.Open “DSN=TestODBC;Uid=UserID;Pwd=Password;” If adoConn.errors.count = 0 t..

In classic asp, it is impossible to initiate an array without specifying the size of the array. So, it has to resize array dynamically. Specially, it couldn’t expect how many size need to initiate array when you get the data from db or file. 1. Use Preserve keyword Dim arr_od_no() ReDim arr_od_no(-1) Do While objRs_01.eof = false ReDim Preserve arr_od_no(UBound(arr_od_no) + 1) arr_od_no(UBound(a..