2007-08-01ãã1ã¶æéã®è¨äºä¸è¦§
DBã«Perlã®DBIã¢ã¸ã¥ã¼ã«ã使ã£ã¦Insertããã¨ãã¯ãä¸è¨ã®ããã«ãã¦ã¾ããã ãã¼ãã«åã¯TableName,ã«ã©ã åã¯hoge1,hoge2,hoge3ã¨ããå ´å my $dbcon = DBI->connect(....); my $dbInsert = $dbcon->prepare(q/insert into TableName (hoge1,hoge2,hoge3â¦
ãã¾ã家ã®PCãã¹ã¯ã¯ããªãåºããã®ãè²·ã£ãã®ã§å¿«é©ãªã®ã§ãããæ¤ åãæã®å®ãã¡ãã¡ãªãã¤ãªã®ã§ã家ã§ããããããã°ã©ãã³ã°ããã¦ããã¨ããªãç²ãããã¨ãããã¨ã§ãè¯ãæ¤ åãæ¢ãã¦ã¿ãã 5ä¸ä»¥ä¸ã§ã誰ãè¯ãæ¤ åãç¥ã£ã¦ããæãã¦ãã ããã åâ¦
æè¿ãå°èª¬ãããã¤ãèªãã ã®ã§ããã®ææ³ãã¤ã®ãªã¹ã®æ è¡ã®ç§»åæéã«ã»ã¨ãã©èªãã ãã ãã©ã帰ã£ã¦ããããã®ç±ãå·ããªãã¦æ¬ãè²·ãã«è¡ã£ã¦ä¸æ°ã«èªãã ããã¾ããã åæ°åã (è¬è«ç¤¾æ庫) åæ°åã ã¯ãå®è©±ããã¨ã«ããå°èª¬ã§ãå®å¨ããä¼ç¤¾ãããâ¦
é·ãæ ãçµãããè¸ãæãæ¥æ¬ã«æ»ã£ã¦ãã¾ãããã¾ãã40度ãªãã¦ä¿¡ããããªãæ¥ãé¿ãããã®ãè¯ãã£ããã¤ã®ãªã¹ã¯ããã£ã±ãæã空ãå¤ãã¦ãçµæ§é¨ãéã£ã¦ã¾ãããããã¦å¯ãã£ãã»ã»ã»ç¹ã«ã¹ã³ããã©ã³ããªãã¦åã®æ¹ã ããããã³ãã³ãããããªãå¯â¦
ï¼é±éãããã¤ã®ãªã¹ã«è¡ã£ã¦ãã¾ããåã¤ã®ãªã¹ã§ãã ã¨ãããããèªç©ºå¸ã ãã1ã¶æåã«åã£ã¦ãå¾ã¯èªåã§ã¨ãããã©ã³ããã®1ã¶æãå¤ä¸ã«å®¿ã調ã¹ã¦äºç´ããããã¬ã³ã¿ã«ã¼ãæé ãããã¨å¤§å¿ããã§ã楽ããããªãã©ã³ãã§ããããã¾ããã宿ã®äºç´æâ¦
ã¡ãã£ã¨è¨³ãã£ã¦ãsjisã®webã¢ããªãä½ã£ã¦ã¾ããDBã¯Postgres(EUC_JP), è¨èªã¯Perl (SJIS)ãHTMLãSJISã Postgresãsjisãã¤ãã£ãã«ãããã£ããã©ãeucãutf8ãããµã¼ãå´ã®ã¨ã³ã³ã¼ãã£ã³ã°ã¯å¯¾å¿ãã¦ããªãã®ã§ãã¯ã©ã¤ã¢ã³ãã¨ã³ã³ã¼ãã£ã³ã°ãsjisâ¦