%
Dim tbl_code
Dim FindNum
tbl_code = "TBL_NOTICE_BOARD"
SQL = "SELECT MAX(idx) FROM TBL_NOTICE_BOARD"
Set FindNum = Conn.Execute(SQL)
Max_idx = FindNum(0)
SQL = "SELECT * FROM " & tbl_code & " where idx=" & Max_idx
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open SQL,conn
title = Rs("title")
title = Replace(title,"'","''")
content = Rs("content")
content = Replace(content,"'","''")
content = replace(Rs("content"),chr(13)&chr(10),"
")
regdate = Rs("regdate")
%>