sql = "insert into order (ordernum, memid, sendname, sendemail, sendtel01, sendtel02, sendtel03, sendzipcode01, sendzipcode02, sendaddr, receivename, receiveemail, receivetel01, receivetel02, receivetel03, receivezipcode01, receivezipcode02, receiveaddr, paytype, part1, goods_name, amount, money, writeday) values"
sql = sql&" ('"& ordernum &"'"
sql = sql&", '"& memid & "'"
sql = sql&", '"& sendname & "'"
sql = sql&", '"& sendemail & "'"
sql = sql&", '"& sendtel01 & "'"
sql = sql&", '"& sendtel02 & "'"
sql = sql&", '"& sendtel03 & "'"
sql = sql&", '"& sendzipcode01 & "'"
sql = sql&", '"& sendzipcode02 & "'"
sql = sql&", '"& sendaddr & "'"
sql = sql&", '"& receivename & "'"
sql = sql&", '"& receiveemail & "'"
sql = sql&", '"& receivetel01 & "'"
sql = sql&", '"& receivetel02 & "'"
sql = sql&", '"& receivetel03 & "'"
sql = sql&", '"& receivezipcode01 & "'"
sql = sql&", '"& receivezipcode02 & "'"
sql = sql&", '"& receiveaddr & "'"
sql = sql&", '"& paytype & "'"
sql = sql&", '"& part1 & "'"
sql = sql&", '"& goods_name & "'"
sql = sql&", "& amount & ""
sql = sql&", 'no', '"& now() & "')"
response.write sql
db.execute(sql)
response.write 확인결과
insert into order (ordernum, memid, sendname, sendemail, sendtel01, sendtel02, sendtel03, sendzipcode01, sendzipcode02, sendaddr, receivename, receiveemail, receivetel01, receivetel02, receivetel03, receivezipcode01, receivezipcode02, receiveaddr, paytype, part1, goods_name, amount, money, writeday) values ('20000726165931', 'worldice', '김미정', 'worldice@orgio.net', '055', '944', '7862', '670', '891', '경남 거창군 남하면 무릉리 1075', '김미정', 'worldice@orgio.net', '055', '944', '7862', '670', '891', '경남 거창군 남하면 무릉리 1075', 'bank', '농산물', '상주참외', 56900, 'no', '00-07-26 오후 4:59:31')
어디서 나는 에러인지 모르겠어요..
눈씻고 봐도..제 눈엔 안 보이거든요...^^
insert into문 구문오류라는데...ㅜ.ㅜ
채영님 도와주세요.. |
