일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | ||||
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 |
- Query
- UITextField
- api19
- 삭제버튼
- 아이튠즈
- sqlSession
- beanCreationException
- bash
- itunes
- 단축키
- mysql
- Detect
- color
- backspace
- 색상 변경
- IPA
- command not found
- dataSource
- googlemap
- DELETE
- mybatis
- Exception
- delete button
- KVO_IS_RETAINING_ALL_OBSERVERS_OF_THIS_OBJECT_IF_IT_CRASHES_AN_OBSERVER_WAS_OVERRELEASED_OR_SMASHED
- 실행
- 삭제
- Drawer
- KVO
- NoClassDefFoundError
- Cluster
- Today
- Total
목록2018/02 (3)
BlueAroma
down voteacceptedNot sure, but I'll take a shot. When you use #{key}, MyBatis puts extra '' around it if it is a String, Date etc. If you give your column names with a variable you need to use direct Stringreplacement which is ${key}.The error log says something like ...right syntax to use near ''name') VALUES ('some value'...Can you try INSERT INTO t ${key} VALUES #{value} 참고 : https://stackove..
Sample_SQL.xml SELECT *,(6371*acos(cos(radians(#{latitude}))*cos(radians(latitude))*cos(radians(longitude)-radians(#{longitude}))+sin(radians(#{latitude}))*sin(radians(latitude))))AS distance FROM TABLE_NAME HAVINGdistance 특정 위경도에서 반경 2km 내의 데이터 추출
Drawer 가 적용된 Activity에서 아래와 같이 변경. ( api 19 기준 ) // Drawer 구성 mDrawerLayout = (DrawerLayout) findViewById(R.id.drawer_layout); mDrawerToggle = new ActionBarDrawerToggle(this, mDrawerLayout, R.string.app_name, R.string.app_name); mDrawerLayout.addDrawerListener(mDrawerToggle); if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.M) { mDrawerToggle.getDrawerArrowDrawable().setColor(getColor(R.color.dr..