|
|
|
|
 |
|
꼭지 / 2001-08-23 / 오후 4:48:19 / 168.126.91.65
조회수 : 118
|
| [질문] 오노... 또 태클 ㅡㅡ;;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
>
> 못찾겠어요... ㅡ_ㅜ
>
> 맘은 급하고... 돌겠네요... ㅜ_ㅜ
-----------------------------------------------------------
이렇게 코드를 바꾼후 SQL문장들을 출력시켜 제대로 쿼리가 형성이 되는지 확인 하여 보세요..
<%
Response.Buffer = Flase
%>
<!--#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 & "'"
Response.Write sql1 &"<br>"
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 & "')"
Response.Write SQL2 &"<br>"
db.Execute(SQL2)
else
SQL2 = "UPDATE MBMPS10T SET SPASSWORD = '"& F_Passwd1 &"'"
SQL2 = SQL2 & " WHERE IDNO = '"& F_ID2 &"'"
Response.Write SQL2 &"<br>"
db.Execute(SQL2)
%>
내용.... ㅡㅡ;
<%
end if
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing
%>
|
|
|
|