채영님의 게시판 list.asp의 위 부분을 수정 한 겁니다.
이렇게 하면 DB랑 테이블에 연결이 되서
테이블의 no,title1,title2는 가져와서
V_no,V_tilte1,V_title2에 입력이 된건지요...?
근데 여기까지 하고나서 브라우저로 읽으면
500 Internal Server Error가 뜹니다.
좀 봐주실래요?
----------------------------------------------
<%@ LANGUAGE="VBSCRIPT" %>
<%
Stop_Flag=0
Set DBConnection = Server.CreateObject("ADODB.Connection")
DBConnection.ConnectionTimeout = Session("DBConnection_ConnectionTimeout")
DBConnection.CommandTimeout = Session("DBConnection_CommandTimeout")
DBConnection.Open Session("DBConnection_ConnectionString"), Session("DBConnection_RuntimeUserName"), Session("DBConnection_RuntimePassword")
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set DataCommand1 = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "SELECT no,title1,title2 WHERE digital'"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DBConnection
DataCommand1.Open cmdTemp, , 0, 1
V_no=DataCommand1("no")
V_title1=DataCommand1("title1")
V_title2=DataCommand1("title2")
DataCommand1.Close
DBConnection.Close
Set DdtaCommand1=Nothing
Set DBConnection=Nothing
%>
-----------------------------------------
|
