숫자만 입력받고 싶을 때 정보
숫자만 입력받고 싶을 때
본문
위 팁을 적용해봤는데요. 익스에서는 모두 정상적입니다.
크롬, 파폭에서도 적용은 되긴 하지만 익스와는 약간 차이점이 나타나네요.
숫자인지 체크는 하지만 입력된 문자는 그대로 남아있습니다.
익스처럼 잘못 입력된 문자를 없애려면 어떻게 하면 될까요.
샘플 : http://whiteeye.web-bi.net/bbs/write.php?bo_table=reservation
input 에 이렇게 적용했습니다. onkeydown='onlyNumber(this);'
연락처 항목 입력해보면 됩니다.
( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_id = '281302' and wr_id != '2008' ) union ( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '281291' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )
1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
error file : /15sir/bbs/board.php