|
|
|
|
 |
|
꼭지 / 2001-08-23 / 오후 4:04:37 / 168.126.91.65
조회수 : 110
|
| [질문] 이야...질문... ㅡㅡㅋ 태클... ㅡㅡ;; |
> <!--#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
> %>
>
> 분명히..어디 틀렸는데... 못찾겠어요...(__)
>
-----------------------------------------------------------
4~5Line정도의
F_Passwd1 = Trim(request("F_Stc_Passwd1")
에서 제일 마지막 괄호가 빠졌네요..
F_Passwd1 = Trim(request("F_Stc_Passwd1"))
|
|
|
|