ASP를 공부중인데 자꾸 Insert Into 구문 오류가 나서요...
1. 정보 입력 페이지.
<html>
<head>
<title>상품 등록</title>
<style type=text/css>
<!--
body {font-size:9pt; font-family:돋움;}
td {font-size:9pt; font-family:돋움;}
//-->
</style>
</head>
<body>
<center>
<H2>상품 등록</H2>
<form action=\"list_regproc.asp\" method=\"POST\">
<table align=\"center\" width=500 border=\"0\">
<tr>
<td bgcolor=\"gray\" align=center width=\"20%\">
<font color=\"white\">제 조 사</font>
</td>
<td width=\"80%\">
<input type=\"text\" name=\"user\" size=50>
</td>
</tr>
<tr>
<td bgcolor=\"gray\" align=center width=\"20%\">
<font color=\"white\">상 품 명</font>
</td>
<td width=\"80%\">
<input type=\"text\" name=\"title\" size=50>
</td>
</tr>
<tr>
<td bgcolor=\"gray\" align=center width=\"20%\">
<font color=\"white\">상품코드</font>
</td>
<td width=\"80%\">
<input type=\"text\" name=\"pcode\" size=50>
</td>
</tr>
<tr>
<td bgcolor=\"gray\" align=center width=\"20%\">
<font color=\"white\">판매가격</font>
</td>
<td width=\"80%\">
<input type=\"text\" name=\"price\" size=50>
</td>
</tr>
<tr>
<td bgcolor=\"gray\" align=center width=\"20%\">
<font color=\"white\">상품이미지</font>
</td>
<td width=\"80%\">
<input type=\"file\" name=\"image\" size=37>
</td>
</tr>
<tr>
<td bgcolor=\"gray\" align=center width=\"20%\">
<font color=\"white\">상품설명</font>
</td>
<td width=\"80%\">
<textarea name=\"contents\" rows=\"8\" cols=\"50\"></textarea>
</td>
</tr>
</table>
<br>
<p align=\"center\">
<input type=\"submit\" value=\"등록\">
<input type=\"reset\" value=\"취소\">
</p>
</form>
</body>
</html>
2. 과정
<%
user = Request(\"user\")
title = trim(Replace(Request(\"title\"), \"\'\", \"\'\"))
contents = trim(Replace(Request(\"contents\"), \"\'\", \"\'\"))
regdate = date
hits = 0
pcode = Request(\"pcode\")
price = Request(\"price\")
image = Request(\"image\")
Set objConn = Server.CreateObject(\"ADODB.Connection\")
objConn.Open \"PROVIDER=MICROSOFT.ACE.OLEDB.12.0; DATA SOURCE=C:\\asp_src\\chap7\\ecart.accdb; \"
strSQL = \"Insert INTO btable (subject, uid, regdate, hits, contents, pcode, price, image) VALUES (\'\"
strSQL = strSQL & title & \"\',\'\"
strSQL = strSQL & user & \"\',\'\"
strSQL = strSQL & regdate & \"\',\'\"
strSQL = strSQL & hits & \"\',\'\"
strSQL = strSQL & contents & \"\',\'\"
strSQL = strSQL & pcode & \"\',\'\"
strSQL = strSQL & price & \"\',\'\"
strSQL = strSQL & image & \"\')\"
objConn.execute strSQL
Response.redirect \"list.asp\"
objConn.Close
Set objConn = Nothing
%>
Access DB에 image 필드의 데이터 형식은 첨부파일 로 만들었는데 오류가 납니다ㅜㅜ
아무리봐도 Insert Into 구문에는 오류가 없는거 같은데 뭐가 문젠지 좀 알려주세요!!
댓글 0