[B! *programming][db] rekramkoobã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rekramkoob id:rekramkoob

*programmingã¨dbã«é–¢ã™ã‚‹rekramkoobã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

${{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}}

SQL æ–‡å—é–¢æ•° - é€£çµã€ç©ºç™½å‰Šé™¤ã€ç½®æ›ã€åˆ‡å‡ºã€æ¤œç´¢ã€é•·ã•ã€æ•°å€¤å¤‰æ›ä»– - SAK Streets
SQL æ–‡å—é–¢æ•° - é€£çµã€ç©ºç™½å‰Šé™¤ã€ç½®æ›ã€åˆ‡å‡ºã€æ¤œç´¢ã€é•·ã•ã€æ•°å€¤å¤‰æ›ä»– åŸºæœ¬çš„ã« Oracleã€SQL-Serverã€MDB ã§å…±é€šã§ã™ã€‚ â– æ–‡å—åˆ—é€£çµ ãƒ»concat() é–¢æ•°ã¯ã€æ–‡å—åˆ—ã‚’çµåˆã™ã‚‹ã—ãŸçµæžœã‚’è¿”ã™ã€‚ ã€Œ||ã€æ¼”ç®—åã®æ–¹ãŒç°¡å˜ã¨æ€ã†ãŒã©ã†ã§ã—ã‚‡ã†ã€‚ (Access ã§ã¯ ã€Œ&ã€ã‚’ä½¿ç”¨ã™ã‚‹ã€‚) select å“ç•ª, concat('part-', å“ç•ª), 'part-' || å“ç•ª from sak.å—æ³¨m order by å“ç•ª ; â– chr æ–‡å—å¤‰æ› ãƒ»chr() é–¢æ•°ã¯ã€ã‚³ãƒ¼ãƒ‰ã«è©²å½“ã™ã‚‹ ASCII æ–‡å—ã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€ã€Œ1ã€ã¨è¨€ã†æ–‡å—ãŒè¿”ã‚‹ã€‚ select å“ç•ª, chr(49) from sak.å—æ³¨m order by å“ç•ª ; â– ascii ã‚³ãƒ¼ãƒ‰å¤‰æ› ãƒ»ascii() é–¢æ•°ã¯ã€æ–‡å—ã«è©²å½“ã™ã‚‹ ASCII ã‚³ãƒ¼ãƒ‰ã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€ã€Œ49ã€ã¨è¨€ã†æ•°å—ãŒ
rekramkoob 2009/02/26
*programming

db

sql
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã¯å®Ÿè£…ã®å¾Œã«ï¼ï¼šãƒ™ãƒ³ãƒãƒ£ãƒ¼ç¤¾é•·ã§æŠ€è¡“è€…ã§ï¼šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ©ã‚¤ãƒ•
æ ªå¼ä¼šç¤¾ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã®ä»£è¡¨å–ç· å½¹ã€‚ æ–°ã—ã„ã‚‚ã®ã‚’ç”Ÿã¿å‡ºã—ã¦ä¸–ã®ä¸ã‚’ã‚ã£ã¨ã„ã‚ã›ãŸã„ã€‚ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã£ã¦ã‚„ã¤èµ·ã“ã›ãŸã‚‰ã„ã„ãªã€‚ ã€Œã¿ã‚“ãªãŒè¨€ã£ã¦ã‚‹ã€ã¯æŠ€è¡“è€…ãŒå£ã«ã™ã‚‹è¨€è‘‰ã˜ã‚ƒãªã„ã¨æ›¸ã„ã¦ãã¾ã—ãŸã€‚ ç§ãŒè¨€ã£ã¦ã‚‹ã“ã¨ã§ã€ã€Œã¿ã‚“ãªã€ã¨ã¯ãŠãã‚‰ãçœŸé€†ã®ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãã‚Œã¯ã€Œãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’ï¼ˆãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã®ï¼‰å®Ÿè£…ã®å¾Œã«ï¼ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã€Œãã‚“ãªã“ã¨ãŒã§ãã‚‹ã‚ã‘ãŒãªã„ã€ã¨ãƒã‚«ã«ã•ã‚Œã¾ã™ãŒã€ãã†ã„ã†æ±ºã‚ä»˜ã‘ã¯æ€è€ƒåœæ¢ã§ã™ã‚ˆãï¼Ÿ ã¨ã‚‚ã‹ãã€çœ‰ã«å”¾å¡—ã£ã¦ã„ãŸã ã„ã¦ã‘ã£ã“ã†ã§ã™ã®ã§ã€ç¶šãã‚’èªã‚“ã§ãã ã•ã„ã€‚ ä¸€èˆ¬çš„ãªã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦ã€ä¸€ç•ªæ‰‹æˆ»ã‚ŠãŒå¤§ãã„ï¼ˆæ³¢åŠã™ã‚‹ç®‡æ‰€ãŒå¤šã„ï¼‰ä»•æ§˜å¤‰æ›´ã¯ãƒ†ãƒ¼ãƒ–ãƒ«å¤‰æ›´ã‚’ä¼´ã†ã‚‚ã®ã§ã™ã€‚ä¸‹æ‰‹ç³žãªè¨è¨ˆã§ã€ä»–ã«æ‚ªå½±éŸ¿ã‚’ä¸Žãˆã‚‹ã®ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã§ã™ã€‚ é€†ã«ã€ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆãŒç¾Žã—ãåˆç†çš„ã«ã§ãã¦ã„ã‚Œã°ã€ä»–ã®å·¥ç¨‹ã¯éžå¸¸ã«æ¥½ã«ãªã‚Šã¾ã™ã€‚ ã§ã¯ã€ä»•æ§˜å¤‰æ›´ã‚’é˜²ãŽã€ç¾Žã—ãåˆç†çš„ãªãƒ†ãƒ¼ãƒ–ãƒ«
rekramkoob 2009/02/20
*programming

