|
|
|
|
 |
|
Leader / 2001-08-23 / 오후 3:54:23 / 211.189.136.10
조회수 : 115
|
| [질문] 이야...질문... ㅡㅡㅋ 태클... ㅡㅡ;; |
<!--#include file="../include/ConnectString.asp"-->
<%
F_ID2 = Int(request("F_Stc_ID2"))
F_Passwd1 = Trim(request("F_Stc_Passwd1")
Set db = Server.CreateObject("ADODB.Connection")
db.Open strConn
Set rs = Server.CreateObject("ADODB.RecordSet")
sql1 = "select * from MBMPS10T"
sql1 = sql1 & " where IDNO='" & F_ID2 & "'"
rs.Open sql1,db
if (rs.EOF or rs.BOF) then
SQL2 = "INSERT INTO MBMPS10T (ITEMNO,SPASSWORD) VALUES "
SQL2 = SQL2 & "('" & F_ID2 & "'"
SQL2 = SQL2 & ",'" & F_Passwd1 & "')"
db.Execute(SQL2)
else
SQL2 = "UPDATE MBMPS10T SET SPASSWORD = '"& F_Passwd1 &"'"
SQL2 = SQL2 & " WHERE IDNO = '"& F_ID2 &"'"
db.Execute(SQL2)
%>
내용...
<%
end if
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing
%>
분명히..어디 틀렸는데... 못찾겠어요...(__)
|
|
|
