|
|
|
|
Leader / 2001-08-23 / ¿ÀÈÄ 4:33:10 / 211.189.136.10
Á¶È¸¼ö : 120
|
[Áú¹®] ¿À³ë... ¶Ç ÅÂŬ ¤Ñ¤Ñ;;y |
<!--#include file="../include/ConnectString.asp"-->
<%
F_ID2 = Trim(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
%>
´Ù °íÃƴµð... ¤Ñ¤Ñ;;; Á©·Î ½Ã·¯ÇÏ´Â 500¿À·ù°¡...
¤Ñ¤Ñ;;;; ¸Ó°¡ Ʋ¸°°ÇÁö... ¤Ñ¤Ña
¸øã°Ú¾î¿ä... ¤Ñ_¤Ì
¸¾Àº ±ÞÇÏ°í... µ¹°Ú³×¿ä... ¤Ì_¤Ì |
|
|