db
ãƒªãƒ³ã‚¯
shinshu.fmÂ -Â shinshu ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
rekramkoob 2009/02/20
*programming

vb

.net

access

db
ãƒªãƒ³ã‚¯
Accessã‚’MDBãƒ•ã‚¡ã‚¤ãƒ«ã§ä½¿ã†å ´åˆã®ãƒ†ãƒ¼ãƒ–ãƒ«æ•°ã®ä¸Šé™
ãƒ†ãƒ¼ãƒ–ãƒ«ã ã‘ã«ã¤ã„ã¦ã®åˆ¶é™ã¯ã‚ã‚Šã¾ã›ã‚“ãŒ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®æ•° 32,768 ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã€ã‚¯ã‚¨ãƒªã€ãƒ•ã‚©ãƒ¼ãƒ ç‰ã®ç·æ•°ã§ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚‚å«ã¾ã‚Œã¾ã™ã€‚ ã‚ã¨ã¯ã€MDBãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã®åˆ¶é™ (Access97ã§ 1Gã€2000ä»¥é™ 2G) ã§ã™ãã€‚ è©³ã—ãã¯ãƒ˜ãƒ«ãƒ—ã§ã€ŒAccess ã®ä»•æ§˜ã€ã‚’ã”è¦§ãã ã•ã„ã€‚
rekramkoob 2009/02/20
*programming

microsoft

access

db
ãƒªãƒ³ã‚¯
MS-Access2000è¶…å…¥é–€éƒ¨å±‹--100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼Ÿ
æ™¯æ°—ã®ã„ã„è©±ã˜ã‚ƒã‚ã‚Šã¾ã›ã‚“ã‹ã€‚ããˆã€‚ ã€ŒAccessã£ã¦ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¶æ•°ä½•ä»¶ãã‚‰ã„ã¾ã§å¤§ä¸ˆå¤«ãªã‚“ã§ã™ã‹ï¼Ÿï¼Ÿï¼Ÿã€ã£ã¦èžã‹ã‚Œã¦ã€ç”ãˆã«å›°ã£ãŸã“ã¨ã‚ã‚Šã¾ã›ã‚“ï¼Ÿ ã“ã‚Œã¯ãƒ»ãƒ»ãƒ»ä¸€æ¦‚ã«è¨€ãˆãªã„ã‚“ã§ã™ã‚ˆãã€‚ã€‚ã€‚ã€‚ ã¾ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã£ã¦ã„ã†è€ƒãˆæ–¹ã®ä¸ã«ã¯ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ä»¶æ•°åˆ¶é™ã¨ã„ã†ã®ã¯ãªã„ã®ã§ã™ã€‚è«–ç†ä¸Šã¯ç„¡é™ã«å…¥ã‚Šã¾ã™ã€‚ ã©ã£ã¡ã‹ã¨ã„ã†ã¨ã€ä»¶æ•°ã‚ˆã‚Šã€å…¨ä½“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã¨ã‹ã€ãƒ‡ãƒ¼ã‚¿é ˜åŸŸã®ã‚µã‚¤ã‚ºã¨ã‹ã€ã€Œãƒã‚¤ãƒˆæ•°ã€ã¿ãŸã„ãªæ„Ÿã˜ã§åˆ¶ç´„ãŒã‚ã‚‹ã‚‚ã®ã®æ–¹ãŒå¤šã„ã‹ã‚‚ã—ã‚Œãªã„ã§ã™ã€‚ MS-Access2000ã¯ã€MDBãƒ•ã‚¡ã‚¤ãƒ«ã®æœ€å¤§ã‚µã‚¤ã‚ºãŒ2GBã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã²ã¨ã¤ã®æœ€å¤§ã‚µã‚¤ã‚ºã¯ï¼‘GBã§ã™ã€‚ã“ã‚Œã¯ã€ãƒ˜ãƒ«ãƒ—ã®ã€ŒMS-Accessã®ä»•æ§˜ã€ã«è¼‰ã£ã¦ã¾ã™ã®ã§ã€æ°—ã«ãªã‚‹æ–¹ã¯æŠ¼ã•ãˆã¦ãŠã„ã¦ãã ã•ã„ã€‚ã‚ã€ã†ã¡ã®ã‚µã‚¤ãƒˆã«ã‚‚è¼‰ã›ã¦ã‚ã‚Šã¾ã™ã®ã§ã€ã‚ˆã‹ã£ãŸã‚‰è¦‹ã¦ã„ã£ã¦ãã ã•ã„ã€‚ ãã®ç¯„å›²ã®ä¸ãªã‚‰ã€ä½•ä»¶ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ãã¦ã‚‚ãœã‚“ãœã‚“å•
rekramkoob 2009/02/20
*programming

