|
|
|
|
 |
|
Leader / 2001-08-29 / 오후 3:41:42 / 211.189.136.10
조회수 : 129
|
| [질문] 벌레를 잡아라...ㅜ_ㅜyl |
<% response.expires=0 %>
<%if isEmpty(Session("우어어_ID")) then %>
<SCRIPT LANGUAGE="JavaScript">
<!--
alert("로그인 후 신청이 가능합니다.");
history.go(-1);
//-->
</SCRIPT>
<%
response.end
else %>
<!-- #Include File="../include/ConnectString.asp" -->
<%
IDNO = Session("우어어_ID")
ITEMNO = request("ITEMNO")
QTY = request("QTY")
Set conn = Server.CreateObject("ADODB.Connection")
conn.provider = "SQLOLEDB"
conn.Open strConn
Set rs = Server.CreateObject("ADODB.RecordSet")
lager = "select ITEMNO, IDNO, ITEMEA from MICART where ITEMNO='" & ITEMNO & "' and IDNO=" & IDNO & ""
'response.write lager
rs.open lager, conn, adOpenKeyset, adLockReadOnly
if rs.eof then
sql = "insert into MICART(ITEMNO,IDNO,ITEMEA) values ('" & ITEMNO & "'," & IDNO & "," & QTY & ")"
'response.write sql
conn.execute sql
response.redirect "cart.asp"
else
UP_QTY = rs(2) + QTY
sql = "Update MICART set ITEMEA = " & UP_QTY & " where ITEMNO='" & ITEMNO & "' and IDNO=" & IDNO & ""
'response.write sql
conn.Execute sql
response.redirect "cart.asp"
end if
rs.close
conn.close
set rs=nothing
set conn=nothing
end if
%>구문에는 이상이 없는데요... ㅡㅡㅋ 이상하게 안날라가네염... ㅜ_ㅜ ㅡㅡㅋ 근데 또 이상한게...
처음 만들때는 됐는데... ㅡㅡㅋ
이거 한번씩들 봐주시고... 이상없는지좀 ㅡㅡㅋ
검열 부탁드립니다... (__) |
|
|
|