Occasionally designers may want to center content in a web page and they want it centered both horizontally and vertically. The traditional method for doing that is to put the content into a table and to assign a values of 100% to the table's HEIGHT attribute and center to the ALIGN attribute. Recently, that approach has become more problematic.

You may have used this before and had it work but now, for some reason, new pages you create won't center vertically. You may be changing pages from standard HTML to XHTML and now tables don't respect the 100% HEIGHT attribute. Read on.

There are a few things you need to know here. There is not now, nor has there ever been a HEIGHT attribute for tables. Scour the HTML specifications and you will not find HEIGHT among the attributes for the table tag. The fact is, table height is invalid code. If you attempt to validate a page where you have assigned a height to a table, it will fail. Assigning a height to the table tag is not the answer. You can, however, legally assign a height using CSS.

Rendering Modes

But why, you ask, did it used to work and now it doesn't? Without going into a lot of specifics, the answer is that it has to do with the browser's rendering mode as determined by the document's DOCTYPE. You can read a lot more about that subject on Eric Meyer's companion site for his book Eric Meyer on CSS. The point is that browsers, rendering pages in quirks mode, expand tables to fill the 100% HEIGHT. Browsers rendering pages in standards compliance mode don't. That means that, if a page has a full and proper DOCTYPE, including the URI, or if it uses an XHTML DOCTYPE, the browser will render the page in standards compliance mode. If a page does not have a DOCTYPE, or if it has a partial DOCTYPE without the URI, the the browser will render the page in quirks mode. Newer web design software has begun inserting the full DOCTYPE in pages, so the pages get rendered in standards compliance mode.

查看更多...

ACCESSdb is a JavaScript library used to dynamically connect to and query locally available Microsoft Access database files within Internet Explorer. All you need is an .mdb file; Access does not even need to be installed! All of the SQL queries available in Access can be executed on the fly, including Selects, Inserts, Updates, and JOINs. Results are output in several customizable formats including JSON, XML, and HTML.

Project Home | Downloads | Subversion

中文翻译：http://www.cnblogs.com/phaibin/archive/2009/06/09/1499687.html

下载：Joe Celko's.Trees and Hierarchies in SQL for Smarties.pdf

其它资源：http://www.itpub.net/thread-1233846-1-1.html

Introduction

Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table.

查看更多...

不多说了.非常简单.

建一个ASP函数:
http://jorkin.reallydo.com/article.asp?id=653

ASP代码:
<%
sNewOrder = NewID("id") '这里的ID是数据类型为数字(最好用自动编号列)
Set ors = Exec("Select Top 20 id,compname,fund,foundyear," & sNewOrder & " AS NewID From company where fund>100 order By " & sNewOrder)
Trace(oRs)
%>

说明：这个方法如果在记录集过大的时候也会很费时间，所以请先通过Where条件筛选后再随机排序。

实例下载

Review of 10 jQuery datagrid plugins...

jqGrid

HOME | DEMO | Last Update: May 2009

• paging functions
• sortable column headers
• add, edit, delete & search records
• accepts XML, JSON, array or user data as input
• multiple selection of rows
• sub grid & grid details
• support UI themes
• UI Datepicker integration
• API
• big size

Flexigrid

HOME | Last Update: July 2008

• paging functions
• sortable column headers
• add, edit, delete & search records
• accepts XML, JSON, array or user data as input
• nice design
• API
• don't support last jQuery version

Ingrid

HOME | Last Update: November 2007

• paging functions
• sortable column headers
• nice design
• project is die

查看更多...

JavaScript Framework Matrix是一个比较当前各种流行JavaScript框架功能的矩阵。所举的例子几乎涵盖了所有的功能，并提供链接指向原始文档。

http://matthiasschuetz.com/javascript-framework-matrix/en/

目前支持的库:

• jQuery
• MooTools
• The Dojo Toolkit
• Prototype
• Script.aculo.us
• Ext.JS
• Adobe Spry
• BBC Glow
• Yahoo UI! Library

这是个很实用的小技巧,下面的代码可以使浏览器从缓存里读取图片.

#preloadImages {
    width: 0px;
    height: 0px;

查看更多...

查看更多...

After looking for awhile for a script that will crop your image in the browser I decided to put a list together. I found various types of scripts that will accomplish this. The list below is a list of image cropping scripts.

1. cfImageCropper - This script is written in Coldfusion. The Demo of this script works very well and the code is very simple to implement.
2. jsCropper - This javascript image cropping script is based on the Prototype JavaScript framework and script.aculo.us. jsCropper is one of my favorite copping script. It is very easy to use and its a great unobtrusive script. jsCropper has tons of great features you should check it out.
3. mooImageCrop - mooImageCrop is based on the mootools framework and php. It is very easy to implement.
4. Image Crop - This is a great script written in Javascript and PHP. It requires the install of ImageMagick server component.
5. Ajax Image Editor - Is a very powerful image editor script that allows you to crop, resize, and rotate the image. It is fairly easy to implement and it isn’t written with any frameworks.
6. Flash Image Crop - Is a very nice flash image crop tool written in Actionscript and PHP. The only problem I have with this script is that you have to use the space bar to accept the cropped area and not the enter key. But overall it works very well.
7. Flash Based Cropping tool - This tool is also written in Actionscript and PHP is a very nice script. You can also resize the image with this script.
8. MooCrop -MooCrop is an Image Cropping utility that uses mootools javascript framework.  MooCrop works very fast and you can even edit the color of the mask.

In 2005 when Google implemented Google Suggest, Ajax took off. Every web developer was trying to duplicate what Google accomplished. Its now 2008 and there are tons of ways to accomplish Google Suggest. Below is a list of 10 Auto Complete Scripts with various frameworks. The list below is in no particular order.

1. jqac - Is jQuery plugin for autocomplete. jqac is very easy to implement and has a scrollable suggests list. It also allows for multiple suggests support and is tested in all major browsers.
2. AutoComplete (for Prototype) - This is a script built for the prototype framework and it allows multiple column support. It also is a very nice style built with it.
3. YUI Autocomplete - This script is built with the Yahoo! UI Library. The AutoComplete features navigation of the suggestion box via up/down arrow keys. It is very easy to configure with the Yahoo! UI Library.
4. AJAX autocomplete - Is built with Easy Ajax framework by Jim Roos. It features the the up and down navigation and is fairly easy to implement.
5. Another AutoComplete (prototype) - This prototype framework autocomplete also uses scriptaculous. It has a nice fade in effect when the suggest box appears. It is easy to implement and works with XML data.
6. AutoComplete (mootools) - A MooTools Autocomplete widget that creates a unobtrusive and customizable suggestion box from variable data sources. It also has nice fade in effect.
7. dhtmlxCombo - Is a different from the rest of these. dhtmlxCombo can be used in four modes: an editable select box, a read-only select box, a filter drop down box, and an autocomplete. It also allows for you to add icons to your drop down boxes.
8. AutoSuggest - This AutoSuggest script uses no frameworks. The script allows you to navigate either with the up or down arrows or just click. The script size is under 10k, it even has a fade in effect, and a great 2.0 style.
9. Spry Auto Suggest - This Auto Suggest script is written with Adobe’s spry framework. It has works with all sorts of data formats and languages. It supports keyboard navigation and also allows for multiple suggestions.
10. ASP.Net AutoComplete - This script allows you to add AutoComplete to ASP.Net without using a webservice. This is a great way to add Autocomplete feature to ASP.net