The reason I am doing mySQL is that I can easily create the
input portion in the cgi script once I get the output I'm 
looking for. I should have probably not even mentioned
Access as the input side is a no-brainer for me in Perl.
I guess I am just used to having all my db's on the server
(mysql), and just quickly linking up via myodbc for quick
development. All output, however, is always on our webserver.

As a side note, I've been playin with GD::Graph in Perl
to get some pie/bar charts out of mysql. Neat stuff :-)

I think I am just going to take a stab at it myself as see
what turns out. 

Mike

On Thu, Jul 27, 2000 at 01:35:10PM -0700, Mike Cantrell wrote:
 I don't know of anything that does specifically what you need as far as an
 automagic calender/database solution but I'm not sure why you'd use mySQL
 for something that's already in a Access database unless it gets failry
 large or performance and high stability are issues.
 
 1) The DBI:ODBC module used along with UnixODBC for the driver would provide
 direct access to the access database eliminating the need for a 3rd
 database. If the access database is on a different machine on the network,
 you can get a free limited license copy of Easysoft ODBC bridge at
 http://www.easysoft.com that will allow direct access over the network.
 
 2) You should be able to find lot's of interesting modules to help you with
 the date stuff here:
 
 http://www.cpan.org/modules/by-module/Date/
 
 There might even be some nice calendar stuff in there somewhere. I havn't
 had to deal w/ any of them before so I'm not sure what's available.
 
 Regards,
 Mike Cantrell
 
 
 ----- Original Message -----
 From: "Lucas Vogel" <lvogel@exponent.com>
 To: <plug-discuss@lists.PLUG.phoenix.az.us>
 Sent: Thursday, July 27, 2000 12:51 PM
 Subject: RE: perl->php- Calendar
 
 
 > I know Zope has a Calendar control that you can slap into Zope apps that
 you
 > could probably build in a day, but you were looking for php/perl so I
 guess
 > it's not very helpful...
 >
 > > -----Original Message-----
 > > From: Mike Starke [mailto:mgcon@neta.com]
 > > Sent: Thursday, July 27, 2000 12:49 PM
 > > To: plug-discuss@lists.PLUG.phoenix.az.us
 > > Subject: perl->php- Calendar
 > >
 > >
 > > I have three conferance rooms which we have sheets outside
 > > the door for the folks the reserve the room.
 > >
 > > I was just asked to come up with a web page solution which shows the
 > > schedules.
 > >
 > > What I kind of had in my mind was a perl-mysql solution. I'd like
 > > to set up the receptionist with a small MS ACCESS front-end to enter
 > > the times requested, and then have the cgi script automagically
 > > pull up the schedule for the room.
 > >
 > > Am I better off doing this from scratch, or does anyone know of a
 > > simple php or perl script that someone has already done?
 > >
 > > Doesn't look like a big project, I just hate to re-invent the wheel.
 > >
 > > Mike
 > > mgcon@getnet.com
 > > http://www.getnet.com/~mgcon
 > > Phoenix, AZ
 > > USA
 > >
 > >
 > > _______________________________________________
 > > Plug-discuss mailing list  -  Plug-discuss@lists.PLUG.phoenix.az.us
 > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
 > >
 >
 > _______________________________________________
 > Plug-discuss mailing list  -  Plug-discuss@lists.PLUG.phoenix.az.us
 > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
 
 
 _______________________________________________
 Plug-discuss mailing list  -  Plug-discuss@lists.PLUG.phoenix.az.us
 http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

-- 
V/R
Mike Starke
mstarke@mobl.com
public key "http://www.neta.com/~mgcon/downloads/mstarke_public.txt"

chgrp -R USMC /home/*