microsoft

access

db
ãƒªãƒ³ã‚¯
VB DataTableã®åˆ©ç”¨
Visual Basic ä¸å¦æ ¡ > ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¬›åº§ > ç¬¬ï¼”å›žã€€DataTableã®åˆ©ç”¨ ãƒ‡ãƒ¼ã‚¿ã‚’ã¾ã¨ã‚ã¦å–å¾—ã—ã¦è¡¨å½¢å¼ã§è¡¨ç¤ºã™ã‚‹æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ã•ã‚‰ã«ã€å¤‰æ›´ç‚¹ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åæ˜ ã•ã›ã‚‹æ–¹æ³•ã‚‚èª¬æ˜Žã—ã¾ã™ã€‚ æ¦‚è¦ãƒ»DataTableã‚’ä½¿ç”¨ã™ã‚‹ã¨è¡¨å½¢å¼ã§è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¾ã¨ã‚ã¦ä¿æŒã§ãã‚‹ã€‚ ãƒ»DataTableã«ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚€ã«ã¯OleDbDataAdapterã®Fillãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ç”¨ã™ã‚‹ã€‚ ãƒ»DataTableã®å€‹ã€…ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã•ã‚Œã¦ãŠã‚Šã€å€¤ã‚’å¤‰æ›´ã—ãŸå¾Œã§ã‚‚å¤‰æ›´å‰ã®å†…å®¹ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ãƒ»DataTableã¸ã®å¤‰æ›´ç‚¹ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åæ˜ ã•ã›ã‚‹ã«ã¯å€‹ã€…ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã®å€¤ã‚’åŸºã«SQLæ–‡ã‚’ä½¿ç”¨ã™ã‚‹ã€‚ ï¼‘ï¼Žã‚‚ã£ã¨åŠ¹çŽ‡çš„ã« å‰å›žã¯åŠ¹çŽ‡æ€§ã®è¦³ç‚¹ã¯ç„¡è¦–ã—ã¦ã¨ã«ã‹ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®èªã¿æ›¸ããŒè‡ªç”±ã«ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã¹ãèª¬æ˜Žã‚’ã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã“ã‚Œã«å¼•ãç¶šã„ã¦åŠ¹çŽ‡æ€§ã‚’è€ƒæ…®ã«å…¥ã‚Œã¦ã„ãã¾ã™ã€‚
rekramkoob 2009/02/02
*programming

vb

.net

db
ãƒªãƒ³ã‚¯
DeadlineExceededError
å‰Šé™¤ã¯æ‰‹å‹•ã§ç”»é¢ã‚’ Reload ã—ã¦ç¹°ã‚Šè¿”ã—å®Ÿè¡Œã™ã‚Œã°ã„ã„ãŒ r = db.GqlQuery("select * from Stock limit 100") for rr in r: rr.delete() å¾Œæ–¹ä¸€è‡´ ( like *key_word ) ã®å ´åˆã€offset ã§ç§»å‹•ã•ã›ãŸã€‚ r = db.GqlQuery("select * from Model limit 100 offset " + str(offset) ) start = int(offset) + 100 self.response.out.write('<a href="/xxx?offset=%s">del</a>' % str(start) ) for rr in r: if rr.trackback_url.find('</td></tr>') <>-1: ãƒ»ãƒ»ãƒ» ãƒ—ãƒã‚°ãƒ©ãƒ ã§ LOOP ã•ã›ã¦ o
rekramkoob 2009/01/08
*programming

python

google app engine

google

db

