기본 콘텐츠로 건너뛰기

9월, 2018의 게시물 표시

div 양분하기 (Two Column Layout)

float:left를 활용한 div 둘로 나누기 [html]     <div class="content_wrap">            <div class="content-list">List</div>            <div class="content-view">View</div>      </div> [css] .content_wrap {     position:relative;     width:100%; } .content-list {     width: 40%;     height:500px;     float:left;     background-color:yellow } .content-view {     width: 60%;     height: 500px;     float: left;     background-color: beige }

[icon] 아이콘 가져오기 http://fontawesome.io

http://fontawesome.io  접속하면 web페이지 적용할 수 있는 다양한 아이콘들을 살펴볼 수 있다. [폰트스타일시트] <link href="/Content/Css/font-awesome.min.css" rel="stylesheet"> [HTML] <div class="wrapper">         <aside class="sidebar">             <ul class="sidebar-list">                 <li class="sidebar-item sb-active"> <i class="fa fa-bullhorn"> </i></li>                 <li class="sidebar-item"> <i class="fa fa-wrench"></i> </li>   ...             </ul>         </aside> <div>

ASP DB 커넥션 ( ASP GetConnection )

Public Function GetConnection(ByVal dbName) if dbName = "" then dbName = "MALLDB" Dim Cnn Set Cnn = CreateObject("ADODB.Connection") With Cnn .Provider = "SQLNCLI10" .Properties("Data Source").Value = "TCP:XXX.XXX.XX.X1"    'DB 서버 .Properties("Initial Catalog").Value = dbName  ' 데이터베이스명 .Properties("User ID").Value = "USERID"        ' .Properties("Password").Value = "PASSWORD"   .Properties("Failover Partner").Value = "TCP:XXX.XXX.XX.X2"    'Mirror 서버 .ConnectionTimeout = 60 .Open End With Set GetConnection = Cnn Set Cnn = Nothing End Function

ASP 요일 함수

Function fnWeekDayName(Day) Select Case Day Case "1" : fnWeekDayName = "일요일" Case "2" : fnWeekDayName = "월요일" Case "3" : fnWeekDayName = "화요일" Case "4" : fnWeekDayName = "수요일" Case "5" : fnWeekDayName = "목요일" Case "6" : fnWeekDayName = "금요일" Case "7" : fnWeekDayName = "토요일" End Select End Function

MSSQL 테이블 변수 생성 ( create table variable in sql server)

DECLARE @TABLE TABLE ( IDX_NUM INT IDENTITY(1,1) NOT NULL ,CUS_ID VARCHAR(20)                -- 아이디 ,CUS_NAME VARCHAR(50)        -- 이름 ,CUS_TEL VARCHAR(20)             -- 휴대폰번호 ,CUS_TOTMILEAGE INT                -- 보유마일리지 , PRIMARY KEY(IDX_NUM) )