[B! tips] coolworldã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

coolworld id:coolworld

tipsã«é–¢ã™ã‚‹coolworldã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

JavaScriptã®ãƒ‡ãƒãƒƒã‚°æ–¹æ³• â€“ JSã‚’å«Œã„ã«ãªã‚‰ãªã„ãŸã‚ã®Tips | POSTD
ã“ã®è¨˜äº‹ã®ã‚ªãƒªã‚¸ãƒŠãƒ«ã¯ voxxed ã«æŠ•ç¨¿ã•ã‚ŒãŸã‚‚ã®ã§ã™ã€‚ JavaScripté–¢é€£ã®å•é¡Œã‚’æŠ±ãˆã‚‹ãƒãƒ¼ãƒ ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ä»•äº‹ã‚’é€šã˜ã¦ã€ã„ãã¤ã‹å…±é€šã®å•é¡Œç‚¹ãŒã‚ã‚‹ã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚ã‚‚ã—ã‚ãªãŸã‚‚JavaScriptã«å¯¾ã™ã‚‹ã‚¤ãƒ©ã‚¤ãƒ©ã‚’æ„Ÿã˜ã¦ã„ã‚‹ã®ã§ã‚ã‚Œã°ã€ã“ã®è¨˜äº‹ã¯ä½•ã‚‰ã‹ã®åŠ©ã‘ã«ãªã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ãŠã“ã¨ã‚ã‚Šï¼šç§ãŒãŠæ•™ãˆã™ã‚‹ãƒ’ãƒ³ãƒˆã¯ã™ã§ã«ã”å˜çŸ¥ã®ã‚‚ã®ã‚‚ã‚ã‚‹ã¨ã¯æ€ã„ã¾ã™ãŒã€ã†ã¾ãã„ã‘ã°ã€å¤šå°‘ãªã‚Šã¨ã‚‚æœ‰ç”¨ãªæƒ…å ±ãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ç‰¹ã«ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„CMSã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ§‹ç¯‰ã™ã‚‹éš›ã«æœ‰åŠ¹ãªãƒ’ãƒ³ãƒˆã§ã™ã€‚ãƒãƒ¼ãƒ ã®èª°ã‚‚ãŒè©±ã—ãŸãŒã‚‰ãªã„CMSã®ã‚³ãƒ¼ãƒ‰ã«ã¤ã„ã¦ãŠè©±ã—ã—ã¾ã™ã€‚ã„ãšã‚Œã‚‚å¿…è¦ã«å¿œã˜ã¦æŽ¡ç”¨ã§ãã‚‹ã‚‚ã®ã§ã™ã€‚ debuggerã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ å¤§åŠã®ãƒ–ãƒ©ã‚¦ã‚¶ã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€JavaScriptã‚’æ›¸ãéš›ã«æœ€ã‚‚æ´»ç”¨ã—ãã‚Œã¦ã„ãªã„æ©Ÿèƒ½ã®1ã¤ã§ã™ã€‚debuggerã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡
coolworld 2015/02/05
console.tableçŸ¥ã‚‰ã‚“ã‹ã£ãŸã€‚ã€‚ã€‚

javascript

