|
NOTE - BugFix Available for those who downloaded prior to
11/25/2001.
What
is GenericDB?
GenericDB is an open source
tool which allows developers to put nearly any database on the web for
viewing and/or editing with very little code. The GenericDB engine is
written with Microsoft Active Server Pages (ASP) for IIS 4. It has been
tested successfully on NT 4, Personal Web Server (recommend update to
MDAC 2.0) and ChiliASP for UNIX.
GenericDB was developed by Eli
Robillard
Web Site: http://www.genericdb.com/
What is GenericCalendar?
- Follows the concept of GenericDB (GenericCalendar.asp)
- Displays records from a data table in a formatted
calendar view...
Click here
for a sample! (Check
January, February, March 2001)
- Supports events that occur on a single day or
multiple days...
- Supports live links to contact & web page for
the event...
(Make the
changes described in the GenericDb Mailing List
that will allow html
tags to be entered into the table...)
- Uses a config file...
(vEventCalendar.asp)
- Uses additional session variables to set formatting
information...
Session("dbMonthYearFormPos")
= "Bottom" | "Top"
Session("dbInMonthCellColor")
= "#009999"
Session("dbNotInMonthCellColor")
= "#999999"
Session("dbCalendarBorderColor")
= "#009966"
Session("dbCalendarBorderTextColor")
= ""
Session("dbCalendarDateTextColor")
= ""
Session("dbCalendarEventTextColor")
= ""
Session("dbCalendarDOWTextColor")
= ""
Session("dbPrevImage")
= "prev.jpg"
Session("dbNextImage")
= "next.jpg"
Session("dbGenericImagesPath")
= "images/"
Note: The
calendar view uses a couple of images for previous and next (month)
links. I have included a directory named 'images' that has a whole
bunch of these you can use... or make your own to exactly match your
site's look and feel (if you don't specify an image, a text link is
used instead.)
- Uses the following include files...
GenericMonthYearForm.asp
- An include for form-based control of the month
and year displayed by GenericCalendar.asp
GenericCodeLibrary.asp - An
include file that has a couple of functions used by
GenericCalendar.asp
- Uses an Event table 'tblEvents'
in a database...
Note: 12/1/2000
- Added a
second version of the MS Access database 'Events97.mdb' for Access 97
users. The original database 'Events.mdb' is a MS Access 2000 file.
| EventID |
Long Integer |
4 |
| StartDate |
Date/Time |
8 |
| EndDate |
Date/Time |
8 |
| EventStartTime |
Text |
50 |
| EventEndTime |
Text |
50 |
| EventTitle |
Text |
100 |
| EventDetails |
Memo |
|
| EventURL |
Text |
100 |
| EventContact |
Text |
75 |
| Remote_computer_name |
Text |
255 |
| User_name |
Text |
255 |
| Browser_type |
Text |
255 |
| Timestamp |
Date/Time |
255 |
- I have also included the config file to
add/edit/delete from tblEvents
(aedEvents.asp)
STILL TO BE DONE...Integrate
with GenericLanguage.asp
Download everything needed for
GenericCalendar in one zip file.
|
