Project Description:
Require development of a Joomla 1.5 component that has elements querying both a MySQL and a MSSQL database and displays the returned data in joomla paginated format.
There should be a configuration options in the admin backend to specify alternate database name, and username and password variables, as the database will not necessarily be the standard Joomla database.
The code should be well documented.
The database structure is detailed below:
Table Name: DataTable
Field 1: ID INT - sequence/primary key
Field 2: FieldName VARCHAR(15)
Field 3: FieldDescription VARCHAR(MAX)
Field 4: CreatedDate DATETIME
Field 5: CreatedBy VARCHAR(50)
The front end should be able to return basic data in the following column format:
ID, FieldName, FieldDescription, CreatedDate, CreatedBy
Additional Project Description:
07/19/2010 at 18:08 ECT
The pagination I am looking for would look like the one in the link here:
http://docs.joomla.org/Using_JPagination_in_your_component
I will also be looking for development to re-skin a Joomla site soon.