|
|
 |
|
문희철 / 2000-10-19 / 오후 9:56:07 / 210.178.162.248
조회수 : 150
|
| [질문] 쇼핑몰 연습중인데 에러가 납니다.60 |
현재 쇼핑몰을 연습하고 있는데 등록란에서 에러가 나거든요...
SQL 쿼리에서 에러가 나왔는데 값는 제데로 뿌려지는 것 같거든요
=============================================================
에러메세지
insert into bookinfo (name,class,bestyn,author,isbn,publish,year,price,ea,comment,imgsrc,regdate) VALUES ('beginnigg active server pages3','08','Y','최광일 역','12-12345-123-1','정보문화사','2000-10-19','33000',5,'ASP 3.0 Beginning..... 아주 확실합니다.','없음','2000-10-19 오전 9:50:')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'comment'.
/bookshoppingmall/admin/book_regist.asp, line 42
==============================================================
해당라인소스
bname= Request.Form("book_name")
bclass= Request.Form("book_class")
bbestyn = Request.Form("book_bestyn")
bauthor= Request.Form("book_author")
bisbn= Request.Form("book_isbn")
bpublish= Request.Form("book_publish")
byear= Request.Form("book_year")
bprice= Request.Form("book_price")
bea= Request.Form("book_ea")
bcomment= Request.Form("book_comment")
bimgsrc= trim(Request.Form("book_imgsrc"))
if bbestyn = "N" then
bestseller = "아니오"
else
bestseller = "예"
end if
if bimgsrc = "" then
bimgsrc = "없음"
else
bimgsrc = bclass + "/" + bisbn + ".gif"
end if
bregdate=now
bregdate=left(bregdate,19)
visited = 0
point = 0
sql = "insert into bookinfo (name,class,bestyn,author,isbn,publish,year,price,ea,comment,imgsrc,regdate) VALUES ('" & bname & "','" & bclass & "','" & bbestyn & "','" & bauthor & "','" & bisbn & "','" & bpublish & "','" & byear & "','" & bprice & "'," & bea & ",'" & bcomment & "','" & bimgsrc & "','" & bregdate & "')"
========>에러부분
response.write sql
sql2 = "select * from bookclass where class='" & bclass & "'"
Set rs = DbCon.execute(sql)
Set rs2 = DbCon.Execute(sql2)
bclassname = rs2("name")
DbCon.close
set DbCon=nothing
|
|
|
|