Tips
ãƒªãƒ³ã‚¯
ã‚ãã§ãªã—åã•ã‚“ãŒé€®æ•ã•ã‚Œã‚‹å‰ã«æ•™ãˆã¦ã‚ã’ãŸã‹ã£ãŸå¥³åç•™ç½®ç”Ÿæ´»TIP
ã¤ã„æœ€è¿‘ã€ç•™ç½®æ‰€ç”Ÿæ´»ã‚’åˆçµŒé¨“ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ç§ã¨å¹´é½¢ã‚‚è¿‘ã„ã‚ãã§ãªã—åã•ã‚“ã€‚ã¡ã‚ƒã‚“ã¨çœ ã‚Œã¦ã‚‹ã‹å¿ƒé…ã§ã™ã€‚ 1.ãŠè²¡å¸ƒã«ç¾é‡‘ã‚’å¤šã‚ã«å…¥ã‚Œã¦ãŠãã—ã‚‡ã† ã‚ãã§ãªã—åã•ã‚“ãŒå…¥ã£ãŸã‚ãã“ã¯å¤§è¦æ¨¡ã¨ã„ã†ã“ã¨ã‚‚ã‚ã£ã¦ã€æŒã¡è¾¼ã‚ã‚‹ç‰©å“ã®è¦å®šãŒçµæ§‹åŽ³ã—ã‚ã€‚ç§ã¯ä¸‹ç€ã‚„ã‚‰é´ä¸‹ã‚„ã‚‰æº–å‚™ã—ã¦è¡Œã£ãŸã®ã§ã™ãŒã€ä¸€ã¤ã‚‚å…¥ã‚Œã‚‹ã“ã¨ãŒã§ããšã€ãƒ‘ãƒ³ãƒ„ã‚‚é´ä¸‹ã‚‚æ•°ã‚»ãƒƒãƒˆè²·ã†ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ã‚¹ã‚¦ã‚§ãƒƒãƒˆä¸Šä¸‹ã¯è²¸ã—ã¦ãã‚Œã¾ã™ã€‚ ç€ã‚‹ã‚‚ã®ä»¥å¤–ã«ã‚‚æ´—é¢é“å…·ã‚„æ‰‹ç´™ã‚»ãƒƒãƒˆã€ç”Ÿç†ç”¨å“ã€ã¡ã‚Šç´™ã‚‚è²·ãˆã‚‹ã®ã§ã™ãŒã€ã“ã‚ŒãŒã©ã‚Œã‚‚100å‡ã§å£²ã‚‰ã‚Œã¦ã‚‹ã‚ˆã†ãªã‚‚ã®ã°ã‹ã‚Šãªã®ã«ä¾¡æ ¼ã¯ã„ã£ã¡ã‚‡ã¾ãˆã€‚åˆæ—¥ã ã‘ã§4000å††ã»ã©ä½¿ã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ã¾ãŸã€ã€Œè‡ªå¼ã€ã¨ã„ã£ã¦æ˜¼é£Ÿæ™‚ã«é£²ã¿ç‰©ã‚„å¼å½“ã‚„ãŠæƒ£èœã€æ—¥æ›œã«ã¯ç”˜ã„ã‚‚ã®ã‚’è²·ã†ã“ã¨ãŒã§ãã‚‹ã®ã§ã™ãŒã€ã“ã‚ŒãŒçµæ§‹ç²¾ç¥žçš„æ”¯ãˆã«ãªã‚Šã¾ã—ãŸã€‚ç„¡æ–™ã§å‡ºã•ã‚Œã‚‹é£Ÿäº‹ã¯ã¨ã«ã‹ãè‰²ã€…ã¨é…·ã„ã®ã§(å¾Œã§æ›¸ã‘ãŸã‚‰æ›¸ã)ã€‚ â€¦ã¨ã¾ã‚ã€ç•™ç½®ã§ã¯çµ
coolworld 2014/07/16
çŠ¯ç½ªè€…ã¨æ±ºã¾ã£ãŸã‚ã‘ã§ã¯ãªã„äººé–“ã«ã“ã®æ‰±ã„ã¯ã„ã„ã®ã‹â€¦ï¼Ÿ

å¢—ç”°

tips
ãƒªãƒ³ã‚¯
ãƒ‡ã‚£ã‚¹ã‚¯ã«ç©ºããŒãªã„æ™‚ã«SQLiteã¸INSERTã—ã‚ˆã†ã¨ã—ãŸå ´åˆã®æŒ™å‹• - terurouãƒ¡ãƒ¢
Androidã§ãƒ‡ã‚£ã‚¹ã‚¯ã«ç©ºããŒãªã„æ™‚ã«SQLiteã¸INSERTã—ã‚ˆã†ã¨ã—ãŸå ´åˆã®æŒ™å‹•ã‚’ç¢ºèªã—ã¦ã¿ãŸã€‚ã¦ã‹ã€ã©ã‚“ãªæŒ™å‹•ã™ã‚‹ã®ã‹ãã‚‰ã„ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ›¸ã„ã¨ã‘ã‚ˆï¼žGoogle çµæžœã¨ã—ã¦ã€ä»¥ä¸‹ã®2ã¤ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§SQLiteDiskIOExceptionãŒç™ºç”Ÿã™ã‚‹ã“ã¨ãŒç¢ºèªã§ããŸã€‚ æ›¸ãè¾¼ã¿å¯èƒ½ãªDBã‚’é–‹ã“ã†ã¨ã—ãŸï¼ˆSQLite DatabaseOpenHelper.getWritableDatabase()ã‚’å‘¼ã‚“ã ï¼‰ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã€‚ ã¤ã¾ã‚Šãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡ãŒå°‘ãªã„æ™‚ã¯æ›¸ãè¾¼ã¿å¯èƒ½ãªDBã‚’é–‹ãã“ã¨ã¯ã§ããªã„ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒŸãƒƒãƒˆã—ã‚ˆã†ã¨ã—ãŸï¼ˆSQLite Database.endTransaction()ã‚’å‘¼ã‚“ã ï¼‰ã‚¿ã‚¤ãƒŸãƒ³ã‚° æ˜Žç¤ºçš„ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã—ã¦ã„ãªã„å ´åˆã¯ã€INSERTã—ã‚ˆã†ã¨ã—ãŸæ™‚ç‚¹ã§è½ã¡ã‚‹ã¨æ€ã†ï¼ˆè©¦ã—ã¦ãªã„ï¼‰ã€‚ DBã‚’é–‹ãæ™‚ç‚¹ã§ã¯ãƒ‡ã‚£ã‚¹ã‚¯ãŒç©ºã„ã¦ãŸã‚“ã ã‘ã©ã€æ›¸ãè¾¼ã¿ã‚’ã™ã‚‹æ™‚ç‚¹ã§ãƒ‡ã‚£ã‚¹ã‚¯
coolworld 2012/07/23
Android

