% Call AdminAuth() '»ç¿ë±ÇÇÑ Ã¼Å©(ȨÇÇ °ü¸®ÀÚ³ª, POS »ç¿ë°¡°¡ ¾Æ´Ï¸é Á¢±ÙºÒ°¡) Dim idx, branchCode, branchName, userId, userName, userTel, userDate, userTime, contents, writeDate, anser, memo Dim userTel1, userTel2, userTel3 Dim SQL, RS, tableName Dim mode tableName = "TB_TEL_COUNSEL" '### DB Å×À̺í¸í mode = Trim(Request("mode")) : If mode <> "edit" Then mode = "insert" End If idx = Trim(Request("idx")) If mode = "edit" Then SQL = "SELECT idx, branchCode, (SELECT branchName FROM GW_BRANCH WHERE branchCode = A.branchCode) AS branchName, userId, userName, userTel, userDate, userTime, contents, writeDate, anser, memo FROM " & tableName & " A" SQL = SQL & " WHERE idx = " & idx Set RS = Dbcon.Execute(SQL) idx = RS("idx") branchCode = RS("branchCode") branchName = RS("branchName") userName = RS("userName") userTel = RS("userTel") userDate = RS("userDate") userTime = RS("userTime") contents = RS("contents") writeDate = DateValue(RS("writeDate")) anser = RS("anser") memo = RS("memo") 'userTel = Split(uSerTel, "-") 'userTel1 = userTel(0) 'userTel2 = userTel(1) 'userTel3 = userTel(2) RS.Close Set RS = Nothing End If %>