Lighthouse Database Administration Software is a ColdFusion-based data management system that offers add, edit, delete and search functionality over any database table, with a few simple lines of code. With Lighthouse Database Administration Software, sophisticated systems to manage press releases, products, users, or virtually any type of content can be built in a matter of minutes.

*NEW* - Watch a Video Demonstration of the Software

For detailed information on Lighthouse Database Administration Software, including the API, system requirements, installation, and licensing, please view the Reference Manual. We also encourage you to try our demo application to experience Lighthouse first-hand.

Feature-Rich
Lighthouse offers all of the core features you would expect from a content management system.  Below are just a few of the product's features.

• Add, Edit, Delete, View, Search, and Export functionality are automatically built by Lighthouse.
• Support for text fields, text areas, HTML Edit boxes, select lists, multiple-select lists, checkboxes, checkbox groups, radio buttons, pop-up selects, multiple pop-up selects, and file uploads.
• Built-in HTML Editor enables rich formatting of content without having to know HTML.
• Automatic data validation ensures that entries will conform to the type of data you need. Data validation rules include checks for required fields, valid numbers, valid dates, valid email addresses, etc.
• Flexible column display options on the "View" screen enables users to view only the fields they are interested in and sort the data on any column.
• Integrated spell check engine ensures that your content does not contain any misspellings.

Simple to Use
Lighthouse offers an easy-to-use interface that is friendly to even novice web users. All Lighthouse pages consist of simple forms for adding or editing content, and grid-based displays for data. In addition, Help Text can be set up for each field to ensure that users know what data to put in each field when adding or editing content.

Simple to Manage
Creating a new tool to manage content (Articles, Products, Press Releases, or FAQs, for instance) is as easy as adding one line of code for each field you would like to manage through the system. Non-technical users with minimal database experience will be able to set up powerful content management systems in no time.

Sample Code
The following code is all that is needed to manage content using Lighthouse Database Administration Software. In this example, we will be managing FAQs. Our FAQ data consists of an ID (the primary key), a question, and an answer. The code below would provide add, edit, delete, search, view, export to Excel, etc. functionality for your content.

<lh:MS_Table table="tbl_FAQs" dsn="myDB">
<lh:MS_TableColumn ColName="FAQID" DispName="ID" type="integer" PrimaryKey="true" />
<lh:MS_TableColumn ColName="Question" FormFieldParameters="size=50" maxlength="100" Required="Yes" searchType="contains" />
<lh:MS_TableColumn ColName="Answer" type="textarea" allowHTML="yes" FormFieldParameters="rows=5 cols=50" maxlength="500" Required="Yes" />
</lh:MS_Table>

Supported Platforms

Server: ColdFusion MX 6.1 and higher

Database: SQL Server 2000, SQL Server 2005, MySQL 4.1+

Web-based Client: Internet Explorer 5.5 and higher, Firefox 1.5 and higher.