SQLite

tips
ãƒªãƒ³ã‚¯
Excelã®ã‚»ãƒ«ã«è¨å®šã•ã‚ŒãŸãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ã‚’ã¾ã¨ã‚ã¦è§£é™¤ã™ã‚‹
Excelã®ã‚»ãƒ«å†…ã«ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ã¨ã€ãã®ã‚»ãƒ«ã‚’ã†ã£ã‹ã‚Šã‚¯ãƒªãƒƒã‚¯ã—ãŸã ã‘ã§ã‚‚ãƒ–ãƒ©ã‚¦ã‚¶ãŒèµ·å‹•ã•ã‚Œã€ãƒšãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã†ã€‚ã‚»ãƒ«ã‚’1ã¤ãšã¤é¸æŠžã—ã¦ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ã‚’è§£é™¤ã§ãã‚‹ãŒã€æ•°ãŒå¤šã„ã¨éžå¸¸ã«é¢å€’ã ã€‚ï¼»å½¢å¼ã‚’é¸æŠžã—ã¦è²¼ã‚Šä»˜ã‘ï¼½ã®æ¼”ç®—æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚Œã°ã€è¤‡æ•°ã‚»ãƒ«ã®ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ã‚’ã¾ã¨ã‚ã¦è§£é™¤ã§ãã‚‹ã€‚ è§£èª¬ Excelã«ãŠã„ã¦ã€ã‚·ãƒ¼ãƒˆå†…ã«URLã®ãƒ‡ãƒ¼ã‚¿ã™ã¹ã¦ã«ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚Excelã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§ã¯ã€URLãƒ‡ãƒ¼ã‚¿ãŒå…¥åŠ›ã•ã‚Œã‚‹ã¨ã€è‡ªå‹•çš„ã«URLã«å¯¾å¿œã™ã‚‹ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ãŒè¨å®šã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚æœ¬å½“ã«ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ãŒå¿…è¦ãªç”¨é€”ãªã‚‰ä»•æ–¹ãªã„ãŒã€Excelã«è¨å®šã•ã‚ŒãŸãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ã¯ãƒ¯ãƒ³ã‚¯ãƒªãƒƒã‚¯ã—ãŸã ã‘ã§ãƒ–ãƒ©ã‚¦ã‚¶ãŒèµ·å‹•ã•ã‚Œã€å¯¾å¿œãƒšãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã†ãŸã‚ã€æ„å›³ã›ãšã«ãƒ–ãƒ©ã‚¦ã‚¶ãŒèµ·å‹•ã•ã‚Œã³ã£ãã‚Šã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚å ´åˆã«ã‚ˆã£ã¦ã¯ã€ãŠã©ã‚ã„ãŸåˆå¿ƒè€…ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã€ãƒ˜
coolworld 2011/06/22
excel

tips
ãƒªãƒ³ã‚¯
Works - é€†å¼•ãSQLæ¯”è¼ƒ
ãƒ„ãƒ¼ãƒ«ã®ä½¿ã„æ–¹ãªã©ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€ORACLE ã«ã¤ã„ã¦è¿°ã¹ã¦ã„ã¾ã™ã€‚ ä»–ã® RDBMS ã«ã¤ã„ã¦è¦‹ãŸã„å ´åˆã¯ã€å„é …ã®ãƒªãƒ³ã‚¯ ï¼ˆ ORACLE MSSQL SSA ï¼‰ ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ ã¾ãŸã€ä½¿ã‚ã‚Œã¦ã„ã‚‹è¨€è‘‰ã®æ„å‘³ãŒã‚ã‹ã‚‰ãªã„å ´åˆã¯ã€å…±é€šäº‹é …ã‚’è¦‹ã¦ãã ã•ã„ã€‚ SQLæ–‡ã‚’æ›¸ã„ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒãƒƒãƒã§å®Ÿè¡Œã™ã‚‹ã«ã¯ï¼Ÿ CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã«ã¯ï¼Ÿ CSVãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ã«ã¯ï¼Ÿ ãƒãƒƒãƒã§ã‚¨ãƒ©ãƒ¼ã‚’ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã™ã‚‹ã«ã¯ï¼Ÿ ãƒã‚°ã‚¤ãƒ³ãƒ€ã‚¤ã‚¢ãƒã‚°ãªã—ã§æŽ¥ç¶šã™ã‚‹ã«ã¯ï¼Ÿ ç‰¹å®šã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã«ã¯ï¼Ÿ å¤–éƒ¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã«ã¯ï¼Ÿï¼ˆç•°æ©Ÿç¨®é–“æŽ¥ç¶šï¼‰ ONT Windowsã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§HELPã‚³ãƒžãƒ³ãƒ‰ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãƒžã‚¹ã‚¯ SQL*Plusã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‹ã‚‰åˆ¥ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§SQL*Plusã‚’é–‹ã ã‚¯ãƒªã‚¢ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ ã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬
coolworld 2010/06/14
Oracle

Tips
ãƒªãƒ³ã‚¯
1