search
ãƒªãƒ³ã‚¯
Datastore ã«æ³£ã„ãŸã‚¢ãƒŠã‚¿ã«æ§ã ï¼ˆä¸ç·¨?-1ï¼‰ - Google App Engine - æš—å·ã€æ•°å¦ã€æ™‚ã€…ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
Google App Engine | 07:12 | ã„ã‚ã‚†ã‚‹ã€Œã¾ã¨ã‚ã‚µã‚¤ãƒˆã€ç³»ã‚’ãµã‚‰ãµã‚‰ã¨å›žã£ã¦ã¿ã¦ã€å°‘ã—æ°—ä»˜ã„ãŸã“ã¨ãŒã‚ã‚‹ã€‚1.ä¸€éƒ¨ã®è¨˜äº‹ã®å˜åœ¨ã«æ°—ã¥ã‘ã¦ã‚‚ã‚‰ã£ã¦ãŠã‚‰ãšã€é£›ã³é£›ã³ã§ãƒªãƒ³ã‚¯ãŒã¯ã‚‰ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚‹2.è¨˜äº‹ã«ã‚ˆã£ã¦ã¯ã€è¨€åŠã•ã‚Œã¦ã„ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã«èª¤è§£ãŒã‚ã‚‹ã‚ˆã†ã€‚ä¾‹ãˆã°2ã¤ã®ãƒˆãƒ”ãƒƒã‚¯ã«è§¦ã‚Œã¦ã„ã‚‹ã®ã«1ã¤ã ã‘è¨³ã—ãŸã‚‚ã®ã¨ç†è§£ã•ã‚Œã¦ã—ã¾ã£ã¦ã„ã‚‹å ´åˆã‚¢ãƒª3.ã©ã†ã‚„ã‚‰è‡ªåˆ†ä»¥å¤–ã«ã‚‚ç¿»è¨³ã‚’å§‹ã‚ãŸäººãŒã„ã‚‹ã¿ãŸã„ã€‚ã‚¬ãƒ³ãƒãƒ¬ï¼1ç•ªç›®ã®å•é¡Œã«ã¤ã„ã¦ã¯ã€ã“ã®ãƒ–ãƒã‚°ãã®ã‚‚ã®ã«ã‚¢ãƒ”ãƒ¼ãƒ«åŠ›ãŒè¶³ã‚Šãªã„ã®ã§ã€æ–°ç€è¨˜äº‹ã‚’ä¸Šæ‰‹ãæ‹¾ã£ã¦ã‚‚ã‚‰ã†ã®ãŒé›£ã—ã„ä»¥ä¸Šã€ä»Šã¯ã©ã†ã—ã‚ˆã†ã‚‚ãªã„ã ã‚ã†ã€‚2ç•ªç›®ã®å•é¡Œã«ã¤ã„ã¦ã¯ã€ã‚„ã£ã±ã‚Š1ã¤ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒé•·ã™ãŽã¦ã€Œèªã‚€æ°—ã«ãªã‚‰ã‚“ï¼ã€ã£ã¦äººãŒå¤šãã„ã‚‹è¨¼ãªã‚“ã ã‚ã†ãªãã€ã€ã¨ã€‚è¨˜äº‹ã‚’è¤‡æ•°ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã«åˆ†æ•£ã•ã›ã‚‹ã¨èªã‚“ã§ã‚‚ã‚‰ãˆãªã„å¯èƒ½æ€§ãŒé«˜ã„ã€ã£ã¦ã®ã‚’æ°—ã«ã—ã¦å‡ºæ¥ã‚‹é™ã‚Šã²ã¨ã¾ã¨ã‚ã«ã—ã¦ããŸãŒã€
rekramkoob 2009/01/08
*programming

python

google app engine

google

db

