> 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문 구문오류라는데...ㅜ.ㅜ
> 채영님 도와주세요..
-----------------------------------------------------------
insert into order....
order가 정의어 이기 때문에 나는 에러 아닌가요???
테이블명을 바꾸심이 좋을듯 한데요...
|
