P

글쓰기 에러...

· 2003-07-16 (수) 18:43:45 · 591
글을 입력 할때 작은 따옴표( ' ) 있으면 sql 에러가 발생합니다...
아래와 같이...
그누보드데모에 테스트 해보면 되는데... 뭐가 잘못 된건가요??

insert into gb_write_test set ca_id = '1', wr_notice = '', wr_html = '', wr_secret = '', wr_recv_email = '1', wr_num = '-9', wr_reply = '', wr_comment = '0', wr_commentcnt = '0', wr_subject = 'test', wr_content = '' ' '', wr_link1 = '', wr_link2 = '', wr_file1 = '', wr_file2 = '', wr_file1_source = '', wr_file2_source = '', wr_file1_download = '0', wr_file2_download = '0', wr_hit = '0', mb_id = 'admin', wr_name = '권익순', wr_passwd = '43e9a4ab75570f5b', wr_email = '[email protected]', wr_homepage = '', wr_datetime = '2003-07-16 18:40:40', wr_ip = '192.168.1.46', wr_user_agent = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)'

1064 : You have an error in your SQL syntax near '0', wr_file2_download = '0', wr_hit = '0' at line 12
댓글을 작성하시려면 로그인이 필요합니다.

그누3질답

9,564건
+
제목 글쓴이 날짜 조회
03-07-16 조회 592
03-07-16 조회 706
03-07-16 조회 701
03-07-16 조회 744
03-07-16 조회 737
03-07-16 조회 595
03-07-16 조회 676
03-07-17 조회 542
03-07-16 조회 651
& 
03-07-16 조회 591
03-07-16 조회 697
& 
03-07-16 조회 821
03-07-16 조회 853
03-07-17 조회 595
03-07-16 조회 1,045
03-07-16 조회 992
03-07-15 조회 667
03-07-15 조회 828
& 
03-07-15 조회 690
03-07-15 조회 653