search
ãƒªãƒ³ã‚¯
Google App Engineã§å…¨æ–‡æ¤œç´¢ - DENã®æ€ã†ã“ã¨
å®Ÿã¯Google App Engineï¼ˆä»¥ä¸‹GAEï¼‰ã§å…¨æ–‡æ¤œç´¢ã‚’è¡ŒãŠã†ã¨æ€ã£ã¦ã‚‚ ç¾çŠ¶APIã¯æä¾›ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ ã¾ã•ã‹Googleã®ã‚¢ãƒ—ãƒªã§æ¤œç´¢ãŒã§ããªã„ãªã‚“ã¦ è€ƒãˆã¦ã‚‚ã„ãªã‹ã£ãŸã®ã§ã‹ãªã‚Šé©šãã¾ã—ãŸã€‚ ã¨ã„ã„ã¤ã¤ã‚‚ã‚ã‚‹ç¨‹åº¦å¯¾å¿œã¯å¯èƒ½ã§ã™ã€‚ ãƒ»å‰æ–¹ä¸€è‡´æ¤œç´¢ ä»¥ä¸‹ã®ã‚ˆã†ã«ç¯„å›²æ¤œç´¢ã‚’åˆ©ç”¨ã—ã¦ãƒ¦ãƒ‹ã‚³ãƒ¼ãƒ‰ã‚’ æ“¬ä¼¼çš„ã«å‰æ–¹ä¸€è‡´æ¤œç´¢ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ db.GqlQuery('SELECT * FROM Test WHERE w >= :1 and w < :2', word, word + u'\uFFFD') ãƒ»å…¨æ–‡æ¤œç´¢ï¼ˆéžå…¬é–‹ã€‚è‹±èªžã®ã¿ï¼‰ éžå…¬é–‹ã§ã¯ã‚ã‚Šã¾ã™ãŒã€å…¨æ–‡æ¤œç´¢ã‚’è¡Œã†Searchabl eModelã¨ã„ã† ã‚¯ãƒ©ã‚¹ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ ä½¿ç”¨æ–¹æ³•ã¯ãƒ¢ãƒ‡ãƒ«ãŒç¶™æ‰¿ã™ã‚‹db.Modelã‚’search.Searchabl eModel ã«å¤‰æ›´ã—ã€æ¤œç´¢æ™‚ã« Test.all().search(sea
rekramkoob 2009/01/08
*programming

python

google app engine

google

db

search
ãƒªãƒ³ã‚¯
google appengineã§ã¯ã¾ã£ãŸã“ã¨ï¼’ ï½žå…¨æ–‡æ¤œç´¢ | ã‚³ã‚¹ãƒŸãƒ¼å ±å‘Šæ›¸[ç¤¾å¤–ç§˜]
google appengineã«ã¯å…¨æ–‡æ¤œç´¢ãŒãªã„ã‚‰ã—ã„ã€‚ ã€Œgoogleãªã®ã«ï¼ãã‚“ãªé¦¬é¹¿ãªï¼è‡ªåˆ†ã§ä½œã‚‹ã—ã‹ãªã„ã®ã‹ï¼ï¼ã€ ã¨æ€ã£ãŸã‚“ã ã‘ã©ã€ãã‚“ãªã®ã™ã§ã«ä½œã£ã¦ã‚‹äººãŒã„ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã„ç«‹ã¡ã€æŽ¢ã—ã¦ã¿ãŸã‚‰ãƒ»ãƒ»ãƒ»ãªã‚“ã¨éš ã—æ©Ÿèƒ½ã§ã™ã§ã«å˜åœ¨ã—ã¦ã„ã‚‹ã”æ§˜åï¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆåŒ–ã•ã‚Œã¦ãªã„ã‘ã©ï¼ ä»¥ä¸‹å‚è€ƒãƒªãƒ³ã‚¯ How-to: Full-text search in Google App Engine ã¨ã„ã†ã‚ã‘ã§ã€ä½¿ã„æ–¹ã¨ã—ã¦ã¯db.Modelã®ä»£ã‚ã‚Šã«search.Searchabl eModelã‚’ä½¿ã£ã¦ã€æ¤œç´¢å¯¾è±¡ã¯StringPropertyã‚ã‚‹ã„ã¯TextPropertyã«ã—ã¨ã„ãŸã‚‰ã„ã„ã¨ã€‚æ¤œç´¢ã™ã‚‹ã¨ãã¯Article.all().search(â€œæ¤œç´¢å˜èªžâ€)ã¨ã™ã‚‹ã¨ã€‚db.Modelã‹ã‚‰åˆ‡ã‚Šæ›¿ãˆã‚‹ã®ã¯ã™ã”ã„ç°¡å˜ãªã®ã§ã€ã¡ã‚‡ã“ã£ã¨ã‚„ã£ã¦ã¿ãŸã‚‰ç¢ºã‹ã«æ¤œç´¢ã§ããŸã€‚ãƒ»ãƒ»ãƒ»è‹±èªžã¯ã€‚è‹±å˜èªžã®ã¿ãªã‚‰ã°ã€‚
rekramkoob 2009/01/08
*programming

python

google app engine

google

db

search
ãƒªãƒ³ã‚¯
The Query Class Â |Â App Engine standard environment for Python 2 Â |Â Google Cloud
rekramkoob 2008/11/07
*programming

google

google app engine

db
ãƒªãƒ³ã‚¯
Queries and Indexes - Google App Engine - Google Code
rekramkoob 2008/11/07
*programming

google

google app engine

db
ãƒªãƒ³ã‚¯
Ã£ÂƒÂ‡Ã£ÂƒÂ¼Ã£Â‚Â¿Ã£Â‚Â¹Ã£ÂƒÂˆÃ£Â‚Â¢Ã£ÂÂ®Ã¤Â½Â¿Ã§Â”Â¨ - Google App Engine - Google Code
Ã£ÂƒÂ‡Ã£ÂƒÂ¼Ã£Â‚Â¿Ã£Â‚Â¹Ã£ÂƒÂˆÃ£Â‚Â¢Ã£ÂÂ®Ã¤Â½Â¿Ã§Â”Â¨ Ã¦Â‹Â¡Ã¥Â¼ÂµÃ¥ÂÂ¯Ã¨ÂƒÂ½Ã£ÂÂª Web Ã£Â‚Â¢Ã£ÂƒÂ—Ã£ÂƒÂªÃ£Â‚Â±Ã£ÂƒÂ¼Ã£Â‚Â·Ã£ÂƒÂ§Ã£ÂƒÂ³Ã£ÂÂ§Ã£ÂƒÂ‡Ã£ÂƒÂ¼Ã£Â‚Â¿Ã£Â‚Â’Ã¤Â¿ÂÃ¥ÂÂ˜Ã£ÂÂ™Ã£Â‚Â‹Ã£ÂÂ¨Ã£ÂÂÃ£ÂÂ¯Ã¦Â³Â¨Ã¦Â„ÂÃ£ÂÂŒÃ¥Â¿Â…Ã¨Â¦ÂÃ£ÂÂ§Ã£ÂÂ™Ã£Â€Â‚Ã£ÂƒÂ¦Ã£ÂƒÂ¼Ã£Â‚Â¶Ã£ÂƒÂ¼Ã£ÂÂ¯Ã£ÂÂ‚Ã£Â‚Â‹Ã¦Â™Â‚Ã§Â‚Â¹Ã£ÂÂ§Ã¤Â¸ÂÃ§Â‰Â¹Ã¥Â®ÂšÃ¥Â¤ÂšÃ¦Â•Â°Ã£ÂÂ® Web Ã£Â‚ÂµÃ£ÂƒÂ¼Ã£ÂƒÂÃ£ÂƒÂ¼Ã£ÂÂ®Ã£ÂÂ„Ã£ÂÂšÃ£Â‚ÂŒÃ£ÂÂ‹Ã£ÂÂ¨Ã©Â€ÂšÃ¤Â¿Â¡Ã£ÂÂ—Ã£ÂÂ¦Ã£ÂÂ„Ã£ÂÂŸÃ£ÂÂ¨Ã£ÂÂ—Ã£ÂÂ¦Ã£Â‚Â‚Ã£Â€ÂÃ¦Â¬Â¡Ã£ÂÂ®Ã£ÂƒÂªÃ£Â‚Â¯Ã£Â‚Â¨Ã£Â‚Â¹Ã£ÂƒÂˆÃ£ÂÂ¯Ã£Â€ÂÃ¥Â‰ÂÃ£ÂÂ®Ã£ÂƒÂªÃ£Â‚Â¯Ã£Â‚Â¨Ã£Â‚Â¹Ã£ÂƒÂˆÃ£Â‚Â’Ã¥Â‡Â¦Ã§ÂÂ†Ã£ÂÂ—Ã£ÂÂŸÃ£ÂÂ®Ã£ÂÂ¨Ã£ÂÂ¯Ã¥ÂˆÂ¥Ã£ÂÂ® Web Ã£Â‚ÂµÃ£ÂƒÂ¼Ã£ÂƒÂÃ£ÂƒÂ¼Ã£ÂÂ«Ã©Â€ÂÃ£Â‚Â‰Ã£Â‚ÂŒÃ£Â‚Â‹Ã¥ÂÂ¯Ã¨ÂƒÂ½Ã¦Â€Â§Ã£ÂÂŒÃ£ÂÂ‚Ã£Â‚ÂŠÃ£ÂÂ¾Ã£ÂÂ™Ã£Â€Â‚Ã£ÂÂ™Ã£ÂÂ¹Ã£ÂÂ¦Ã£ÂÂ® We
rekramkoob 2008/11/07
*programming

google

google app engine

db
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
rekramkoob 2008/05/22
*programming

php

postgresql

db
ãƒªãƒ³ã‚¯
Introduction to DBIx::MoCo - naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
YAPC::Asia 2008 ã§ OR ãƒžãƒƒãƒ‘ã® DBIx::MoCo ã«ã¤ã„ã¦ç™ºè¡¨ã—ã¾ã—ãŸã€‚DBIx::MoCo ã¯æœ€è¿‘ã®ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€Ruby é¢¨ã®ãƒªã‚¹ãƒˆæ“ä½œã‚„ memcached ã«ã‚ˆã‚‹é€éŽçš„ãªã‚ãƒ£ãƒƒã‚·ãƒ¥ãªã©ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ http://bloghackers.net/~naoya/ppt/080516introduction_to_dbix_moco.ppt ã«ã¦ç™ºè¡¨è³‡æ–™ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚
rekramkoob 2008/05/20
perl

db

*programming
ãƒªãƒ³ã‚¯
ç¬¬ï¼–ç« ã€€PostgreSQLã«ã‚ˆã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŸºç¤Ž
rekramkoob 2008/05/20
*programming

db

postgresql
ãƒªãƒ³ã‚¯
0ã®é™¤ç®— - OKWAVE
PostgreSQLã®SQLæ–‡ã§0ã®å‰²ã‚Šç®—ã ã¨è¨ˆç®—ã‚’ã—ãªã„ã§ï¼Œ 0ã‚„Nullã‚’è¿”ã™ã‚ˆã†ãªSQLæ–‡ã‚’ä½œã‚ŠãŸã„ã®ã§ã™ãŒï¼Œ åˆ†ã‹ã‚Šã¾ã™ã‹ï¼Ÿ ä¾‹ãˆã° select field0, ( field1 / field2 ) as result; ã ã¨ã€Œfield2ã€ãŒ0ã®å ´åˆã‚¨ãƒ©ãƒ¼ãŒã§ã¦ã—ã¾ã„ã¾ã™ã€‚ field0ã¯å‡ºåŠ›ã—ãŸã„ã®ã§Whereæ–‡ã§ Where field2 <> 0 ã¯ä½¿ãˆã¾ã›ã‚“ã€‚ ã‚ªãƒ©ã‚¯ãƒ«ã§ã¯decodeã¨ã„ã†é–¢æ•°ãŒä½¿ãˆã‚‹ã‚ˆã†ã§ã™ãŒã€‚
rekramkoob 2008/05/20
*programming

sql

postgresql

db
ãƒªãƒ³ã‚¯
PHPã‹ã‚‰PostgreSQLã«å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç™»éŒ²ã™ã‚‹
PostgreSQLã«å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç™»éŒ²ã™ã‚‹éš›ã¯INSERTã‚’ä½¿ã£ã¦ä¸€ä»¶ã¥ã¤å‡¦ç†ã™ã‚‹ã‚ˆã‚Šã€COPYã‚’ä½¿ã£ã¦ä¸€æ°—ã«ç™»éŒ²ã—ãŸæ–¹ãŒå®Ÿè¡Œé€Ÿåº¦ãŒï¼ˆã‹ãªã‚Šï¼‰é€Ÿã„ã§ã™ã€‚ ãã“ã§PHPã§ã‚‚COPYæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ pg_copy_fromã‚’ä½¿ã† ç™»éŒ²ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãŒé…åˆ—ã«å…¥ã£ã¦ã„ã‚‹ãªã‚‰pg_copy_fromã ã‘ã§ä¸€æ°—ã«å‡¦ç†ã§ãã¾ã™ã€‚ é…åˆ—ã®1è¦ç´ ãŒ1ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚1è¦ç´ å†…ã§ã¯å„ã‚«ãƒ©ãƒ ã‚’ãƒ‡ãƒªãƒŸã‚¿ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯â€\tâ€ï¼‰ã§é€£çµã—ã¾ã™ã€‚ <?php $values = array(); $values[] = "1\tname1"; $values[] = "2\tname2"; $values[] = "3\tname3"; $db = pg_connect("dbname=hogedb"); pg_copy_from($db, 'table',
rekramkoob 2008/05/20
*programming

postgresql

db

php
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬8å›ž PHPã§ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ã‚¸ãƒ£ãŒæ›¸ã‘ã‚‹ï¼ŒPL/PHPç™»å ´ï¼
PostgreSQLã§ã¯æ§˜ã€…ãªè¨€èªžã‚’ä½¿ã£ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°ï¼ˆä»–ã®DBMSã§ã¯ã€Œã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ã‚¸ãƒ£ã€ã¨å‘¼ã°ã‚Œã¦ã„ã‚‹ï¼‰ã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã ã‘ã§ãªãï¼Œä»»æ„ã®è¨€èªžã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°ã‚’æ›¸ãæž çµ„ã¿(è¨€èªžãƒãƒ³ãƒ‰ãƒ©)ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒè‡ªç”±ã«è¿½åŠ ã§ãã‚‹ã€‚ã“ã®ãƒ¡ãƒªãƒƒãƒˆã‚’ç”Ÿã‹ã—ï¼ŒPostgreSQLã‚¦ã‚©ãƒƒãƒç¬¬5å›žã§ç´¹ä»‹ã—ãŸPL/Javaã‚’ã¯ã˜ã‚ï¼ŒPL/Rubyãªã©ï¼Œæ§˜ã€…ãªã‚‚ã®ãŒé–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã®ã¯Webè¨˜è¿°ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§æœ‰åãªPHPã§ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ã‚¸ãƒ£ãŒæ›¸ã‘ã‚‹PL/PHPã§ã‚ã‚‹ã€‚ ç†è€…ã‚’å§‹ã‚ï¼Œç‰¹ã«PostgreSQLã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯æ˜”ã‹ã‚‰PHPã®ãƒ•ã‚¡ãƒ³ãŒå¤šã„ã€‚PHPã®è±Šå¯Œãªæ©Ÿèƒ½ãŒã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ã‚¸ãƒ£ã¨ã—ã¦ä½¿ãˆã‚‹ã®ã§ã‚ã‚Œã°ï¼Œãã‚Œã ã‘ã§ã‚‚ãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ã•ã‚‰ã«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã«ä½œæˆã—ãŸé–¢æ•°ãŒã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ã‚¸ãƒ£ã§ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Œã°ï¼Œç„¡é§„ãªé–‹ç™ºã‚’æ¸›ã‚‰ã—ãŸã‚Šï¼ŒéŽåŽ»ã®è³‡ç”£ã‚’æ´»ã‹ã™ã“ã¨ãŒã§ãã‚‹åˆ©ç‚¹ã‚‚æœŸå¾…ã§ãã‚‹
rekramkoob 2008/05/20
*programming

postgresql

db
ãƒªãƒ³ã‚¯
DBã‹ã‚‰å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ä¸€åº¦ã«æ²¢å±±è¡¨ç¤ºã™ã‚‹å ´åˆã®é«˜é€ŸåŒ– - ãƒã‚°æ—¥è¨˜
Webã‚µãƒ¼ãƒãŒä¸€å°ã®å ´åˆã¯PHPãŒå‡¦ç†ã™ã‚‹ã‚ˆã‚Šã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§å‡¦ç†ã—ãŸæ–¹ãŒæ—©ã„ã€‚ ã‚ã¨çµ¶å¯¾çš„ãªæ™‚é–“ã€‚ä¾‹ãˆã°PHPã§è¨ˆç®—ã—ã¦ä¸€ãƒšãƒ¼ã‚¸è¡¨ç¤ºã™ã‚‹ã®ã«1ç§’ã‹ã‹ã‚ŠDBã§è¨ˆç®—ã—ã¦0.1ç§’ã‹ã‹ã‚‹å ´åˆã¯ã€Webã‚µãƒ¼ãƒãŒè¤‡æ•°ã‚ã£ã¦ã‚‚ã©ã£ã¡ã«ãƒã‚¸ãƒƒã‚¯ã‚’æŒã£ã¦è¡Œãã‹ã¯è€ƒãˆã‚‚ã®ã€‚PHPã§é›†è¨ˆå‡¦ç†ã‚’è¡Œã†ã¨ã—ã¦ã‚‚ã€çµå±€DBã«selectæ–‡ã‚’ç™ºè¡Œã™ã‚‹å›žæ•°ã¯å¢—ãˆã‚‹ã‚ã‘ã ã—ã€‚ ã¾ãåŒæ™‚ã‚¢ã‚¯ã‚»ã‚¹ã®æ•°ã ãªãã€‚æ–°è¦ã®ãƒãƒƒãƒˆã‚·ãƒ§ãƒƒãƒ—ç¨‹åº¦ãªã‚‰ä¸€ç§’é–“ã«ä½•åäººã‚‚ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã‚‹ã“ã¨ã¯ç„¡ã„ã¨æ€ã†ã®ã§DBå´ã§å‡¦ç†ã™ã‚‹ã®ãŒã„ã„ã‹ã¨ã€‚ ãŸã Ajaxã‚’ä½¿ã£ã¦ã‚‹å ´åˆã¯ã€ä¸€äººãŒä¸€ãƒšãƒ¼ã‚¸è¡¨ç¤ºä¸ã«ä½•åº¦ã‚‚ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’é€ã‚‹ã“ã¨ã«ãªã‚‹ã®ã§ãã‚Œã‚‚è€ƒæ…®ã—ãªã„ã¨ã„ã‘ãªã„ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ã†ã¡ã®å ´åˆã¯åŒæ™‚ã‚¢ã‚¯ã‚»ã‚¹ãŒå°‘ãªã„ã‹ã¤é‡ã„å‡¦ç†ã‚’è¡Œã†ã®ã§DBå´ã§è¨ˆç®—ã™ã‚‹ã‚ˆã†ã«ä¿®æ£ã€‚ ä¸»ãªå¤‰æ›´é …ç›®ã€‚ ã‚¢ã‚¯ã‚»ãƒ©ãƒ¬ãƒ¼ã‚¿ã‚’åˆ©ç”¨ã™ã‚‹ foreach ã‚’æ¸›ã‚‰ã™ åœ§ç¸®è»¢é€ã‚’è¡Œã† æ–‡å—ã‚³ãƒ¼ãƒ‰ã«E
rekramkoob 2008/05/16
*programming

php

db
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