Mock Objects

http://java.sun.com/developer/Books/javaprogramming/Massol/massol_ch07.pdf

Obtaining VIEW Definitions

• MySQL: http://dev.mysql.com/doc/refman/5.1/en/show-create-view.html, http://dev.mysql.com/doc/refman/5.1/en/views-table.html
• Oracle: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2117.htm
• SQL Server: MS supports information_schema but view_definition column is nvarchar(4000) and returns null if it's bigger.  Need to use sp_helptext (Transact-SQL) (http://msdn.microsoft.com/en-us/library/ms176112.aspx).  http://joseph.randomnetworks.com/archives/2006/03/21/overcoming-the-limitation-of-information_schemaviews-in-sql-server-2000/
• PostgreSQL: Use pg_views - http://www.postgresql.org/docs/8.0/static/view-pg-views.html 
• DB2: SYSCAT.VIEWS - http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001068.htm

Potentially very useful book for JDBC/mysql/oracle:

http://library.books24x7.com.ezproxy.rit.edu/toc.asp?site=K7ECY&bookid=14651

- also at the RIT library

Cross Browser JS support

Use jquery things we have found that break IE are:

• setting innerHTML on a DOM element (for example el.innerHTML="hello") should become jQuery(el).html("hello")
• getting innerHTML of a DOM element (for example var text = el.innerHTML; ) should become jQuery(el).text()
• Getting the index of an element in an array using indexOf (for example array.indexOf('hi')) should become jQuery.inArray('hi', array);