-
Generate insert scripts for SQL Server tables with Perl
Here is a quick hack with Perl to generate insert statements to reproduce data already exist in a given table. It is similar to results mysqldump generates. A few things worth mentioning here: 1. This script uses a text file, TableList, that contains a list of tables that you want insert statements created. Each line…
-
ActiveState Perl 5.10, Windows XP, and DBD-mysql
A few months ago I installed ActivePerl 5.10 on a Windows XP Pro workstation. Next I tried to install DBD::mysql using CPAN, it failed. When I browsed modules via ppm, a GUI in this version of ActiveState Perl on Windows, DBD::mysql was not listed as an available module. I then downloaded the source code, manually…
-
Quick way of finding version number of a Perl module
Run this on command line [sourcecode language=”text”] perl -MMyModule -le ‘print “$MyModule::VERSION\n”‘ [/sourcecode] For instance, to find out the version number of DBI installed on the machine, run [sourcecode language=”text”] perl -MDBI -le ‘print “$DBI::VERSION\n”‘ [/sourcecode] To find out the version of DBD::mysql, run [sourcecode language=”text”] perl -MDBD::mysql -le ‘print “$DBD::mysql::VERSION\n”‘ [/sourcecode] One caveat: this…
-
WordPress sidebar sinking to the bottom issue in IE fixed
As I mentioned here, I’ve noticed recently that when viewing my site, a WordPress blogging page, in Internet Explorer (I tried IE 6), the sidebar actually appears at the bottom of the page. That was really annoying, because the main reason I redesigned the sidebar was to help people navigate: it has category, archive, blog…
-
你用什么方法输入中文？
我虽然可以在Linux或Unix上活动，也用Perl，Vim，正则表达等Unix上出来的东西，但不算专家。为进一步提高自己在这方面的经验水平，我决定在家用Ubuntu，而不仅仅只是用VMWare的虚拟机器。 我在这儿介绍过怎样给英文版的Ubuntu安装中文输入软件。装上之后，发现这个软件提供好几种输入方法。简体的有二笔，二笔－QS，五笔，自然码，和智能拼音。繁体的输入法就更多了，我听说过仓颉和注音，而在下图里罗列的其它方法，以前还真没以任何方式接触或听说过。我用的是简体智能拼音。 Ubuntu上的简体中文输入法 Ubuntu上的繁体中文输入法 在Windows上，我用Google Pinyin，但我对其它中文输入法一直都很好奇：它们都有什么优缺点，哪一个更快（当然会因人而异），因为我只知道一种。不知读者朋友有什么评论和建议。 也曾想过用听写软件代替手输入中文，但从未尝试过，不知这种软件是否成熟。