에러내용...
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]문자열이나 이진 데이터는 잘립니다.
/kiwon/mall/nomember_orderok.asp, line 100
------------------------------------------------------------------------------------------
수업예제 사이트인 blood에서 oorder.asp소스를 참고 해서 보고 있는데요.
상품 주문서 작성하고 확인 하면 order디비에 저장이 안돼요.
order 디비의 디자인에서 int형은 price밖에 없구요 나머지는 모두 캐릭터형으로 지정....
제생각에는 가격구하는데서 에러가 뜨는거 같은데...전혀 에러를 못찾겠어요...ㅠ.ㅠ--
소스 있는거 그대로 올려서 좀 깁니다....지성...^^;;
---------------------------------------------------------------------------------------------
<!--#include file="../dbconnect.inc"-->
<%
kiwono_sessionid=Request.Form("kiwono_sessionid")
kiwono_name=Request.Form("kiwono_name")
kiwono_email=Request.Form("kiwono_email")
kiwono_tel1=Request.Form("kiwono_tel1")
kiwono_tel2=Request.Form("kiwono_tel2")
kiwono_tel3=Request.Form("kiwono_tel3")
kiwonr_name=Request.Form("kiwonr_name")
kiwonr_email=Request.Form("kiwonr_email")
kiwonr_post1=Request.Form("kiwonr_post1")
kiwonr_post2=Request.Form("kiwonr_post2")
kiwonr_addr1=Request.Form("kiwonr_addr1")
kiwonr_addr2=Request.Form("kiwonr_addr2")
kiwonr_tel1=Request.Form("kiwonr_tel1")
kiwonr_tel2=Request.Form("kiwonr_tel2")
kiwonr_tel3=Request.Form("kiwonr_tel3")
kiwonr_yy=Request.Form("kiwonr_yy")
kiwonr_mm=Request.Form("kiwonr_mm")
kiwonr_dd=Request.Form("kiwonr_dd")
kiwonr_time=Request.Form("kiwonr_time")
kiwonr_content=Request.Form("kiwonr_content")
kiwono_paytype=Request.Form("kiwono_paytype")
kiwono_bank=Request.Form("kiwono_bank")
kiwono_payer=Request.Form("kiwono_payer")
kiwono_payyy=Request.Form("kiwono_payyy")
kiwono_paymm=Request.Form("kiwono_paymm")
kiwono_paydd=Request.Form("kiwono_paydd")
kiwono_paytime=Request.Form("kiwono_paytime")
kiwono_cardno=Request.Form("kiwono_cardno")
kiwono_cardvaliddate_year=Request.Form("kiwono_cardvaliddate_year")
kiwono_cardvaliddate_month=Request.Form("kiwono_cardvaliddate_month")
kiwono_cardallotment=Request.Form("kiwono_cardallotment")
kiwono_pass=Request.Form("kiwono_pass")
sql="select * from kiwonimsicart where kiwoni_sessionID='"&session.sessionID&"'"
rs.open sql,db,1
if rs.eof or rs.bof then
%>
<script LANGUAGE="JavaScript">
alert("\n 장바구니가 비었습니다.")
history.back()
</script>
<% rs.close
Response.End
end if
do while rs.eof=false
kiwono_order=kiwono_order&"상품명:"&rs("kiwoni_name")
kiwono_order=kiwono_order&"상품코드:"&rs("kiwoni_code")
kiwono_order=kiwono_order&"<br>상품가격:"&formatcurrency(rs
("kiwoni_price"))
kiwono_order=kiwono_order&"<br>상품수량:"&rs("kiwoni_count")
kiwono_order=kiwono_order&"<br><hr width=100% color=#63AAF7>"
kiwono_price=kiwonoo_price+cdbl(rs("kiwoni_price"))*cdbl(rs("kiwoni_count"))
rs.movenext
loop
sql="insert into kiwonoorder
(kiwono_sessionID,kiwono_name,kiwono_email,kiwono_tel1,kiwono_tel2,kiwono_tel3"
sql=sql&",kiwonr_name,kiwonr_email,kiwonr_post1,kiwonr_post2,kiwonr_addr1,kiwonr_a
ddr2,kiwonr_tel1,kiwonr_tel2,kiwonr_tel3"
sql=sql&",kiwonr_yy,kiwonr_mm,kiwonr_dd,kiwonr_time,kiwonr_content"
sql=sql&",kiwono_paytype,kiwono_bank,kiwono_payer,kiwono_payyy,kiwono_paymm,kiw
ono_paydd,kiwono_paytime"
sql=sql&",kiwono_cardno,kiwono_cardvaliddate_year,kiwono_cardvaliddate_month,kiwon
o_cardallotment,kiwono_pass,kiwono_price,kiwono_order)"
sql=sql&" values('"&kiwono_name
sql=sql&"','"&kiwono_sessionID
sql=sql&"','"&kiwono_email
sql=sql&"','"&kiwono_tel1
sql=sql&"','"&kiwono_tel2
sql=sql&"','"&kiwono_tel3
sql=sql&"','"&kiwonr_name
sql=sql&"','"&kiwonr_email
sql=sql&"','"&kiwonr_post1
sql=sql&"','"&kiwonr_post2
sql=sql&"','"&kiwonr_addr1
sql=sql&"','"&kiwonr_addr2
sql=sql&"','"&kiwonr_tel1
sql=sql&"','"&kiwonr_tel2
sql=sql&"','"&kiwonr_tel3
sql=sql&"','"&kiwonr_yy
sql=sql&"','"&kiwonr_mm
sql=sql&"','"&kiwonr_dd
sql=sql&"','"&kiwonr_time
sql=sql&"','"&kiwonr_content
sql=sql&"','"&kiwono_paytype
sql=sql&"','"&kiwono_bank
sql=sql&"','"&kiwono_payer
sql=sql&"','"&kiwono_payyy
sql=sql&"','"&kiwono_paymm
sql=sql&"','"&kiwono_paydd
sql=sql&"','"&kiwono_paytime
sql=sql&"','"&kiwono_cardno
sql=sql&"','"&kiwono_cardvaliddate_year
sql=sql&"','"&kiwono_cardvaliddate_month
sql=sql&"','"&kiwono_cardallotment
sql=sql&"','"&kiwono_pass
sql=sql&"',"&kiwono_price
sql=sql&",'"&kiwono_order
sql=sql&"')"
db.execute sql
sql="delete from kiwonimsicart where kiwoni_sessionID='"&session.SessionID&"'"
db.execute sql
Response.Redirect "../main.asp"
%>
카페 게시글
ASP Q/A
[질문]문자열이나 이진 데이터는 잘립니다. -->에러내용
워니58
추천 0
조회 985
01.09.02 01:57
댓글 0
다음검색