Myfad

星期三, 十一月 01, 2006

用Google Docs给你的博客发帖

怎样书写博客会比较方便?如果你也用Google Docs 的话,其强大丰富的编辑功能,如插入表格、特殊字符等,将使博客的更新变成一件轻松快乐的事情。你甚至无需打开博客即可轻松的发帖、改帖、删帖。
Google Docs & Spreadsheets 是Google把WritelySpreadsheets两个办公产品整合后推出的新服务,与微软的MS Word和Excel相对应。但是Docs & Spreadsheets是免费的在线软件,具有超强的在线编辑功能,你不单可以在上面写文档,制作出漂亮的电子表格,还可以邀请别人参与你的文件在线编辑。
如何用Google Docs来发帖呢?简单的说,就是在Google Docs里写帖子,然后利用它的发布功能把帖子自动张贴到博客上。
如果你有一个gmail邮箱,现在就可以去试一试。如果没有,可以赶紧申请一个大容量的gmail邮箱,邮箱地址就是你的Google账号,通过这个帐号可以享有google的各项服务。
虽然目前Google Docs & Spreadsheets尚未提供中文版本,但是完全支持中文输入,即使你不懂英文也毫不妨碍你的使用,请参见《教你如何用Google Docs给博客发帖》(待写)。

注:有需要Gmail邮箱邀请的网友,可以发邮件给我。另外,如对本文内容感兴趣,敬请留言。

                   
(放在2x2表格内的4张图片)


星期一, 十月 30, 2006

two links of svenska

Svenska 2


Svenska 1

星期日, 十月 29, 2006

Dry your eyes becks

-- by Mario Rosenstock

A sentimental song.

Listen the song

Read the full text of the sound track here .


星期六, 十月 28, 2006

problem

今天尝试把网上收藏夹放在上面。但发布出现错误。
问题症结在哪里?
1, CSS被我修改过,只是凭感觉,所以可能参数有问题?
2, 倾向于用google docs来上传帖子。几天前曾经传过2个帖子。但是昨天在docs里发现上传过的文件居然恢复成未发布状态。
然后又通过docs的出版系统发了张帖子,提示成功。会不会仍然不稳定?
3, 由于blogspot不支持主题分类功能,而del.icio.us有着很便捷的tag功能。今天尝试修改blog模版,加入del.icio.us的链接地址。应该不会在这里出问题吧?

---------------------------------------------------------------
很高兴,终于又可以发帖!
看来并不是上述原因导致。编辑帖子时发现,当选择查看帖子的功能时,竟然出现的是几个星期前写的然后删除掉的一张贴。幽灵重现?! 应该是旧贴被保存在服务器上未及时删除,以至于当我发布新帖时,系统索引出现紊乱,发布失败。

星期五, 十月 27, 2006

SQL note 1

SELECT DISTINCT col_name(s) FROM table_name WHERE col_name = ' abc ' AND (col_name = 'abc' OR col_name = 'abc') OR col_name LIKE '%xyz%' ORDER BY col1_name ASC, col2_name DESC

Operator Description
= Equal
<> Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE

Search for a pattern


SELECT col_name(s) FROM tb_name WHERE col_name IN (value1, value2,...)
e.g. SELECT * FROM Persons
WHERE LastName IN ('Hansen','Pettersen')

The following syntax is weird, according to different database system.
SELECT col_name(s) FROM tb_name WHERE col_name BETWEEN value1 AND value2, select data when col_name = value1?
SELECT col_name(s) FROM tb_name WHERE col_name NOT BETWEEN value1 AND value2, select data when col_name = value2?

UPDATE tb_name SET col_name(s) WHERE col_name = 'abc'

Alias syntax:
SELECT col_names AS col_alias_names FROM tb_name;
SELECT col_names FROM tb_name AS tb_alias_name;
e.g. SELECT LastName AS Family, FirstName AS Name FROM Persons;
SELECT LastName, FirstName FROM Persons AS Employees;

JOIN:
Tables in a database can be related to each other with keys, which means every table must have a primary key. A primary key is a column or combined columns with a unique value for each row.

INNER JOIN:


SELECT field1, field2, field3
FROM first_table
INNER JOIN second_table

LEFT JOIN:




ON first_table.keyfield = second_table.foreign_keyfield